Beating the Optimizer with Jonathan Lewis
17-18 January 2013

This is a follow-on from the course “Designing Optimal SQL”, and focuses on writing SQL to emulate transformations that are currently not available to the Oracle Optimizer.In this session you will examine a very simple join and note a fundamental limitation in the optimizer’s ability to find the best strategy for joining two tables. You will see how you can overcome this limitation – at a cost of more complex SQL – and look at the way you need to think about joins to minimize the work you do, noting that the possible benefit isn’t always as great as you might first think.

RAC Performance Tuning On-Line with Arup Nanda
25 January 2013

The “Performance Tuning in RAC” seminar is spread over 4 modules of total 8 hours and aims exclusively at training the Oracle DBA in improving the performance of the RAC system. The foundation of any tuning depends heavily on the proper diagnosis. So, this seminar starts with the building the knowledge on the RAC system, with respect to performance, and gradually prepares the student to unravel the mysteries surrounding performance issues.

Mastering Oracle Parallel Execution with Randolf Geist
30 January 2013

In order to process large amounts of data as quickly as possible and leverage the capabilities of today's hardware Oracle offers its Parallel Execution feature as part of the Enterprise Edition license. There might be a lot of cases where simply adding parallelism to a statement execution doesn't deliver the expected reduction in runtime. It's therefore crucial to understand how Oracle Parallel Execution works, what its building blocks are, what kind of diagnostic possibilities are offered to systematically analyze Parallel Execution performance and how to apply appropriate measures.

Minimize Downtime with Rolling Upgrade using Data Guard with Uwe Hesse
8 February 2013

Starting with 10g, Logical Standby Databases offer a method to minimize the downtime related to a Database Upgrade to the time it takes to do a switchover. This Seminar covers Rolling Upgrades with Logical Standby - in place already or created for that purpose – as well as Rolling Upgrade with a present Physical Standby. Rolling Upgrade procedures, processes and its restrictions are explained. All system requirements will be covered, as well as backup and fallback procedure.

Understanding Explain Plans & Index Utilization Online
with Dan Hotka
16-17 April 2013

This session starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. The trainer will illustrate various coding techniques that insure the SQL runs at maximum performance in the current and future Oracle database environments and cost-based statistics that are useful to improve SQL performance and index selection as well. Understanding how Indexes work and when to use the different kinds of indexes is critical to both individual SQL performance and the overall batch cycle performance.