Re: maximum size of an extent

From: Fred Puhan <f_puhan_at_precise.com>
Date: Thu, 06 Jun 2002 16:03:12 -0400
Message-ID: <f_puhan-E1B714.16031206062002@vienna7.his.com>

In article <3cff2d51$1_1_at_news.vo.lu>, "GR" <guy.rodesch_at_cie.etat.lu> wrote:

> Hello,
> We use Oracle 8.1.7.2 as the database of our SAP R/3 46C system. Could we
> limit the maximum size of an extent in the init<SID>.ora configuration file?

Extent growth is controlled by the values specified in the CREATE statement in a cascading hierarchy: first at the table/object level, then at the tablespace level, and finally using Oracle defaults.

If you want to limit the maximum size of a single extent, use a combination of NEXT and PCTINCREASE 0 values in the CREATE statement. This will tell Oracle to use the value of NEXT, if at all possible when extending a segment. Doing so, however, may cause another value to come into play, and that's the MAXEXTENTS value set at the tablespace, if not UNLIMITED.

-- 
The underscore character does not belong in my address. You know the drill...

Received on Thu Jun 06 2002 - 15:03:12 CDT