Postmortem Analysis of Irreproducible Problems

This chapter describes how to analyze a performance problem that you can neither reproduce nor observe while it’s happening. In other words, this chapter explains what you can do when you are trying to analyze a problem that happened in the past and, as a result, you can’t take advantage of the information provided by SQL Trace and dynamic performance views. In such a situation, the only way you can make a quantitative analysis is by using a repository containing performance statistics covering the period of time you want to analyze.


Oracle Database provides two repositories ...

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.