Top 60 Oracle Blogs

Recent comments

Oracle Expert Seminars

As already announced in the past the following Oracle Expert Seminars have been scheduled by Oracle University:

3rd December: "Advanced Oracle Performance Troubleshooting", Wien, Austria
17th December: "Mastering Oracle Parallel Execution", London UK
30th January 2013: "Mastering Oracle Parallel Execution", LVC, EMEA

I've also added the entries to the list on the right hand side under "Upcoming Public Appearances".

The "Advanced Oracle Performance Troubleshooting" seminar I've already done in the past for Oracle University. It does a walk-through of common troubleshooting scenarios and how to systematically approach them. It then continues with less common scenarios and gives you some ideas how these can be addressed if the commonly known toolset (SQL Trace, Wait Interface etc.) is not sufficient. You can get an idea about the content by looking at the presentation material I used in the past, of course the one day seminar covers much more details and topics.

"Mastering Oracle Parallel Execution" is a new one-day seminar that focuses really on three topics:

1. Understanding the general idea how a Parallel Execution of a single SQL statement works. These are general considerations that are not only applicable to Oracle. This will give you the background and explains what these PX ITERATOR, PX SEND / RECEIVE etc. operations in Oracle Parallel Execution plans are and why they are there

2. Once we've understood the general concepts this will lead us naturally to Oracle's specific implementation of these ideas and the implications of that implementation like the "Producer / Consumer" model used by Oracle. We will also learn how we can influence what Oracle does and the implications of the different options available. Of course we'll also cover how to read and interpret Parallel Execution plans as part of that.

3. Finally we'll spend some time on how Parallel Execution can be analyzed efficiently using tools like Real-Time SQL Monitoring, Active Session History and Dynamic Performance Views specific to Parallel Execution, and why the usual tools like Extended SQL Trace, DBMS_XPLAN.DISPLAY_CURSOR etc. are not well suited for analyzing Parallel Execution.

Of course, there is a lot more to say about Parallel Execution, so depending on time and audience there is also the chance to cover more topics like Workload Management (Resource Manager, Auto DOP etc.), PX tracing events, specific considerations to Parallel DML, Parallel DDL and running User-Defined PL/SQL Functions in parallel, etc. etc.

But the idea of the seminar is to cover the above core content, because once you've understood these you should be able to fully leverage the power of Parallel Execution - and that's what the seminar aims for.