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;

select * from dba_profiles where profile='DEFAULT';

audit session whenever not successful;

set lines

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#+/,'yyyy-mm-dd hh24:mi:ss') from aud$ where returncode= order by ntimestamp# asc;