没有合适的资源?快使用搜索试试~ 我知道了~
Oracle Database 12c Performance Tuning - Vol 1
需积分: 0 0 下载量 19 浏览量
2024-05-13
17:49:19
上传
评论
收藏 13.31MB PDF 举报
温馨提示
试读
406页
Oracle Database 12c Performance Tuning - Vol 1
资源推荐
资源详情
资源评论
Oracle Database 12c: Performance
Management and Tuning
Student Guide9ROXPH,
D79236GC10
Edition 1.0
May 2015
May
2015
D86567
Oracle Internal & Oracle Academy Use Only
Copyright © 2014, Oracle and/or its affiliates. All rights reserved.
Disclaimer
This document contains proprietar
y
information and is protected b
y
cop
y
ri
g
ht and
Authors
Donna Keesling
James Spiller
yyyg
other intellectual property laws. You may copy and print this document solely for your
own use in an Oracle training course. The document may not be modified or altered
in any way. Except where your use constitutes "fair use" under copyright law, you
may not use, share, download, upload, copy, print, display, perform, reproduce,
publish, license, post, transmit, or distribute this document in whole or in part without
the express authorization of Oracle.
The information contained in this document is subject to change without notice. If you
find any problems in the document, please report them in writing to: Oracle University,
500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not
tdt b
f
Technical Contributors
and Reviewers
Harald van Breederode
Yio Liong Liew
Sailaja Pasupuleti
Naoki Kato
Joel Goodman
warran
t
e
d
t
o
b
e erro
r
-
f
ree.
Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using
the documentation on behalf of the United States Government, the following notice is
applicable:
U.S. GOVERNMENT RIGHTS
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or
disclose these training materials are restricted by the terms of the applicable Oracle
Joe Fong
Ira Singer
Herbert Bradbury
Gerlinde Frenzen
Christopher D Andews
Branislav Valny
Anthony Woodell
Andy Fortunak
disclose
these
training
materials
are
restricted
by
the
terms
of
the
applicable
Oracle
license agreement and/or the applicable U.S. Government contract.
Trademark Notice
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names
may be trademarks of their respective owners.
Editor
Aju Kumar
Graphic Designer
Divya Thallap
Publishers
Publishers
Pavithran Adka
Nita Brozowski
Jobi Varghese
Oracle Internal & Oracle Academy Use Only
iii
Contents
1 Introduction
Course Objectives 1-2
Organization 1-3
Agenda 1-4
Topics Not Included in This Course 1-6
What Is Performance Management? 1-7
Who Tunes? 1-9
What Does the DBA Tune? 1-10
Types of Tuning 1-11
Tuning Methodology 1-12
Effective Tuning Goals 1-14
General Tuning Session 1-16
Quiz 1-18
Summary 1-19
2 Basic Tuning Diagnostics
Objectives 2-2
Performance Tuning: Diagnostics 2-3
Performance Tuning: Features and Tools 2-4
Tuning Objectives 2-5
Top Timed Events 2-6
DB Time 2-7
CPU and Wait Time Tuning Dimensions 2-8
Time Model: Overview 2-9
Time Model Statistics Hierarchy 2-10
Time Model: Example 2-12
Quiz 2-13
Dynamic Performance Views 2-14
Dynamic Performance Views: Usage Examples 2-15
Dynamic Performance Views: Considerations 2-16
Statistic Levels 2-17
Instance Activity and Wait Event Statistics 2-19
System Statistic Classes 2-21
Displaying Statistics 2-22
Displaying SGA Statistics 2-24
Oracle Internal & Oracle Academy Use Only
iv
Wait Events 2-25
Using the V$EVENT_NAME View 2-26
Wait Classes 2-27
Displaying Wait Event Statistics 2-28
Commonly Observed Wait Events 2-30
Using the V$SESSION_WAIT View 2-31
Precision of System Statistics 2-33
Quiz 2-34
Enterprise Manager: Overview 2-35
Oracle Enterprise Manager Database Express Architecture 2-36
Configuring Enterprise Manager Database Express 2-37
Accessing the Enterprise Manager Database Express Database Home Page 2-38
Viewing Performance Information on the Database Home Page 2-39
Viewing the Performance Hub Page 2-41
Oracle Enterprise Manager Cloud Control Components 2-43
Using Features of the Oracle Management Packs 2-44
Viewing the Alert Log 2-46
Using Alert Log Information as an Aid in Tuning 2-48
Administering the DDL Log File 2-49
Understanding the Debug Log File 2-50
User Trace Files 2-51
Background Processes Trace Files 2-52
Quiz 2-53
Summary 2-54
Practice 2 Overview: Using Basic Tools 2-55
3 Using Automatic Workload Repository
Objectives 3-2
Automatic Workload Repository: Overview 3-3
Automatic Workload Repository Data 3-4
Workload Repository 3-5
AWR Administration 3-6
AWR Snapshot Purging Policy 3-7
Managing Snapshots with PL/SQL 3-8
AWR Snapshot Settings 3-9
Manual AWR Snapshots 3-10
Generating AWR Reports 3-11
Generating AWR Reports by Using SQL*Plus 3-12
Reading the AWR Report 3-13
Statspack and AWR Reports 3-14
Reading a Statspack or an AWR Report 3-15
Oracle Internal & Oracle Academy Use Only
v
Compare Periods: Benefits 3-16
Snapshots and Periods Comparisons 3-17
Compare Periods: Results 3-18
Compare Periods: Report 3-19
Quiz 3-20
Summary 3-21
Practice 3 Overview: Using AWR-Based Tools 3-22
4 Defining the Scope of Performance Issues
Objectives 4-2
Defining the Problem 4-3
Limit the Scope 4-4
Determining Tuning Priorities 4-5
Common Tuning Problems 4-6
Tuning Life Cycle Phases 4-8
Tuning During the Life Cycle 4-9
Application Design and Development 4-10
Testing: Database Configuration 4-11
Deployment 4-12
Production 4-13
Migration, Upgrade, and Environment Changes 4-14
ADDM Tuning Session 4-15
Performance Versus Business Requirements 4-16
Performance Tuning Resources 4-17
Filing a Performance Service Request 4-18
Monitoring and Tuning Tools: Overview 4-19
Quiz 4-21
Summary 4-22
Practice 4 Overview: Identifying the Problem 4-23
5 Using Metrics and Alerts
Objectives 5-2
Metrics and Alerts 5-3
Limitation of Base Statistics 5-4
Typical Delta Tools 5-5
Oracle Database Metrics 5-6
Benefits of Metrics 5-7
Viewing Metric History Information 5-8
Viewing Metric Details 5-9
Statistic Histograms 5-10
Histogram Views 5-11
Oracle Internal & Oracle Academy Use Only
剩余405页未读,继续阅读
资源评论
lzyever
- 粉丝: 2185
- 资源: 14
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功