O'Reilly logo

PeopleSoft for the Oracle DBA by David Kurtz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 9 Performance Metrics

Performance tuning is a search for lost time.

Performance improvements are achieved by reducing response time.1 Therefore, I am always looking for the processes or parts of processes that take the most time. These places are where it is most efficient to direct the tuning effort, and where the minimum amount of tuning effort can have the maximum amount of performance effect.

Oracle provides the SQL trace facility to allow you to determine how long SQL statements take to execute and tell you how they are executing. The trace can be enhanced to report what Oracle is waiting for when it isn't executing SQL (event 10046 level 8). However, what if the problem is not the database? If it isn't the database, then what is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required