Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: System and temp tablespace
Priya Tantry wrote:
>
> What are the implications of having the system tablespace and the temp
> tablespace files on the same physical disk. Does that, in any way,
> affect performance?
Basically, it will not affect performance a lot if you do not put your indices of your data in SYSTEM tablespace.
-- ***************************************************************************** * * * Please go to http://www.hkstar.com/~rdbms/oracle.htm to find other solns * * * ***************************************************************************** --- Name : Lun Wing San (Certified Oracle Database Administrator) Title : Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841 This posting represents the personal opinions of the author. It is not the official opinion or policy of the author's employer. Warranty expired when you opened this article and I will not be responsible for its contents or use.Received on Sun Apr 27 1997 - 00:00:00 CDT