Oracle SQL Monitoring - Performance Analysis

Presented by Doug Burns (Oracle ACE Director, OakTable)

Weds 27th February 2013

This webinar has now finished, but feel free to click the button above to watch the recording.

If you missed the Q+A, or we were unable to answer your question, or you would like to ask the presenters a new question, please use the comments function under the post on: All Things Oracle.com.

Summary

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

---

Doug Burns

Doug Burns is an independent consultant with over 20 years experience of working with Oracle databases in a range of industries and applications. As well as presenting regularly at User Group conferences, he has developed, taught, and edited performance-related courses for a number of different clients. He is a member of The Oak Table Network and an Oracle Ace Director and maintains a popular blog at oracledoug.com.

.