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