Re: reset pctincrease

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 13 Oct 2005 18:47:41 +0200
Message-ID: <1r3tk1p5ij0anmreecq62jjv9e0mlknqf0@4ax.com>

On 13 Oct 2005 09:25:40 -0700, niy38_at_hotmail.com wrote:

>the original pctincrease is 50. since the last extent is too large,
>I'm going change pctincrease to 0. is there any bad consequence of it?
>what's the size of new allocated extent?

changing pctincrease affects only new extents. The size of the newly allocated extent has been set by you with the next extent clause of the table.
However, in 2005, you really shouldn't user dictionary managed tablespaces.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Oct 13 2005 - 11:47:41 CDT