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

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

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
Day 2: SGA/Problem discovery topics
  • 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)

There are no reviews yet.

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.