Vikash Jain (DBA Trainee) wrote:"reclaim" space from where to where?
I have a doubt in table /index actual size , I know how to shrink the object but i do not know how to check that this table is having this much free blocks and i can get this much of free space from that object ..
When i ran this below script for getting table info like this .
select blocks, empty_blocks,avg_space, num_freelist_blocks,ROW_MOVEMENT,LAST_ANALYZED from user_tables where table_name = 'USER_MAS'
all columns are blank except blocks (49883)...
After that i just analyzed the table using below script
Analyze table user_mas compute statistics;
and again i ran the same script to check table info and i got some empty blocks(86) .
so here my doubt is how to get the actual size of the object (Used and Free) and how to calculate the reclaimable space from that object so that i can be sure that if i shrink the object then i will get this much of free space from that object ..
Thanks & Regards,