104: Simulating Oracle I/O to Accurately Configure Storage
James Koopmann , Guardium, Inc.    Biography

Objectives: Storage Concepts
Storage Benchmarking for Oracle
Configuring Oracle for current storage
Abstract: Configuring storage need not be difficult if proper planning is done. Using Oracle’s ORION Workload tool we can effectively benchmark storage for expected application mix. Only after benchmarking potential storage can we gain an understanding for the performance capabilities of our storage and become confident in its ultimate deployment. This presentation will introduce storage concepts, Oracle’s ORION workload tool, and provide scripts that show disk access trends in Oracle. Results from various workloads using RAID 0, 1, 10, and 5 on a 30TB storage system will be compared. Come see how your favorite RAID level performed.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Architecture
Date: Monday, April 14, 2008
Time: 1:00 PM - 2:00 PM