Get More from Your Oracle Database: Best Practice Performance Management for Real Results

WHITE PAPER







Get More from Your Oracle Database:
Best Practice Performance Management for
Real Results












JANUARY 2006

Confio Software www.confio.com +1-303-938-8282

CONTENTS
Executive Summary …...…………………………..……………………………… 3
Database Wait-Time is Now the Best Measure of Performance ………..... 3
Resource Mapping Methodology ………………………….………………….… 3
Return on Investment Analysis: Proven Value ………………………..….….. 5
Business Benefits of Ignite for Oracle ......……….…….....…………………... 6
Ignite Answers Key Questions for DBAs ……...………….....………...……… 6
Ignite for Oracle Examples ………………………………….....………………… 7
About Confio Software ………………………………………...………….….…... 8
2 GET MORE FROM YOUR ORACLE DATABASE
Executive Summary SUMMARY: “Wait-Event” analysis has This white paper looks at the deficiencies in the traditional tools used by database administrators as they are asked to continually increase database performance and become the industry best keep costs down, and it highlights a new method of performance tuning and the practice replacing outstanding results that have been achieved with it. methods that simply count the occurrence of system We will discuss “Wait-Time” or “Wait-Event” analysis as it has become the industry best-practice and replaced the “event counter” method of measuring database operations. performance. Next, we will look at Resource Mapping Methodology, (RMM), which defines a methodology for performing a complete Wait-Event analysis to identify the highest impact changes. Finally, we will prove the value of these methodologies and conclude with a brief overview of Confio’s flagship product, Ignite for Oracle, which implements the RMM in an inclusive package designed for the expert DBA. Database Wait-Time is Now the Best Measure of Performance As enterprise decision-makers look for new ways to cut costs, they are calling on database administrators to squeeze every ounce of performance out of their current systems. Enterprise IT managers have traditionally measured database productivity with counter-based tools, where I/O operations and CPU cycles are simply counted, with attempts made to minimize the number of operations. In contrast, Wait-Event Resource Mapping analysis is a method of optimizing database performance by measuring how long it Methodology defines what takes to complete each portion of a task. Confio, the leading innovator of Wait-Event performance and analysis tools, now delivers this industry best-practice analysis data must be captured to through its Ignite software product. Using Confio’s Wait-Event-based Resource understand the exact Mapping Methodology (RMM), Ignite solves Oracle database problems faster and more efficiently. source of system bottlenecks and to identify As enterprise systems became more complex and customized, the statistical the highest impact measurement of IT efficiency began losing its relevance. “Optimizing database performance changes. performance by watching system statistics was like counting how many times your car’s wheels rotated on the drive to work, rather than how long it actually took you to get there,” said Matt Larson, Confio CTO and founder. “Today’s business managers don’t care about how many cycles are taken, they care about how long their users must wait for an application to respond.”
Resource Mapping Methodology Wait-Event analysis and Resource Mapping Methodology are the cornerstones of Confio’s flagship software, Ignite. Resource Mapping Methodology defines the set of data that must be captured to do an effective job of performance management. If you do not have this, you are not looking in the right places for sources of performance degradation.
3 GET MORE FROM YOUR ORACLE DATABASE Resource Mapping Methodology (RMM) includes three elements essential to an accurate understanding of database performance: . Time View – Report time for every Wait-Event as the true measure of performance, . ... [download for more]