Home » RDBMS Server » Server Administration » SIZE OF TABLES IN TABLESPACE
SIZE OF TABLES IN TABLESPACE [message #61371] Sun, 18 April 2004 12:16 Go to next message
soumya rajendran
Messages: 1
Registered: April 2004
Junior Member
hi experts
how can i calculate the physical size of a perticular table in a tablespace and how much space allocated in a tablespace or how much free space remaining for a specific tablespace in percentage or in mb
thanks in advance

Report message to a moderator

Re: SIZE OF TABLES IN TABLESPACE [message #61373 is a reply to message #61371] Sun, 18 April 2004 18:45 Go to previous messageGo to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
Of the many ways to do this, one of the ways is to
select sum(vsize(col1)) +
sum(vsize(col2)) + ....
from table1

THis will give you the information in bytes

Report message to a moderator

Re: SIZE OF TABLES IN TABLESPACE [message #61374 is a reply to message #61371] Sun, 18 April 2004 21:44 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
use this for the table's size:

select sum(bytes/1024)/1024 from dba_segments
where segment_name = 'YOUR TABLE NAME' and
segment_type = 'TABLE';

Hope that helps,

Trifon Anguelov
DBAclick.com

Report message to a moderator

Previous Topic: Applying Offline archive files
Next Topic: oracle 9i for 32-bit
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:43:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.