SMON Question

From: Darren John Capper <darren.capper_at_preci-spark.co.uk>
Date: Tue, 07 Sep 1999 13:38:31 +0100
Message-ID: <37D50745.FC3FCF3F@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 - 07:38:31 CDT