3 Replies Latest reply on Mar 31, 2015 4:15 PM by mandevil

    Monitor insert /*+ APPEND */ behavior

    deedsd

      I was doing some space management on my largest repo, and found that it is occupying 429 GB, and Segment Advisor said I could reclaim 129 GB of it.  I checked the first table...  It is 8.5 GB in 1.089 million blocks.  Of that, 1.005 million blocks are between 75 - 100% empty.  I expect this is due to inserting new rows above the HWM.  Is this something I can adjust?

       

      SQL> exec show_space('CONST_588','IGNITE','TABLE');

      Unformatted Blocks .....................               0

      FS1 Blocks (0-25) ......................               7

      FS2 Blocks (25-50) .....................             973

      FS3 Blocks (50-75) .....................          21,754

      FS4 Blocks (75-100).....................       1,005,143

      Full Blocks ............................          60,109

      Total Blocks............................       1,089,536

      Total Bytes.............................   8,925,478,912

      Total MBytes............................           8,512

      Unused Blocks...........................               0