Dba Objects

Description: Returns a summary of object types by the tablespaces where they reside.

DROP TABLE ext_temp
/
CREATE TABLE ext_temp AS
SELECT DISTINCT tablespace_name, owner, segment_name
FROM dba_extents
WHERE owner != 'SYS'
/
spool dba_obj_count1.lst
 
SELECT tablespace_name, object_type, COUNT(*)
FROM dba_objects a, ext_temp b
WHERE object_name = segment_name
AND a.owner = b.owner
GROUP BY tablespace_name, object_type
/

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.