Advanced SQL Tuning Tips and Techniques On-Line with Dan Hotka
Starting dates and places
Description
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 re…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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.
Audience
Course Topics Day 1: Oracle SQL Tuning Tool Review
- 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
Course Objectives
- 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)
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.