Oracle Application Tuning

WE GET YOU IN SHAPE FOR FIELD USE.schulungen

For your trainings and workshops, H&L place particular value to individuality.
We will train you on site on your own systems, tailored to your requirements. Thus we can ensure a highly practical approach.
Here, you will benefit from the competence, the know-how and the long-lasting project expertise of our instructors.

Course Number: HL-ORA5

Title: Oracle Application Tuning

The performance of applications with database access mostly depends fundamentally on the elapsed time of the SQL statements. If there are poor response times, the responsible statements have to be identified, and a solution for the enhancement of the critical statements has to be found.

This demands knowledge about the means of analysis and an understanding of the function of the Oracle Cost Based Optimizer (CBO). Having that knowledge allows for runtime improvements by applying suitable optimizations like a change in the index design or an improvement of the object statistics.

The relevant topics are explained practice-oriented and easy to understand.

Agenda
  • Basics of Oracle Cost Based Optimizer
  • Determination of critical SQL Statements
  • Tracing / TKPROF
  • Access Paths
  • Index Design
  • Object- and System Statistics
  • Optimization Potential
Duration:

2 – 3 Days

Requirements:

SQL Knowhow