Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SYS and SYSTEM indexes

SYS and SYSTEM indexes

From: Bill Buchan <bill.buchan_at_ossian.net>
Date: Tue, 8 Jun 1999 11:07:40 +0100
Message-ID: <7jiq2i$2qu$1@phys-ma.sol.co.uk>


Hi,

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

Many thanks for any advice.

Received on Tue Jun 08 1999 - 05:07:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US