Re: SMON Logic?

From: Chakravarthy KM Nalamotu <kittu_at_Hawaii.Edu>
Date: 1997/05/07
Message-ID: <5kpt1u$p8k@news.Hawaii.Edu>#1/1

Isn't Oracle's assumption that if PCTINCREASE is 0, all the extents that the users create will be of standard size WRONG? I have seen a few cases where one follows this, but most of the times this standard is not followed.

Brett Neumeier (neumebm_at_hpd.abbott.com) wrote:
: The assumption that Oracle makes is that, if you have
: PCTINCREASE 0 as the default storage for a tablespace, you will
: be creating all of the extents in the tablespace with a standard
: size. If this assumption is correct, there is no reason to coalesce
: the free space in the tablespace; in fact, performance will be
: very slightly better because any free extents created by dropping
: database objects will be the correct size to be reused already;
: Oracle won't have to split up a large free extent.

: -bn
: neumebm_at_hpd.abbott.com
Received on Wed May 07 1997 - 00:00:00 CDT