The concept of delayed replicated slave is nothing new - Oracle (TM) for example had it for years with the Data Guard. So what is it in the ...
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