Actually, from 9iR2, system tablespace is created as locally managed
autoallocate. They should have put in "SEGMENT MANAGEMENT AUTO" clause as
well, but hey, you can't always get what you want, but you can try sometimes.
On 2003.08.18 07:59, rgaffuri_at_cox.net wrote:
> i thought you should leave the system table space to the defaults? Ive never
> touched System.
>
> you really should change system to locally managed tablespaces?
> >
> > From: Tim Gorman <tim_at_sagelogix.com>
> > Date: 2003/08/17 Sun PM 11:19:23 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Re: system tablespace at 50 pct_increase in 9i?
> >
> > Better yet, use locally-managed SYSTEM tablespace and dispense with the
> > issue altogether?
> >
> >
> > on 8/17/03 5:39 PM, Ryan at rgaffuri_at_cox.net wrote:
> >
> > > any idea why oracle has the system tablespace using 50 pct_increase in
> 9i? I k
> > > now it did that in the past, but why not set it to zero?
> > >
> > > Ryan
> > >
> >
> >
> >
> >
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Aug 18 2003 - 08:14:41 CDT
