Performance 11g

About Training

DESCRIPTION

Duration: 30 h
Target: professionals who wish to monitor database performance, and to make make adjustments that will provide performance gains.
Equirements: Database Concepts, Basic knowledge of SQL.

Course Objectives

• Know the database architecture
• Manipulating the physical and logical structure of the database
• Set database parameters
• Monitor sessions database
• Creating tables and indexes

Performance Tuning Overview Oracle Tools for Performance Tuning
    Set Performance Goals
Process Performance Tunin
    Oracle Enterprise Manager Web OEM Web
Vision 10g DB Control
TKPROF
EXPLAIN
Other Tools Oracle Memory Setting
    Oracle Expert Overview
Vision Spot Light
    Adjusting the SGA
Adjusting the PGA
Setting the Shared Server
I/O Tunning Understanding execution plans
    Relocating Tablespaces and Data Files
Decreasing Concurrency in Datafiles
Adjusting Controlfiles
Setting the Log Files Online and Archive
    Identifying FULL Operations TABLE SCAN (FTS)
Identifying Classification Operations/SORT
Using Hints Stabilizing execution plans
    APPEND
INDEX (ASC/DESC)
USE_ (NL/HASH)
PARALLEL
    Package OUTLN
Modifying Execution Plans
Managing Oracle Statistics Enabling Traces Tracking Users
    Tables and Indexes statistics
Schemes statistics
Database statistics
System statistics
    By Session Level
By Database Level
Understanding TKPROF Output Optimizer types used by Oracle
    Step Parse, Execute, Fetch
Selecting Sentences More Issues
    COST x RULE
Using Resource Consumer Groups Using STATSPACK and AWR reports
    Understanding How Execution Plans Work
Creating Plans and Consumer Groups
creating Diretvas
Enabling Plans
Assigning Groups to Users and Sessions
    Understanding the Operation
generating Reports
Interpreting results
Managing Performance on Enterprise Manager WEB
    OEM Web Performance Organization
Identifying Issues
Observing Heavy sessions
Using the Advisor Queries
Using the Auto Advisor – ADDM
02.fw30H

Hire

 SQL 11g PL/SQL 11g Management 11g Backup 11g Performance 11g

Nossos Clientes