Oracle SQL Monitoring - Performance Analysis

SQL Monitoring is the best new feature of Oracle 11g for performance analysts, developers and support teams. Finally there is a tool that provides the most accurate, useful and interesting information when a SQL statement is running for longer than expected in a clear format with no minimal advance configuration requirements:

    What execution plan is really being used?
    What row source cardinality calculations are incorrect?
    What steps in the plan are taking the most time and consuming most resources?

In this presentation, Doug Burns will demonstrate the various ways of accessing SQL Monitoring functionality and use example reports to show how the information can be used to analyse both currently running and completed statements. It will also describe and offer solutions to some of the minor quirks you might encounter.

A live Q+A with Doug Burns will follow the presentation

Register