Re: dbms_space.space_usage and effectiveness of purge operations

+ oracle-l

On Tue, Nov 5, 2013 at 1:28 PM, Stalin <stalinsk_at_gmail.com> wrote:

> Thanks Jonathan, Mark and Martin for your inputs.
>
> Jonathan as summed up well in his last response to Martin. Based on the
> way we do deletes, i came to the same conclusion of not coalescing the
> index, However i wanted to see, if dbms_space.space_usage package would
> give me clues to ascertain the fact without having to use validate
> structure to analyze the index which could cripple our production systems.
>
> I was hoping FS2 blocks (25-50% free space) would give me a clue after few
> days of deletes, as i remember reading from 11.2.0.2 on wards, FS2 blocks
> will be considered for inserts. I was little unclear on the increase in FS2
> block counts after coalesce but Jonathan explanation honoring PCTFREE makes
> sense.
>
> Jonathan, PCTFREE for that index is set to 10%.
>
>
> --
> Thanks,
>
> Stalin
>
> P.S. we are 11.2.0.2 EE, 7Node RAC, RHEL 5.x
>

--
http://www.freelists.org/webpage/oracle-l