RE: Extent size for system tablespace

[Vergara, Michael (TEM)]

Title: RE: Extent size for system tablespace

Hi All...

 

I need to add my 2-cent's worth to this thread.  At the 8i (8.1.5) level,

we noticed that some SYSTEM tables were throwing lots (really...LOTS) of

extents.  I know..I know...lots of extents aren't necessarily a bad thing.

But when I look at the SYSTEM tablespace and see objects with 2,000-3,000

extents I just can't stand it!

 

So, we stepped back and through trial and error (and this is a secret!

Don't tell Oracle!) we modified SQL.BSQ.  Now our 8i databases all look

'normal'.  Yes, they still add extents, but now the NEXTEXTENT size is

larger so I get fewer extents even with PCTINCREASE 0.

 

I figure what we've done here would not necessarily work the same for

some of the places I've worked before because the application mix is

different.  Hey...it works for us.  Build a sandbox.  Try it.  YMMV.

 

Mike

 

---

===========================================================================

Michael P. Vergara              | I’ve got a PBS mind in an MTV world

Oracle DBA                      |

Guidant Corporation             |

-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 9:12 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Extent size for system tablespace

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:[EMAIL PROTECTED]]
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