Check for Active Schema Owner Account

select distinct owner from dba_objects, dba_users
where owner not in
('SYS','SYSTEM','MDSYS','CTXSYS',
'ORDSYS','ORDPLUGINS','AURORA$JIS$UTILITY$',
'ODM','ODM_MTR','OLAPDBA','OLAPSYS','MTSSYS',
'OSE$HTTP$ADMIN','OUTLN','LBACSYS',
'PUBLIC','DBSNMP','RMAN','WKSYS',
'WMSYS','XDB')
and owner = username
and account_status not like '%LOCKED';