Home » Other » General » table size
table size [message #271095] Sat, 29 September 2007 04:59 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 28 15:38:08 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.