Seminarinhalt
Introduction
- Who tunes
- What to tune
- How to tune
Monitoring With Basic Tools
- Enterprise Manager
- V$ views, Statistics and Metrics
- Wait Events
- Time Model: Overview
Using Automatic Workload Repository
- Automatic Workload Repository Data
- Database Control and AWR
- Generating AWR Reports in SQL*Plus
Identifying the Problem
- Identify a Tuning Issue
- Remedy one problem
Identifying Problem SQL Statements
- Role of the Optimizer
- Generate explain plan
- Access Paths Choices
- Trace the execution
Influencing the Optimizer
- Calibrate I/O
- Optimizer Cost
- Changing Optimizer Behavior
SQL Plan Management
- SQL Profiles
- SQL Access Advisor
- SQL Outlines
- SQL Plan Baselines
Change Management
- SQL Performance Analyzer
- DB Replay
- Server-Generated Alerts
Using Metrics and Alerts
- Database Control Usage Model
- User-Defined SQL Metrics
-
Using ADDM
-
Using Active Session History
-
Historical Data View
Monitoring an Application (Using Services)
- Managing Service
- Service Aggregation and Tracing
- Tracing Your Session
Baselines
- Setting Adaptive Alert Thresholds
- Configuring Normalization Metrics
Tuning the Shared Pool
- Mutex
- Statspack/AWR Indicators
- Library Cache Activity
- Diagnostic Tools
- UGA and Oracle Shared Server
- Large Pool
Tuning the Buffer Cache
- Tuning Goals and Techniques
- Symptoms
- Solutions
Tuning PGA and Temporary Space
- Temporary Tablespace Management
Automatic Memory Management
- Dynamic SGA Feature
- Managing Automatic Memory Management
Tuning Block Space Usage
- Extent Management
- Anatomy of a Database Block
- Block Space Management
Tuning I/O
- Striping and Mirroring
- Using RAID
- I/O Diagnostics
- Using Automatic Storage Management
Performance Tuning: Summary
- Database High Availability: Best Practices
- Tablespace: Best Practices
- Statistics Gathering
Using Statspack
-
Capturing Statspack Snapshots
-
Reporting with Statspack
-
Statspack considerations
-
Statspack and AWR
Zielgruppe
Datenbankadministratoren,Technische Berater
Voraussetzungen
Oracle Database 11g: Administration Workshop I & II