Advanced SQL Tuning Tips and Techniques On-Line with Dan Hotka

Oracle University is proud to present their online Celebrity Seminar series. This is a unique opportunity to attend an online seminar with one of Oracle's most experienced database experts. The event will consist of two consecutive in-depth four-hour sessions (total duration: 7.5 hours). Join us for this innovative and informative virtual series of Celebrity Seminars from the comfort of your office. Each training session will give you the opportunity to gain in-depth insight into Oracle Database.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

• Stats Pack/AWR
• Oracle Trace (10046 Trace)
• CBO Trace (10053 Trace)
• Trace Analyzer
• SQL T
• PL/SQL Profiler
• PL/SQL tuning tips and technique

• SGA Structure Review
• Collecting statistics
• Oracle Block Internals

• Consolidate your knowledge with a complete review of Oracle SQL Tuning tools (including AWR, Oracle Trace, PL/SQL Profiler, Trace Analyzer, and SQLT)
• Review the important SGA structures including new Result Cache
• Learn how to find problem SQL using V$ and AWR tables (complete with various scripts)