Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: maximum size of an extent

Re: maximum size of an extent

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 6 Jun 2002 10:45:19 +0100
Message-ID: <3cff2f2f$0$231$ed9e5944@reading.news.pipex.net>


No.

However you could control this in one of two ways.

  1. Limit the size of your datafiles. (YUK)
  2. Use Locally managed tablespaces with uniform extent sizes.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"GR" <guy.rodesch_at_cie.etat.lu> wrote in message
news:3cff2d51$1_1_at_news.vo.lu...

> 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?
>
>
> Thanks in advance,
> Guy.
>
>
>
>
>
Received on Thu Jun 06 2002 - 04:45:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US