Home » RDBMS Server » Server Administration » Table Size
Table Size [message #341131] Sat, 16 August 2008 23:50 Go to next message
sabbir_ru
Messages: 6
Registered: August 2008
Junior Member
I wanna know the size of a table from
select sum(bytes) from dba_segments where segment_name='table_name'


but the result is confusing.... the output is like 500MB but the actual size is about 4GB when i took a dump of that table.
Re: Table Size [message #341132 is a reply to message #341131] Sat, 16 August 2008 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above
Re: Table Size [message #341134 is a reply to message #341131] Sat, 16 August 2008 23:57 Go to previous message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
May be the table has a column of LOB type.
I got a solution here...
http://sadatdba.blogspot.com/2008/08/size-of-table-including-lob-segment.html
Previous Topic: Flash Recovery Area
Next Topic: Oracle Workspace Manager
Goto Forum:
  


Current Time: Wed Dec 07 12:46:31 CST 2016

Total time taken to generate the page: 0.30192 seconds