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
MySQL Experts | Performance & Scalability | MySQL Consulting
Popular Posts
-
MariaDB Dynamic columns Very interesting new feature included in MariaDB 5.3 onwards and I hope it will get enough attention for continu...
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