Order of StartUp of Services Should be First DB Listener, Database & then Application Tier Services Order of ShutDown of Services Should...
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