1. 用户健康检查

• 11 g 或12c 非容器数据库

col name for a30
col username for a20
col account_status for a20
set linesize 400
select 
        username
        ,account_status
        ,lock_date
        ,created
from dba_users
order by username;

• 12c容器数据库

col name for a30
col username for a20
col account_status for a20
set linesize 400
select
        c.name
        ,username
        ,account_status
        ,lock_date
        ,created
from cdb_users u ,v$containers c
where u.con_id = c.con_id
order by c.name, u.username;