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.

Report message to a moderator

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: 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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Flash Recovery Area
Next Topic: Oracle Workspace Manager
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 22:22:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.