Oracle Best Practices - File Locations

[ErrolDC]

Can someone give me a bit of insight into what the best practices are when creating databases in respect to placement of files on the file system.

For example, is it best to place redo logs on a separate disk? Is it good to do the same with the temporary tablespace? These are the kind of things I'd like to get some feed back on. I have a SunFire V880 with 6-12 disks and I'm trying to reorganize the file system.

Thanks for your comments.

 

[SantaMufasa]

Errol,

Rather than my "re-inventing the Oracle wheel" in terms of file placement, you can Google for "Oracle Flexible Architecture" (OFA) [Also know as: "Optimal Flexible Architecture"]. OFA is Oracle's suggestion for file naming, placement, and other file management issues. One the sites that I noticed that looks good is "

http://www.cs.nott.ac.uk/TSG/manuals/databases/oracle/standard/a90347/appf_ofa.htm".

Let us know if such links resolve your question.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 19:50 (04Feb05) UTC (aka "GMT" and "Zulu"),
@ 12:50 (04Feb05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.