OR156

Advanced SQL Tuning Tips and Techniques with Dan Hotka

The course 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. This seminar goes into detail on how Oracle arrives at an execution plan, the explain plan.

Dan illustrates various coding techniques that insure the SQL runs at maximum performance in the current and future Oracle database environments. Indexes are closely examined as well. The internal structure is discussed as well as the decision process Oracle uses when selecting whether to use indexes or not.

Dan will illustrate how to tell which indexes are being used. Dan illustrates various free tuning aids such as the Oracle Trace Facility, Stats Pack, and the newer Trace Analyzer. This seminar then uses this information in a discussion on finding the problem SQL using scripts and additional information in the V$ and X$ dictionary views.

All scripts illustrated in this seminar will be made available to the attendees. The seminar concludes with a discussion on
some Oracle10g new features that might be causing performance issues.

Audience:

  • Database Administrators
  • Developer

Objectives:

To give the attendee valuable performance tuning knowledge

Course Outline:

  • Understanding Explain Plans
  • Controlling Explain Plans
  • Using Hints
  • Using Coding Techniques
  • Index Utilization
  • Index Monitoring
  • Identifying Poor Indexes
  • Working with Oracle Tuning Tools
  • Stats Pack
  • Oracle Trace
  • Trace Analyzer
  • Finding Problem
  • SQL using Scripts
  • Oracle Working Too Hard
  • Oracle Not Allowed to Work

Avtalsrabatter eller andra erbjudanden så som t ex Training Cards kan ej nyttjas i samband med bokning av denna utbildning.

Fakta

Kurs
OR156
Längd
2 dagar
Pris
14.250 kr (exkl. moms)

Det finns inga kurstillfällen
Bookmark and Share

Förkunskaper

A working knowledge of SQL A basic knowledge of SQL statement Explain Plans is helpful

Kursmaterial

The course is in english. Course material in english.

I samarbete med:

Kontakta oss
för mer information:

08 - 587 116 10 (Stockholm)
031 - 773 07 90 (Göteborg)
040-662 20 60 (Malmö)
info@informator.se

 
Gold Partner
Novell Partner