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:

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, Oracle ACE Director, OakTable Network, Oracle DBA

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.

.
Deployment Suite for Oracle

Compare, deploy and source-control Oracle databases. Learn more.

Source Control for Oracle

Source Control for OracleEnables easy Oracle database source control. Learn more.

Schema Compare for Oracle

Schema Compare for OracleThe fast way to compare and update Oracle schemas. Learn more.

Data Compare for Oracle

Data Compare for OracleDatabase diff tool for Oracle table data. Learn more.