Home » Infrastructure » Windows » Seperation of Data, Index, Redo??
Seperation of Data, Index, Redo?? [message #100733] Wed, 02 July 2003 19:14 Go to next message
Colin Mckinney
Messages: 1
Registered: July 2003
Junior Member
If I have 12 disks to play with, where can I find info on the best way to seperate index, data, OS, etc?

Report message to a moderator

Re: Seperation of Data, Index, Redo?? [message #100734 is a reply to message #100733] Thu, 03 July 2003 07:32 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
 .
Dont have HUGE datafile in one tablespace. Have multiple datafiles in a tablespace .
Now distribute the tablespaces ( datafiles )across the disk.
have index tablespaces and data tablespacs in seperate disk.
Idea is minimize the i/o. Index/table data can share the tablespace. It makes no difference in performance.

[Updated on: Thu, 18 January 2007 04:27]

Report message to a moderator

Previous Topic: Oracle 8.0.5 suddenly stopped and doesn't start on NT anymore.
Next Topic: Help backup on database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 00:42:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.