RE: is it ever a good idea to multiplex the system tablespace?

Ryan - The only time I did was when I needed to expand the SYSTEM tablespace because it was too small. Normally you can just expand the datafile. For some reason I couldn't do that, it was awhile ago, probably the Oracle version. Creating another data file went just fine.

    The more important issue is keeping stuff out of the SYSTEM tablespace so it doesn't grow. Watch very carefully any objects residing in the SYSTEM tablespace that aren't owned by SYS. Make sure nobody is using SYSTEM as their temp or default tablespace, etc. The problem is that shrinking the SYSTEM tablespace is very hard to do.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: rgaffuri_at_cox.net [mailto:rgaffuri_at_cox.net] Sent: Thursday, July 24, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L Subject: is it ever a good idea to multiplex the system tablespace?

Would you ever want to use multiple data files for the system tablespace? Received on Thu Jul 24 2003 - 15:52:25 CDT