CHAPTER 3
Analysis of Reproducible Problems
The most efficient way to approach a reproducible problem is to take advantage of one of the available tracing and profiling features to perform a controlled measurement while an application is experiencing the problem. At first, the aim is to categorize the problem into three major classes:
- The database engine spends most of the time executing SQL statements.
- The database engine spends most of the time executing PL/SQL code.
- The database engine is (almost) idle. In other words, the bottleneck is located outside the database tier.
To categorize the problem, you start the analysis by tracing the database ...
Get Troubleshooting Oracle Performance, Second Edition 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.
