OraFAQ Forum: General

Home » Other » General » table size

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

table size [message #271095]

Sat, 29 September 2007 04:59

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi guys,

kindly let me know the query to find out table size .

kindly do the needful

Regards,
Balaji

Report message to a moderator

Re: table size [message #271110 is a reply to message #271095]

Sat, 29 September 2007 09:27

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

dba_segments

Regards
Michel

Report message to a moderator

Re: table size [message #271141 is a reply to message #271095]

Sun, 30 September 2007 00:28

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

SELECT segment_name TABLE_NAME,
  SUM(bytes) /(1024 *1024) table_size_meg
FROM user_extents
WHERE segment_type = 'TABLE'
GROUP BY segment_name

Report message to a moderator

Re: table size [message #271147 is a reply to message #271141]

Sun, 30 September 2007 01:47

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is very bad.
Global size is in %_segments view.
%_extents are for extent data. Why summing something when you already have the sum somewhere?
Above all when these view are slow.

Regards
Michel

Report message to a moderator

Re: table size [message #271148 is a reply to message #271095]

Sun, 30 September 2007 02:10

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

When someone says table size query on dba_segments.In dba_extents view you usually will get lower disk usage which actually don't exhibit real one.

Report message to a moderator

Previous Topic:	Best Tool to re-formatting Oracle PL/SQL
Next Topic:	New to Oracle -- desperately seeking advice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:59:59 CDT 2024