SQL> select user,name,type# from user$ order by 1;
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS SYS 1
SYS PUBLIC 0
SYS CONNECT 0
SYS RESOURCE 0
SYS DBA 0
SYS SYSTEM 1
SYS SELECT_CATALOG_ROLE 0
SYS EXECUTE_CATALOG_ROLE 0
SYS DELETE_CATALOG_ROLE 0
SYS OUTLN 1
SYS EXP_FULL_DATABASE 0
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS IMP_FULL_DATABASE 0
SYS LOGSTDBY_ADMINISTRATOR 0
SYS DBFS_ROLE 0
SYS DIP 1
SYS AQ_ADMINISTRATOR_ROLE 0
SYS AQ_USER_ROLE 0
SYS DATAPUMP_EXP_FULL_DATABASE 0
SYS DATAPUMP_IMP_FULL_DATABASE 0
SYS ADM_PARALLEL_EXECUTE_TASK 0
SYS GATHER_SYSTEM_STATISTICS 0
SYS JAVA_DEPLOY 0
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS ORACLE_OCM 1
SYS RECOVERY_CATALOG_OWNER 0
SYS SCHEDULER_ADMIN 0
SYS HS_ADMIN_SELECT_ROLE 0
SYS HS_ADMIN_EXECUTE_ROLE 0
SYS HS_ADMIN_ROLE 0
SYS GLOBAL_AQ_USER_ROLE 0
SYS OEM_ADVISOR 0
SYS OEM_MONITOR 0
SYS DBSNMP 1
SYS APPQOSSYS 1
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS WMSYS 1
SYS WM_ADMIN_ROLE 0
SYS JAVAUSERPRIV 0
SYS JAVAIDPRIV 0
SYS JAVASYSPRIV 0
SYS JAVADEBUGPRIV 0
SYS EJBCLIENT 0
SYS JMXSERVER 0
SYS JAVA_ADMIN 0
SYS XS$NULL 1
SYS EXFSYS 1
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS CTXSYS 1
SYS CTXAPP 0
SYS XDB 1
SYS ANONYMOUS 1
SYS XDBADMIN 0
SYS XDB_SET_INVOKER 0
SYS AUTHENTICATEDUSER 0
SYS XDB_WEBSERVICES 0
SYS XDB_WEBSERVICES_WITH_PUBLIC 0
SYS XDB_WEBSERVICES_OVER_HTTP 0
SYS ORDSYS 1
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS ORDDATA 1
SYS ORDPLUGINS 1
SYS SI_INFORMTN_SCHEMA 1
SYS MDSYS 1
SYS ORDADMIN 0
SYS OLAP_XS_ADMIN 0
SYS OLAPSYS 1
SYS OWB_USER 0
SYS CWM_USER 0
SYS OLAP_USER 0
SYS MDDATA 1
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS SPATIAL_WFS_ADMIN 0
SYS SPATIAL_WFS_ADMIN_USR 1
SYS WFS_USR_ROLE 0
SYS SPATIAL_CSW_ADMIN 0
SYS SPATIAL_CSW_ADMIN_USR 1
SYS CSW_USR_ROLE 0
SYS FLOWS_FILES 1
SYS APEX_PUBLIC_USER 1
SYS APEX_ADMINISTRATOR_ROLE 0
SYS APEX_030200 1
SYS OWBSYS 1
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS OWBSYS_AUDIT 1
SYS OWB$CLIENT 0
SYS OWB_DESIGNCENTER_VIEW 0
SYS _NEXT_USER 0
SYS SCOTT 1
SYS TEST 1
SYS SOURCE_TEST 1
SYS A 0
SYS TC 1
SYS CCC 1
SYS SYSMAN 1
USER NAME TYPE#
------------------------------ ------------------------------ ----------
SYS MGMT_USER 0
SYS MGMT_VIEW 1
SYS AAA 1
SYS AUDIT_TEST 1
SYS BBB 1
SYS CUBE1 0
SYS TTT 1
SYS OPS$LK 1
SYS TPCC 1
SYS TTTT 1
98 rows selected.