CHAPTER 3Identifying Performance Problems

Too often we hear things like "The database has performance problems!" Sometimes this is true, sometimes it is not. Personally, I have no problem with these kinds of statements. More often than not, however, people make such statements without looking into the problem first. In other words, the problem is arriving at a conclusion without careful analysis. To identify a performance problem, an open-minded approach is absolutely necessary. Instead of judging the actual situation based on opinions, feelings, and preconceptions, we must base our statements on evidence.

The aim of this chapter is to describe an analysis road map that you can use to find out where and how time is spent. In fact, this is the ...

Get Troubleshooting Oracle Performance now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.