OraFAQ Forum: Server Administration » How to find out Biggest Schema in Database

Home » RDBMS Server » Server Administration » How to find out Biggest Schema in Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find out Biggest Schema in Database [message #197710]

Thu, 12 October 2006 06:56

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

Report message to a moderator

Re: How to find out Biggest Schema in Database [message #197714 is a reply to message #197710]

Thu, 12 October 2006 07:01

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: How to find out Biggest Schema in Database [message #197715 is a reply to message #197710]

Thu, 12 October 2006 07:03

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

Report message to a moderator

Re: How to find out Biggest Schema in Database [message #197723 is a reply to message #197710]

Thu, 12 October 2006 07:28

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Thanks Sandeep

Thanks Mahesh

Report message to a moderator

Previous Topic:	DBMS_JOB
Next Topic:	54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:24:31 CDT 2024