oracle学习11g性能调优官方PPTless_07

来源：网络收集时间：2026-09-06

导读： Using AWR-Based Tools Copyright 2008, Oracle. All rights reserved. ObjectivesAfter completing this lesson, you should be able to do the following: Describe tuning automatic maintenance tasks Generate ADDM reports Generate Active Session Hi

Using AWR-Based Tools

ObjectivesAfter completing this lesson, you should be able to do the following: Describe tuning automatic maintenance tasks Generate ADDM reports Generate Active Session History (ASH) reports

7-2

Automatic Maintenance Tasks

7-3

Maintenance WindowsMaintenance Window Group10 PM – 2 AM Mon to Fri 6 AM – 2 AM Sat to Sun

7-4

Default Maintenance PlanSQL> SELECT name FROM V$RSRC_PLAN 2 WHERE is_top_plan = 'TRUE';

NAME -------------------------------DEFAULT_MAINTENANCE_PLAN

7-5

Automated Maintenance Task PrioritiesMaintenance window

…

Run Job1 with urgent priority.

Run Job2 with urgent priority.

Run Job3 with high priority.

Run Job3 with medium priority.

Run Job4 with medium priority.

…

DBA_AUTOTASK_TASKurgent Stats high medium

MMON

ABPSpace

SQL

Job1 … Jobn

7-6

Tuning Automatic Maintenance TasksServer > Automatic Maintenance Tasks > Configure

7-7

ADDM Performance Monitoring

MMON

60 minutes

In-memory statistics SGA

Snapshots

ADDM

AWR ADDM results

7-8

ADDM and Database TimeUser sends a request. User gets a response. Wide area network Application server Local area network Oracle database Database timeConnectExecute Fetch Fetch Fetch

Wall-clock timeExecute

User 1 User 2

User n

7-9

DBTime-Graph and ADDM MethodologyRoot nodeSymptoms

User connect

SQL optimization

SQL execution

CPU capacity

I/O capacity

Database locksRoot causes

Undersized buffer cacheDimension 1 Dimension 2

Insufficient I/O bandwidth

7 - 10

Top Performance Issues DetectedExcessive logon/logoffMemory undersizing Not detected by Statspack Hot blocks and objects w/SQL RAC service issues

Locks and ITL contentionCheckpointing causes PL/SQL, Java time Streams, AQ, and RMAN Top SQL I/O issues Parsing ADDM identifies top issues.

Configuration issuesApplication usage

7 - 12

Database Control and ADDM Findings

7 - 13

ADDM Analysis Results

7 - 14

ADDM Recommendations

7 - 15

Database Control and ADDM Task

7 - 16

Changing ADDM Attributes1. Ensure that STATISTICS_LEVEL is set to TYPICAL or ALL. 2. ADDM analysis of I/O performance depends on the expected speed of the I/O subsystem:a. Measure your I/O subsystem speed. b. Set the expected spee

SQL> exec DBMS_ADVISOR.SET_DEFAULT_TASK_PARAMETER('ADDM', 'DBIO_EXPECTED', 8000); SELECT parameter_value, is_default FROM dba_advisor_def_parameters WHERE advisor_name = 'ADDM' AND parameter_name = 'DBIO_EXPECTED';

7 - 17

…… 此处隐藏：1085字，全部文档内容请下载后查看。喜欢就下载吧 ……

oracle学习11g性能调优官方PPTless_07.doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.jiaowen.net/fanwen/1993689.html（转载请注明文章来源）

上一篇：《农业昆虫学(农学,植科,种子)》课程教学大纲
下一篇：军用方舱夹芯大板工艺技术研究