| Separate table and index data in RAC [message #441525] |
Mon, 01 February 2010 16:20  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
