Oracle Database 10g: SQL Tuning Workshop

amk-group
Inhouse

3.300 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
030 -... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

  • Workshop
  • Inhouse
  • Dauer:
    3 Tage
Beschreibung

This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms availab

Wichtige informationen

Häufig gestellte Fragen

· Voraussetzungen

keine

Was lernen Sie in diesem Kurs?

SQL

Themenkreis

Seminarziel:

This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to ''play, discover, and learn'' at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

Zielgruppe:

Forms Developer, Java Developer, PL/SQL Developer, Technical Consultant, Reports Developer, Business Intelligence Developer

Inhalt:

  • Database Architecture overview


  • Following a Tuning Methodology


  • Designing Applications for performance


  • Introducing the optimiser


  • Optimizer Operations


  • Displaying Execution plans


  • Gathering Statistics


  • Application Tracing


  • Identifying High Load SQL


  • Automatic SQL Tuning


  • Introduction to Indexes


  • Advanced Indexes


  • Optimizer Hints and Plan Stability


  • Materialized Views and Temporary Tables


Voraussetzung:

keine


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen