Course Oracle - Optimalization and tuning

Duration (days): 3
Price (CZK): 15000

Oracle - Optimalization and tuning topics:

Database Architecture overview

Overview 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

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

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs