Apple iphone 1.1.4 update error ""Slide for Emergency". Updating your iphone to Release 1.1.4 may lock your phone in "re...
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
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.
1 comment:
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
Post a Comment