Home > IT Answers > Oracle > What partiotions (slices) I should use for Oracle 10G?
Ghostsword
0 pts.
 What partiotions (slices) I should use for Oracle 10G?
Oracle
I am building a test server with Solaris 10 and oracle 10G. I would like to know what is the best partitioning that I should do? Thanks, Luis

Software/Hardware used:
ASKED: January 18, 2006  1:14 PM
UPDATED: January 20, 2006  7:30 AM
RELATED QUESTIONS
Answer Wiki:
I assume the partitioning is filesystem level. So for me I used to split out the redo logs to raid 0 only and data to raid 0+1 (10) and indexes to the same. If you are running with archive logs then split them off as well. Also binaries on their own separate mount point. Or to make life a little easier in the long run use ASM. I hated it to no end in the beginning but since we have been using it I have grown to appreciate it's simplicity. We use ASM and OMF with bigfiles so IO performance has never been an issue except with bad sql and file management is no longer an issue at all. Still you will have to split off some diskgroups for archive logs. Also ASM doesn't look after the binary installation mountpoint. But all DB files control files, redo logs, and datafiles are very well taken care of.
Last Wiki Answer Submitted:  January 19, 2006  11:46 am  by  Sequential   0 pts.
All Answer Wiki Contributors:  Sequential   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I assume the partitioning is filesystem level. So for me I used to split out the redo logs to raid 0 only and data to raid 0+1 (10) and indexes to the same. If you are running with archive logs then split them off as well. Also binaries on their own separate mount point. Or to make life a little easier in the long run use ASM. I hated it to no end in the beginning but since we have been using it I have grown to appreciate it’s simplicity. We use ASM and OMF with bigfiles so IO performance has never been an issue except with bad sql and file management is no longer an issue at all. Still you will have to split off some diskgroups for archive logs. Also ASM doesn’t look after the binary installation mountpoint. But all DB files control files, redo logs, and datafiles are very well taken care of.

Sequential
 0 pts.
 

You may want to check this out (assuming you have a MetaLink account) – there is a good summary matrix at the bottom.

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=30286.1

Drhespen
 0 pts.