les 01-介绍 ( 20 ).ppt

Introduction
Course Objectives
pleting this course, you should be able to do the following:
Use the Oracle database tuning methodology appropriate to the available tool
Utilize database advisors to proactively tune an Oracle database
Use the tools based on Automatic Workload Repository to tune the database
Use Statspack reports to tune the database
Diagnose and mon database performance problems
Use Enterprise Manager performance-related pages to monitor an Oracle database
Agenda
Automatic Shared Memory Management
10
3
Tuning the Buffer Cache
9
3
Tuning the Shared Pool
8
2
Reactive Tuning
7
2
Using Automatic Workload Repository
6
2
Using Statspack
5
1
Metrics, Alerts, and Baselines
4
1
Statistics and Wait Events
3
1
Performance Tuning: Overview
2
1
Introduction
1
1
Topic
Lesson
Day
Agenda
Performance Tuning: Summary
15
4
Tuning Block Space Usage
14
4
Tuning PGA and Temporary Space
13
4
Tuning I/O
12
4
Checkpoint and Redo Tuning
11
3
Topic
Lesson
Day
Tuning Questions
Who tunes?
What to tune?
How to tune?
Who Tunes?
The people who are involved with tuning:
Database administrators
Application architects
Application designers
Application developers
System administrators
What to Tune Overall?
Performance tuning areas:
Application:
Poorly written SQL
Serialized resources
Poor session management
Instance tuning:
Memory
Database structure
Instance configuration
Operating system:
I/O
Swap
Parameters
The focus of this course
What to Tune in the Instance
Instance tuning areas:
Memory:
Insufficient memory
Poorly allocated memory
I/O:
Insufficient bandwidth
Poorly allocated disk space
Poor database configuration
Instance configuration:
Inappropriate instance parameters
Poor recovery and availability configuration
How to Tune
The procedures used to tune depend on the tool:
Basic tools:
Dynamic performance views
Statistics
Metrics
Enterprise Manager pages
AWR or Statspack
Automatic Database Diagnostic Mon