Images

CHAPTER

6

SQL Monitor

Oracle DBAs and database developers have always needed to locate and identify any poorly performing SQL code that has been rolled out into production. But no matter how carefully developers and DBAs try to implement the best code possible, at some point a bad SQL statement or two are going to slip by into production and negatively impact performance at the least opportune time. For some reason, it seems that poorly performing code tends to happen in the wee hours of the night, and ironically not as much during the daytime when DBAs and developers are close at hand to react.

When this occurs, DBAs need an easy and quick way ...

Get Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability now with O’Reilly online learning.

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