RE: Extent size for system tablespace

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Tue, 03 Jul 2001 08:28:02 -0700
Message-ID: <F001.00340135.20010703081130@fatcity.com>

Justin,

Do not change the way Oracle sets up the system tablespace.  Let it do it's thing.  I have never had a problem with it other than to resize next extents for certain objects from time to time, but that's rare.

HTH
Lisa Koivu
Extreeeeeemely Bored Janitor (aka dba)
Ft. Lauderdale, FL, US

-----Original Message-----

From:   Justin Coleman [SMTP:jd_coleman_ora1_at_hotmail.com]
Sent:   Tuesday, July 03, 2001 11:51 AM
To:     Multiple recipients of list ORACLE-L

Subject:        Extent size for system tablespace

Experts,

From an earlier e-mail, I found out that LMT was not possible with the SYSTEM tablespace.  Thanks for that info.  So if using Data Dictionary managed tablespaces for the SYSTEM tablespace, when setting up a new database, should you change the default extent size for the system space and change pctincrease from 50% down to 0%?

Cheers for any help in advance.
Justin

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Justin Coleman
  INET: jd_coleman_ora1_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Tue Jul 03 2001 - 10:28:02 CDT