Schulung/Seminar: Oracle Database 10g: SQL Tuning Workshop |
 |
| Seminar-ID: | D17265 |  Beschreibung |
|
| Preis: | EUR 1770,- zzgl. Mwst. | Angebot |
|
| Dauer: | 3 Tage | Buchung |
|
Lerninhalte
Teilnehmerkreis
Vorkenntnisse
Kursziel
Sachgebiete
Aktuelle Termine
Zurück zur Seminarauswahl
Lerninhalte
Describe the basic steps in processing SQL statementsDescribe the causes of performance problems
Understand where SQL tuning fits in an overall tuning methodology
Describe Automatic SQL Tuning
Use the diagnostic tools to gather information about SQL statement processing
Understand Optimizer behavior
Influence the optimizer behavior
Influence the physical data model so as to avoid performance problems
Top
Teilnehmerkreis
Forms EntwicklerJava Entwickler
PL/SQL-Entwickler
Technischer Berater
Top
Vorkenntnisse
Professioneller Einstieg in Oracle Database 11g SQLTop
Kursziel
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.Top
Sachgebiete
Database Architecture overviewOverview of Database architecture
Listing the SQL Statement Processing Steps
Identifying Means to Minimize Parsing
Stating the Use of Bind Variables
Following a Tuning Methodology
Describing the Causes of Performance Problems
Identifying Performance Problems
Using a Tuning Methodology
Designing Applications for performance
Oracle Methodology
Understanding Scalability
System Architecture
Application Design Principles
Deploying New Applications
Introducing the optimizer
Describe the functions of the Oracle optimizer
Identify the factors that the optimizer considers when it selects an execution plan
Set the optimizer approach at the instance and session level
Use dynamic sampling
Optimizer Operations
Execution plans
Types of Joins
Displaying Execution plans
Using the EXPLAIN PLAN Command
Interpreting EXPLAIN Output
Interpreting AUTOTRACE Statistics
Gathering Statistics
Using the DBMS_STATS Package
Identifying Table, Column, and Index Statistics
Building Histograms
Application Tracing
Statspack
End to End tracing
Invoking the SQL Trace Facility
Setting Up Appropriate Initialization Parameters
Formatting Trace Files with TKPROF
Interpreting the Output of the TKPROF Command
Identifying High Load SQL
Use different methods to identify high-load SQL
ADDM
Top SQL
Dynamic Performance views
Statspack
Automatic SQL Tuning
Query Optimizer Modes
Types of Tuning Analysis
SQL Tuning Advisor and SQL Tuning Sets
Top SQL
Introduction to Indexes
Identifying Row Access Methods
Creating B-Tree Indexes
Understanding B-Tree Index Access and Index Merging
Advanced Indexes
Using Bitmapped Indexes
Using Function-Based Key Indexes
Optimizer Hints and Plan Stability
Using Hints
Purpose and Benefits of Optimizer Plan Stability
Materialized Views and Temporary Tables
Using the CREATE MATERIALIZED VIEW Syntax
Utilizing Query Rewrites
Top
Termine
Aktuelle Termine auf Anfrage training@cns-gruppe.comTop
Info-Hotline von 9.00 - 18.00 Uhr:
Kostenlos aus dem Deutschen Festnetz,
oder +49.2302.914210 aus dem Ausland bzw. vom Handy