Path: news.easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!news2.euro.net!transit.news.xs4all.nl!195.129.110.18.MISMATCH!bnewspeer00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <niall.litchfield@dial.pipex.com>
Newsgroups: comp.databases.oracle.server
References: <3cff2d51$1_1@news.vo.lu> <f_puhan-E1B714.16031206062002@vienna7.his.com>
Subject: Re: maximum size of an extent
Date: Thu, 6 Jun 2002 22:53:05 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Lines: 25
Message-ID: <3cffd9c3$0$236$cc9e4d1f@news.dial.pipex.com>
NNTP-Posting-Host: usercr25.uk.uudial.com
X-Trace: 1023400388 news.dial.pipex.com 236 62.188.156.252
X-Complaints-To: abuse@uk.uu.net
Xref: easynews comp.databases.oracle.server:149798
X-Received-Date: Thu, 06 Jun 2002 14:50:34 MST (news.easynews.com)

"Fred Puhan" <f_puhan@precise.com> wrote in message
news:f_puhan-E1B714.16031206062002@vienna7.his.com...
> In article <3cff2d51$1_1@news.vo.lu>, "GR" <guy.rodesch@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.

It depends. If the tablespace has local extent management then the above
does not apply. 8.1.7 can and should use local extent management.


--
Niall Litchfield
Oracle DBA
Audit Commission UK