OraFAQ Forum: Server Administration » how to find size of each table in db

Home » RDBMS Server » Server Administration » how to find size of each table in db

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

how to find size of each table in db [message #110994]

Fri, 11 March 2005 12:57

sajan
Messages: 16
Registered: April 2001

Junior Member

Hi all...

i want to find out the size/no.of rows of each table in a particular user....

thanks in advance...

sajan

Report message to a moderator

Re: how to find size of each table in db [message #111016 is a reply to message #110994]

Sat, 12 March 2005 02:44

sridcpp
Messages: 23
Registered: February 2005
Location: India

Junior Member

select segment_name,sum(bytes)/1024/1024 "Size MB",sum(num_rows )
from dba_segments s,dba_tables t
where s.owner='user name' and s.segment_name=t.table_name
group by segment_name
/

Report message to a moderator

Previous Topic:	Copy an Oracle Database
Next Topic:	ORA-01157

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:29:43 CDT 2024