Re: Does anyone know what size the system table space should be in 8.1.6

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/02
Message-ID: <962569360.20940.0.pluto.d4ee154e@news.demon.nl>#1/1

"Rob Feehan" <rfeehan_at_charter.net> wrote in message news:slv7r7erop317_at_corp.supernews.com...
> I am trying to find out if the system table space requirements have
> increased in Oracle 8.1.6 over previous versions. I am new to Oracle
having
> recently begun to learn it after 14 years with another DBMS.
>
> Can anyone tell me what the size should be in the system table space?
> Recommendations or Oracle's quoted size would be helpful.
>
> Email replies appreciated. Thanks.
>
>
>

My initial estimate is 150 - 200M, which highly depends whether or not you are going to use Designer 2000.
Designer comes with 60M pl/sql code.
A few months ago a 200M system tablespace for a 7.3.4 tutorial database with Designer increased to 300M when converted to 8.0.4.

The system tablespace is a good candidate for making it too large, as making it too small will block *all* operations. IMO, you shouldn't try to cut it back.

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Jul 02 2000 - 00:00:00 CDT