MariaDB Dynamic columns Very interesting new feature included in MariaDB 5.3 onwards and I hope it will get enough attention for continu...
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