Re: SMON Question

From: Neilc <neilc-olops_at_btinternet.com>
Date: Tue, 7 Sep 1999 15:52:00 +0100
Message-ID: <7r38tr$jg4$1@pheidippides.axion.bt.co.uk>

No, this is NOT correct - SMON coalesces when the pctincrease setting is NON ZERO.
In fact the process selects all the rows from fet$ to see if any of them define adjacent pieces of free space.
The select performed is :-

    select f.file#, f.block#, f.ts#, f.length     from fet$ f, ts$ t
    where t.ts#=f.ts#
    and t.dflextpct != 0

As you can see the last condition ensures only tablespaces with pctincrease != (not equal 1)

Cheers

NeilC

Darren John Capper wrote in message <37D50745.FC3FCF3F_at_preci-spark.co.uk>...
>Oracle Guru's,
>
>I am currently referencing the Oracle DBA exam cram guide for the DBA
>OCP. In the chapter on Oracle processes, it states that:
>
> 'It (SMON) coalesces contiguous areas of free space in database
>tablespaces, where the default storage parameter, PCTINCREASE,is set to
>zero, and....'
>
>Is this true? I thought that if PCTINCREASE was zero it did exactly the
>opposite and you have to give it a value for it to coalesce space.
>
>Your clarification would be greatly appreciated.
>
>Regards,
>Darren
>
Received on Tue Sep 07 1999 - 09:52:00 CDT