Home » Server Options » RAC & Failsafe » Separate table and index data in RAC (Oracle 10g)
Separate table and index data in RAC [message #441525] Mon, 01 February 2010 16:20 Go to next message
Richard2009
Messages: 21
Registered: October 2009
Location: London
Junior Member
Hi Experts,

Our database is Oracle11g RAC database. I need your expertise on this

Do we need to retain the table and index data in two different tablespaces for performance perspective in RAC database too?
Re: Separate table and index data in RAC [message #441530 is a reply to message #441525] Mon, 01 February 2010 16:23 Go to previous message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Do we need to retain the table and index data in two different tablespaces for performance perspective in RAC database too?
It is a myth. Even in single instance mode.
Different disks. To some extent yes.
Again, not for performance reasons.
Previous Topic: How to convert RAC database to single Instance Database?
Next Topic: Cloning Oracle Clusterware
Goto Forum:
  


Current Time: Tue Sep 27 14:31:50 CDT 2016

Total time taken to generate the page: 0.20024 seconds