Re: System tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 18 Jun 1999 23:34:06 +0200
Message-ID: <929741576.13660.0.pluto.d4ee154e@news.demon.nl>

Hi Ken,
I would guess not. 15M is for an empty database. My own guideline is to start of with 50M and that's usually insufficient, though it mainly depends on the amount of PL/SQL code written. A Designer repository needs 60M for PL/SQL code alone, which all ends up in the source$ table amongst others in the SYSTEM tablespace.

Hth,

Sybrand Bakker, Oracle DBA

Kenneth C Stahl wrote in message <376A8D83.2740CCC2_at_lucent.com>...
>Does Oracle have any specific recommendations regarding the size of the
>SYSTEM table space when creating a new instance. I notice that after
>creating the database and running CATALOG.SQL, CATPROC.SQL and
>CATDBSYN.SQL, only about 15M of space is used. Does that mean I would be
>able to get by with a SYSTEM tablespace of 20M and then RESIZE it later
>if needed?
>
>Thoughts?
>
>
>Ken
>
Received on Fri Jun 18 1999 - 16:34:06 CDT