Re: SYS and SYSTEM indexes

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Tue, 08 Jun 1999 12:31:42 +0200
Message-ID: <375CF10E.9BFAC4EA@si.unirioja.es>

Bill Buchan escribió:
> =

> Hi,
> =

> Newbie-type question: should I relocate the SYS and SYSTEM owned index=
es in
> the SYSTEM tablespace to prevent fragmentation, or can I leave them whe=
re
> they are? What about performance - should I move them to a tablespace =
on
> another disk?

Don't do anything with the sys objects, let them quiet ;) About system objects, in order to avoid they disturb the data dictionary, you should create a tablespace called, e.g, admin and move all system objects there and modify his default (and temporary) tablespace. About performance, unless some special tool like designer, I don't believe it would affect notoriely the perfomance.  =

> Many thanks for any advice.
> =

> - Bill.

• =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Tue Jun 08 1999 - 05:31:42 CDT