An Oracle database on IBM ESS

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.


    Requires Free Membership to View

    Login

    When you register for SearchStorage.com, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics, the latest news and the biggest challenges you face as a storage professional today.

    Rich Castagna, Editorial Director

    By submitting your registration information to SearchStorage.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchStorage.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.

Jim

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 first published in September 2001