9 Replies Latest reply on Oct 5, 2012 6:03 PM by jgarry

    Table/Index actual reclaimable free space

    Vikash Jain (DBA )
      Hi all,

      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,
      Vikash jain