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 ...
Get PeopleSoft for the Oracle DBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
