| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SAME and separating disk and index tablespaces
Vikas,
Spend an hour on reading this usenet thread:
It will open your eyes about separating data/index.
Still not sure about the redolog stream...Because of the sequential nature of redologfiles. I've read tests that 'prove' it doesn't matter much whether you separate your redolog from 'ordinary' datafiles or not. It does simplify things when you pure SAME.
Regards,
Hans
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Wed, 08 Oct 2003 09:54:30 -0800
Thanks Gaja ! Does it also make sense from a performance perspective (I/O issues due to concurrent access of index and data ) to separate them or is that point moot once you apply the SAME methodology ?
-----Original Message-----
Gaja Krishna Vaidyanatha
Sent: Wednesday, October 08, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L
Vikas,
The answer is an enthusiastic yes. This is purely from an administrative and manageability standpoint. For example, if you have INDEX and DATA segments separated in 2 different tablespaces, the backup of these tablespaces can be done INDEPENDENTLY. This is relevant, as if you were to rebuild your indexes using the NOLOGGING option between 2 backup jobs. If that were the case, then all you will need to do after the rebuild is complete, is to backup only the INDX tablespace.
This is a best practice (if not a requirement) in most production shops, unless you think you can re-re-build your indexes in the event of media failure and you lose your INDX tablespace.
Hope that helps,
Gaja
--- vikas kawatra <vkawatra_at_comcast.net> wrote:
> Guys,
>
> Does it make sense to separate data and index
> segments into separate
> tablespaces if you create a single logical volume
> and all files are
> striped using the SAME methodology ?
>
> Thanks
>
> vikas
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: vikas kawatra
> INET: vkawatra_at_comcast.net
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: oraperfman_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET: vkawatra_at_comcast.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _________________________________________________________________ Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git INET: hansdegit_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Oct 08 2003 - 14:49:30 CDT
 |
 |