Object details of a database

set linesize 145
set pagesize 1000
set trimout ons
et trimspool on
Set Feedback off
set timing off
set verify off
prompt
prompt -- ----------------------------------------------------------------------- ---
prompt -- Object details of a database ---
prompt -- ----------------------------------------------------------------------- ---
prompt
col owner format a15
set numwidth 5
set lines 132
set pages 50
select DECODE(GROUPING(a.owner), 1, 'All Owners', a.owner) AS "Owner" , count(decode( a.object_type,'TABLE',1,null)) "Tab." , count(decode( a.object_type,'TABLE PARTITION',1,null)) "P. Tab." , count(decode( a.object_type,'INDEX' ,1,null)) "Ind." , count(decode( a.object_type,'INDEX PARTITION' ,1,null)) "P. Ind." , count(decode( a.object_type,'LOB' ,1,null)) "Lob" , count(decode( a.object_type,'CLUSTER' ,1,null)) "Cluster" , count(decode( a.object_type,'VIEW',1,null)) "View" , count(decode( a.object_type,'MATERIALIZED VIEW',1,null)) "Mat. View" , count(decode( a.object_type,'CONSUMER GROUP',1,null)) "C. G." , count(decode( a.object_type,'QUEUE',1,null)) "Q." , count(decode( a.object_type,'RESOURCE PLAN',1,null)) "R. P." , count(decode( a.object_type,'OPERATOR',1,null)) "Operat." ,
count(decode( a.object_type,'PACKAGE',null,'PACKAGE BODY',null,'FUNCTION',null,'PROCEDURE',null,'LIBRARY',null,'TYPE',null,'TYPE BODY',null,'SEQUENCE',null,'SYNONYM',null,'TRIGGER',null,'CONTEXT',null,
'EVALUATION CONTEXT',null,'VIEW',null,'MATERIALIZED VIEW',null,'CONSUMER GROUP',null,'QUEUE',null,'RESOURCE PLAN',null,'OPERATOR',null,'TABLE',null,'TABLE PARTITION',null,'INDEX',null,'INDEX PARTITION',null,'LOB',null,'CLUSTER',null ,'VIEW',null,'MATERIALIZED VIEW',null,'CONSUMER GROUP',null,'QUEUE',null,'RESOURCE PLAN',null, 1)) "Oth." , count(1) "Tot." from dba_objects agroup by rollup(a.owner);
select DECODE(GROUPING(a.owner), 1, 'All Owners', a.owner) AS "Owner" , count(decode( a.object_type,'PACKAGE',1,null)) "Pck." , count(decode( a.object_type,'PACKAGE BODY',1,null)) "Body" , count(decode( a.object_type,'FUNCTION',1,null)) "Fct." , count(decode( a.object_type,'PROCEDURE',1,null)) "Proc." , count(decode( a.object_type,'LIBRARY',1,null)) "Lib." , count(decode( a.object_type,'TYPE',1,null)) "Type" , count(decode( a.object_type,'TYPE BODY',1,null)) "Type Body" , count(decode( a.object_type,'SEQUENCE',1,null)) "Seq." , count(decode( a.object_type,'SYNONYM',1,null)) "Syn." , count(decode( a.object_type,'TRIGGER',1,null)) "Trig." , count(decode( a.object_type,'CONTEXT',1,null)) "Cont." , count(decode( a.object_type,'EVALUATION CONTEXT',1,null)) "Eval. Cont." , count(decode( a.object_type,'PACKAGE',null,'PACKAGE BODY',null,'FUNCTION',null,'PROCEDURE',null,'LIBRARY',null,'TYPE',null,'TYPE BODY',null,'SEQUENCE',null,'SYNONYM',null,'TRIGGER',null,'CONTEXT',null,'EVALUATION CONTEXT',null,'VIEW',null,'MATERIALIZED VIEW',null,'CONSUMER GROUP',null,'QUEUE',null,'RESOURCE PLAN',null,'OPERATOR',null,'TABLE',null,'TABLE PARTITION',null,'INDEX',null,'INDEX PARTITION',null,'LOB',null,'CLUSTER', null,'VIEW',null,'MATERIALIZED VIEW',null,'CONSUMER GROUP',null,'QUEUE',null,'RESOURCE PLAN',null, 1)) "Oth." , count(1) "Tot." from dba_objects agroup by rollup(a.owner);