Until very recently, the session-based diagnosis techniques used by the most efficient Oracle performance problem repair specialists in the world were very difficult for the average database administrator to use. Only in the beginning of calendar year 2001 has anyone in the market invested in sufficient research and development to create a software tool that simplifies data collection and resource profile generation. With Sparky, a DBA or application developer can generate a session resource profile and all necessary performance diagnosis detail with only about a dozen keystrokes. Since the late 1980s, I have watched hundreds of Oracle customers respond ineffectively to system performance problems. However, as you can plainly see from the resource profile above, even doubling CPU speed will save only about 4 of the session's 65.92 seconds of execution time.
Method facilitates direct measurement and quantitative forecasting of performance changes.
Managing sufficient drill-down data is difficult and expensive. Collecting sufficient detail data often intrudes on the performance of the very system you're trying to repair. You must continually add to your checklists of ratios to keep pace with technology changes. In many cases, the problem root cause can go undetected for months. Method is often ineffective in revealing performance problem root causes.