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 |

Hire