What partiotions (slices) I should use for Oracle 10G?

0 pts.
Tags:
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
ASKED: January 18, 2006  1:14 PM
UPDATED: January 20, 2006  7:30 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Sequential
    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.
    0 pointsBadges:
    report
  • Drhespen
    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
    0 pointsBadges:
    report
  • Ghostsword
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/what-partiotions-slices-i-should-use-for-oracle-... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following