Query to display Non Default Oracle Database users

 SELECT username, account_status, profile FROM dba_users WHERE username NOT IN ( 'SYS', 'SYSTEM', 'OUTLN', 'XDB', 'DBSNMP', 'APPQOSSYS', 'APEX_040000', 'ORDDATA', 'WMSYS', 'DGSYS', 'CTXSYS', 'MDSYS', 'OLAPSYS', 'ORDDATA', 'SYSMAN', 'RMSYS', 'SPATIAL_CSW_USER', 'SPATIAL_WMS_USER', 'SPATIAL_WFS_USER', 'SPATIAL_WMS_USER', 'XDB', 'MDSYS' ) ORDER BY username;