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

Get Information about Current Database Version.

Get Information about Current Database Version.

If you need to open Service request , you have to know what is your database version .

Open SQLPLUS 

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

/> select * from v$version;

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

PL/SQL Release 11.1.0.7.0 - Production

CORE       11.1.0.7.0                Production

TNS for Linux: Version 11.1.0.7.0 - Production

NLSRTL Version 11.1.0.7.0 - Production

IF you need to know your current privileges

/> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE

GRANTEE = 'HR'

RESOURCE

CONNECT