June 2014
Intermediate to advanced
740 pages
23h 59m
English
CHAPTER 5
![]()
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.
Repositories
Oracle Database provides two repositories ...