Try this site: http://www.puschitz.com/ I have been using his guides for years. (even as an employee at Oracle I found myself using his guides over the wordy/lengthy oracle docs) You also wanna become familiar with the Oracle architecture. There are various components you want to segregate onto different physical spindles. Oracle has what they called the OFA - optimum Flexible Architecture. This covers what components should go where. (ie: You don't want 2 log groups on the same filesystems, not only are you getting redundant I/O per every transaction but you have lost the redundancy if that filesystem fails. You also don't want to store a table's indexes on the same filesystem as the table itself -- so place index tablespaces on separate spindles from the corresponding data tablespaces. There are just a few examples) Other than that, avoid raid 5 for OLTP databases if you can, and I personally avoid using NFS for storing datafiles, although Oracle uses NFS for datafiles for almost 90% of their databases. (10 years ago Oracle documentation stated don't EVER mount datafiles accross NFS but today, after being in bed with NetApp all these years, its apparently ok to do) Of course all this is based on your planned workload. It is possible to store an entire database all in one filesystem but you won't be able to scale much, nor will you be able to recover 100% of your transactions (100% of the time) if that filesystem fails. Hope this helps, CC On Nov 8, 2007 9:45 AM, McDougall, Marshall (FSH) <Marshall.McDougall@xxxxxxxxx> wrote: > I am being tasked with building an environment to run Oracle. I have > had little Oracle experience so I went looking on the web for some best > practices for file system setup. Of course there were several million > hits and with variety comes confusion. I would appreciate it if someone > with some Oracle on Linux expertise would point me in the right > direction. I believe that the hardware is going to be HP blades > connected to an EMC/Dell SAN. Thanks for your consideration. > > Regards, Marshall > -- > redhat-list mailing list > unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subjectunsubscribe > https://www.redhat.com/mailman/listinfo/redhat-list > -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
