sqlplus "/as sysdba" 或者 sqlplus /nolog --不在cmd或者terminal当中暴露密码的登陆方式 conn /as sysdba
查看用户信息
select username,lock_date,profile,EXPIRY_DATE from dba_users order by EXPIRY_DATE desc;
查看默认PROFILE的策略
select * from dba_profiles where profile='DEFAULT';
audit session whenever not successful; set lines 200 col userhost for a20 col COMMENT$TEXT for a30 col SPARE1 for a20 col NTIMESTAMP# for a35 select sessionid,userid,userhost,comment$text,spare1,to_char(ntimestamp#+1/3,'yyyy-mm-dd hh24:mi:ss') from aud$ where returncode=1017 order by ntimestamp# asc;