12c以前看经验
12c以后新增了一个字段可以识别

SELECT username,account_status from dba_users where ORACLE_MAINTAINED='Y';

USERNAME ACCOUNT_STATUS

------------------------------ --------------------------------

SYS OPEN

SYSTEM OPEN

XS$NULL EXPIRED & LOCKED

OJVMSYS LOCKED

LBACSYS LOCKED

OUTLN LOCKED

SYS$UMF LOCKED

DBSNMP LOCKED

APPQOSSYS LOCKED

DBSFWUSER LOCKED

GGSYS LOCKED

ANONYMOUS EXPIRED & LOCKED

CTXSYS EXPIRED & LOCKED

DVF LOCKED

DVSYS LOCKED

GSMADMIN_INTERNAL LOCKED

MDSYS LOCKED

OLAPSYS LOCKED

XDB LOCKED

WMSYS LOCKED

GSMCATUSER LOCKED

MDDATA LOCKED

REMOTE_SCHEDULER_AGENT LOCKED

SYSBACKUP LOCKED

GSMUSER LOCKED

GSMROOTUSER LOCKED

SYSRAC LOCKED

SI_INFORMTN_SCHEMA LOCKED

AUDSYS LOCKED

DIP LOCKED

ORDPLUGINS LOCKED

ORDDATA LOCKED

SYSKM LOCKED

ORACLE_OCM LOCKED

ORDSYS LOCKED

SYSDG LOCKED

36 rows selected.