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.
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 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.
Deployment Suite for Oracle
Compare, deploy and source-control Oracle databases. Learn more.
Source Control for Oracle
Enables easy Oracle database source control. Learn more.
Schema Compare for Oracle
The fast way to compare and update Oracle schemas. Learn more.
Data Compare for Oracle
Database diff tool for Oracle table data. Learn more.