Home » RDBMS Server » Server Administration » How to find out Biggest Schema in Database
How to find out Biggest Schema in Database [message #197710] Thu, 12 October 2006 06:56 Go to next message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

Hi All

How to find Out biggest schema in Database or biggest table in DB among all schemas







Thanks in Advance
Sponguru

Re: How to find out Biggest Schema in Database [message #197714 is a reply to message #197710] Thu, 12 October 2006 07:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search the forum.
Question is been asked and answered a million times.
look into dba_segments.
Find the biggest segment.
FInd the owner.
Sum all the segments owned by one schema and compare them.
Re: How to find out Biggest Schema in Database [message #197715 is a reply to message #197710] Thu, 12 October 2006 07:03 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
select sum(bytes) size ,owner from dba_segments group by owner order by 1 asc;

Look for size of each schema in total and then get highest sized one.

Sandeep
Re: How to find out Biggest Schema in Database [message #197723 is a reply to message #197710] Thu, 12 October 2006 07:28 Go to previous message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

Thanks Sandeep

Thanks Mahesh
Previous Topic: DBMS_JOB
Next Topic: 54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2
Goto Forum:
  


Current Time: Sat Dec 03 20:02:31 CST 2016

Total time taken to generate the page: 0.10124 seconds