Best Practices for Running an Oracle Database on an IBM Mid-Range Storage SubsystemPosted: 21/12/2010 | |
Owning state-of-the-art storage subsystems is not enough to excel in today’s competitive business climate. Even with the best storage subsystem, the continuous demands upon the IT environment can create challenges:
• Unused capacity on expensive equipment becomes a financial waste.
• Continuous hardware and software sprawl create an ever-changing environment that constantly must be re-tuned to adjust to new conditions.
• New equipment is hot-added when possible, often resulting in a convoluted configuration that makes tuning for high performance complex and difficult to manage.
This document describes the optimum performance settings for IBM® System Storage ™ DS5000® storage subsystems and IBM System Storage DS4800 storage subsystems with the Oracle® Database application. This document identifies parameters for optimizing a high-performance storage subsystem.
For each parameter, this document explains how to monitor, evaluate, adjust, and make sure that the adjustment was appropriate and positive. The process of keeping the parameters tuned involves the following tasks:
• Identify the relevant parameters.
• Take a baseline to determine the benchmark value for each relevant parameter.
• Continuously monitor each parameter on an ongoing basis. Only continuous monitoring can isolate the triggers that impact performance. Also, continue monitoring after any adjustment so that the effectiveness of the adjustment can be evaluated.
• Adjust parameters while the system remains in production.
• Watch how adjustments in one parameter are affecting other parameters.
See link below
- Share on Facebook (Opens in new window)
- Click to share on Twitter (Opens in new window)
- Click to share on Google+ (Opens in new window)
- Click to email (Opens in new window)
- Click to share on Reddit (Opens in new window)
- Click to share on Tumblr (Opens in new window)
- Click to share on Pinterest (Opens in new window)
- Click to print (Opens in new window)