Get Information about the largest Top 10 Tables in DB

Get Information about the largest Top 10 Tables in DB

Sometimes you need to query about the largest Tables or    DB Objects   

To resolve and monitor Server free spaces and resources

Open SQLPLUS 

Write this simple code (User should be with DBA privileges)

/> SELECT * FROM

(

     SELECT

          SEGMENT_NAME,

          SEGMENT_TYPE,

          BYTES/1024/1024 MEGA_BYTES,

          TABLESPACE_NAME,

          OWNER

     FROM

          DBA_SEGMENTS     

          WHERE 

                   (SEGMENT_TYPE = :TYP OR :TYP IS NULL)

          AND (OWNER               = :OWNR OR :OWNR IS NULL)

          ORDER BY MEGA_BYTES DESC

)

WHERE

     ROWNUM <= 10

REGIONS	TABLE	0.0625	USERS	HR
LOCATIONS	TABLE	0.0625	USERS	HR
DEPARTMENTS	TABLE	0.0625	USERS	HR
JOBS	TABLE	0.0625	USERS	HR
EMPLOYEES	TABLE	0.0625	USERS	HR
JOB_HISTORY	TABLE	0.0625	USERS	HR
PS_TXN	TABLE	0.0625	USERS	HR