Pages

Popular Posts

Friday, March 07, 2008

How to Calculate Oracle Table Size

How to Calculate/Compute Oracle Table Size:

select
segment_name table_name,
sum(bytes)/(1024*1024) table_size
from
user_extents
where
segment_type='TABLE'
and
segment_name = 'YOUR_TABLE_NAME'
group by segment_name

1 comment:

Sam said...

I have always used 1048576 instead of 1024*1024. It's the same thing but for some reason I always remember that. Plus it is easier to write. You have some really good stuff here. Keep it up.

Sam