Search This Blog

Total Pageviews

Sunday, 17 July 2011

Oracle Default user's info

some Oracle Default user



('SYS','SYSTEM','OUTLN','SCOTT','ADAMS','JONES','CLARK',
'BLAKE','WOOD','STEEL','CLOTH','PAPER','HR','OE','SH','OE','SH',
'DEMO','ANONYMOUS','AURORA$ORB$UNAUTHENTICATED','AWR_STAGE',
'CSMIG','CTXSYS','DBSNMP','DIP','DMSYS','DSSYS','EXFSYS','LBACSYS',
'MDSYS','ORACLE_OCM','ORDPLUGINS','ORDSYS','PERFSTAT',
'TRACESVR','TSMSYS','XDB')




'SYS',
'SYSTEM' ,
'OUTLN' --- OUTLN user schema to support Plan Stability. The OUTLN user acts
'SCOTT', ---?/rdbms/admin/utlsampl.sql
'SCOTT',
'ADAMS',
'JONES',
'CLARK',
'BLAKE',
'HR', --(Human Resources) ---/demo/schema/mksample.sql
'OE', --(Order Entry)
'SH', --(Sales History)
'DEMO', -- ?/rdbms/admin/demo.sql
'ANONYMOUS', -- Used by the PL/SQL gateway that enables a Web browser to invoke a PL/SQL stored procedure through an HTTP listener.
'AURORA$ORB$UNAUTHENTICATED',---Used for users who do not authenticate in Aurora/ORB
'AWR_STAGE', ---?/rdbms/admin/awrload.sql
'CSMIG', --- Character Set Scanner user named CSMIG
'CTXSYS', -- ?/ctx/admin/dr0csys.sql
'DBSNMP', -- ?/rdbms/admin/catsnmp.sql
'DIP', -- ?/rdbms/admin/catdip.sql,
'DMSYS', -- Data Mining user ?/rdbms/admin/odmcrt.sql called from dminst.sql
'DSSYS', -- Oracle Spatial
'EXFSYS', --?/rdbms/admin/exfsys.sql,
'LBACSYS', --?/rdbms/admin/catlbacs.sql, called from catols.sql
'MDSYS', --?/ord/admin/ordinst.sql
'ORACLE_OCM', -- ?/rdbms/admin/catocm.sql,
'ORDPLUGINS', -- ?/ord/admin/ordinst.sql
'ORDSYS', --?/ord/admin/ordinst.sql
'PERFSTAT', --?/rdbms/admin/statscre.sql
'TRACESVR', --?/rdbms/admin/otrcsvr.sql
'TSMSYS', --?/rdbms/admin/cattsm.sql,
'XDB') -- ?/rdbms/admin/catqm.sql Owner of objects for XDB system



select dba_segments.owner,segment_name as table_name,sum(dba_tables.num_rows) as total_rows,sum ((bytes/1024/1024)) as total_mb from dba_segments,dba_tables
where dba_segments.owner not in
('SYSTEM','SYS','OUTLN','WMSYS','ORDSYS','MDSYS','CTXSYS','SQLTXPLAIN','XDB','DBSNMP','ADMN','SYSMAN','EXFSYS','TRCANLZR','APPQOSSYS','SH','CSMIG','PERFSTAT','TRCANLZR')
and segment_type IN ('TABLE', 'TABLE PARTITION')
and dba_tables.table_name=dba_segments.segment_name
and dba_tables.owner=dba_segments.owner
group by dba_segments.owner,segment_name
order by total_mb desc ;

No comments:

Oracle DBA

anuj blog Archive