Loading Events

« All Events

  • This event has passed.

Active SQL Monitor Reports

June 11 @ 12:30 - 13:30


SQL monitor reports have been around for a long time. They are extremely useful in diagnosing the performance of a single execution of a SQL statement. Next to AWR, ASH, and SQL-trace, they are a tool every performance engineer should be comfortable with. In this session, we will introduce you to active SQL monitor reports. We’ll first explain when SQL monitor is available, how to generate them, and discuss the anatomy of a SQL monitor report. In the 2nd part of this session, we’ll go through a few example SQL monitor reports, and show how to use them to find the root cause of a poorly performing SQL statement.

Speaker BIO: Toon Koppelaars
Real-World Performance, Oracle

Toon has been part of the Oracle ecosystem since 1987. He is currently a member of Oracle’s Real-World Performance team. The RWP team troubleshoots application performance issues in and around the DBMS. The way applications currently use (or rather, abuse) the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development.


June 11
12:30 - 13:30
Event Categories:
, ,
Event Tags:
View Event Website