Problem solve Get help with specific problems with your technologies, process and projects.

An Oracle database on IBM ESS

Hi, could you point me in the right direction on setting up an Oracle database on an IBM ESS for optimal performance?...

For example, do I have to use I/O distribution across disks or controllers, or not? The environment is RS/6000 AIX 4.3.3 (HACMP on the production machine) connecting to a Shark through Fibre Channel.

Thanks in advance.

For optimal performance on an Oracle database a combination of RAID levels and database component placement works well.

If you are using multiple controllers, build a volume groups by concatenating logical volumes across controllers. For most large cache storage controllers it is not required to strip the database itself, but indexes will benefit from software striping. So RAID 1 should be used for the database and RAID 10 for indexes and log files.

Logs should be spread across controllers and striped. Archive files can be placed on logical drives to fill up physicals and flatten the access density on all drives. If available, the archive logs can be placed on larger or slower drives.

Hope this helps.


Editor's note: Do you agree with this expert's response? If you have more to share, post it in our Administrator Central forum at http://searchstorage.discussions.techtarget.com/WebX?50@@.ee83ce2 or e-mail us directly at editor@searchstorage.com.

This was last published in September 2001

Dig Deeper on Storage vendors

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.