Re: System tablespace

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 20 Jun 1999 04:19:08 GMT
Message-ID: <37726126.45513234@netnews.worldnet.att.net>

On Fri, 18 Jun 1999 14:18:44 -0400, Kenneth C Stahl <kstahl_at_lucent.com> wrote:

>Does Oracle have any specific recommendations regarding the size of the
>SYSTEM table space when creating a new instance.

I've never been able to pin Oracle down on this. I recently called support and posed this exact question. Their answer was "it depends".

>Thoughts?

I usually start by matching the size that Oracle uses for the system tablespace in the "starter database" that you get when you do a fresh install. For Oracle8i, this is about 150meg.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Sat Jun 19 1999 - 23:19:08 CDT