OraFAQ Forum: Server Administration

Sat, 16 August 2008 23:50

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.

Sat, 16 August 2008 23:52

BlackSwan
Messages: 26766
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

Sat, 16 August 2008 23:57

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: Mon Jul 08 07:37:27 CDT 2024