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 ...