- 浏览: 1004897 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (529)
- 服务器 (8)
- jsp (1)
- java (6)
- AIX (1)
- solaris (3)
- linux学习 (53)
- javaScript (2)
- hibernate (1)
- 数据库 (74)
- sql语句 (8)
- oracle 学习 (75)
- oracle 案例 (42)
- oracle 管理 (42)
- Oracle RAC (27)
- oracle data guard (12)
- oracle 参数讲解 (14)
- Oracle 字符集 (8)
- oracle性能调优 (24)
- oracle备份与恢复 (12)
- oracle Tablespace (9)
- oracle性能诊断艺术 (1)
- oracle 11g学习 (5)
- oracle streams (1)
- oracle upgrade and downgrade (4)
- db2学习 (13)
- db2命令学习 (2)
- mysql (28)
- sql server (30)
- sql server 2008 (0)
- 工具 (10)
- 操作系统 (3)
- c++ (1)
- stock (1)
- 生活 (5)
- HADOOP (2)
最新评论
-
massjcy:
...
如何将ubuntu文件夹中文名改为英文 -
skypiea:
谢谢。。。
终于解决了。。。
Oracle 10.2.0.4(5)EM不能启动的解决方案(Patch 8350262) -
qwe_rt:
引用vi /etc/sysconfig/network 请问 ...
Linux操作系统下配置静态IP上网 -
liuqiang:
sudo killall -9 apache2
ps 和 kill 命令详解 -
dazuiba:
引用*绝杀 kill -9 PID 当使用此命令时,一定要通过 ...
ps 和 kill 命令详解
Oracle have provided many performance gathering and reporting tools over the years. Originally the UTLBSTAT/UTLESTAT scripts were used to monitor performance metrics. Oracle8i introduced the Statspack functionality which Oracle9i extended. In Oracle 10g statspack has evolved into the Automatic Workload Repository (AWR).
- AWR Features
- Snapshots
- Baselines
- Workload Repository Views
- Workload Repository Reports
- Enterprise Manager
AWR Features
The AWR is used to collect performance statistics including:
- Wait events used to identify performance problems.
- Time model statistics indicating the amount of DB time associated with a process from the
V$SESS_TIME_MODEL
andV$SYS_TIME_MODEL
views. - Active Session History (ASH) statistics from the
V$ACTIVE_SESSION_HISTORY
view. - Some system and session statistics from the
V$SYSSTAT
andV$SESSTAT
views. - Object usage statistics.
- Resource intensive SQL statements.
The repository is a source of information for several other Oracle 10g features including:
- Automatic Database Diagnostic Monitor
- SQL Tuning Advisor
- Undo Advisor
- Segment Advisor
Snapshots
By default snapshots of the relevant data are taken every hour and retained for 7 days. The default values for these settings can be altered using:
BEGIN DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings( retention => 43200, -- Minutes (= 30 Days). Current value retained if NULL. interval => 30); -- Minutes. Current value retained if NULL. END; /
The changes to the settings are reflected in the DBA_HIST_WR_CONTROL
view. Typically the retention period should capture at least one complete workload cycle. If you system has monthly archive and loads a 1 month retention time would be more beneficial that the default 7 days. An interval of "0" switches off snapshot collection, which in turn stops much of the self-tuning functionality, hence this is not recommended. Automatic collection is only possible if the STATISTICS_LEVEL
parameter is set to TYPICAL
or ALL
. If the value is set to BASIC
manual snapshots can be taken, but they will be missing some statistics.
Extra snapshots can be taken and existing snapshots can be removed using:
EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot; BEGIN DBMS_WORKLOAD_REPOSITORY.drop_snapshot_range ( low_snap_id => 22, high_snap_id => 32); END; /
Snapshot information can be queried from the DBA_HIST_SNAPSHOT
view.
Baselines
A baseline is a pair of snapshots that represents a specific period of usage. Once baselines are defined they can be used to compare current performance against similar periods in the past. You may wish to create baseline to represent a period of batch processing like:
BEGIN DBMS_WORKLOAD_REPOSITORY.create_baseline ( start_snap_id => 210, end_snap_id => 220, baseline_name => 'batch baseline'); END; /
The pair of snapshots associated with a baseline are retained until the baseline is explicitly deleted:
BEGIN DBMS_WORKLOAD_REPOSITORY.drop_baseline ( baseline_name => 'batch baseline', cascade => FALSE); -- Deletes associated snapshots if TRUE. END; /
Baseline information can be queried from the DBA_HIST_BASELINE
view.
Workload Repository Views
The following workload repository views are available:
-
V$ACTIVE_SESSION_HISTORY
- Displays the active session history (ASH) sampled every second. -
V$METRIC
- Displays metric information. -
V$METRICNAME
- Displays the metrics associated with each metric group. -
V$METRIC_HISTORY
- Displays historical metrics. -
V$METRICGROUP
- Displays all metrics groups. -
DBA_HIST_ACTIVE_SESS_HISTORY
- Displays the history contents of the active session history. -
DBA_HIST_BASELINE
- Displays baseline information. -
DBA_HIST_DATABASE_INSTANCE
- Displays database environment information. -
DBA_HIST_SNAPSHOT
- Displays snapshot information. -
DBA_HIST_SQL_PLAN
- Displays SQL execution plans. -
DBA_HIST_WR_CONTROL
- Displays AWR settings.
Workload Repository Reports
Oracle provide two scripts to produce workload repository reports (awrrpt.sql and awrrpti.sql). They are similar in format to the statspack reports and give the option of HTML or plain text formats. The two reports give essential the same output but the awrrpti.sql allows you to select a single instance. The reports can be generated as follows:
@$ORACLE_HOME/rdbms/admin/awrrpt.sql @$ORACLE_HOME/rdbms/admin/awrrpti.sql
The scripts prompt you to enter the report format (html or text), the start snapshot id, the end snapshot id and the report filename. The resulting report can be opend in a browser or text editor accordingly.
Enterprise Manager
The automated workload repository administration tasks have been included in Enterprise Manager. The "Automatic Workload Repository" page is accessed from the main page by clicking on the "Administration" link, then the "Workload Repository" link under the "Workload" section. The page allows you to modify AWR settings or manage snapshots without using the PL/SQL APIs.
发表评论
-
sqlldr总结参数介绍
2012-06-28 14:29 22721有效的关键字: userid -- ORACLE use ... -
11gR2新特性:STANDBY_MAX_DATA_DELAY
2011-12-27 11:18 1164Active Data Guard 是 Oracle 11g ... -
Linux下用OCCI或OCI连接Oracle
2011-07-26 12:00 2869首先,去oracle官网下载C ... -
Oracle Mutex实现机制
2011-05-18 23:43 1040我们都知道Latch是Oracle ... -
local_listener参数作用
2011-05-10 17:19 1882pmon只会动态注册port等于1521的监听,否则 ... -
oracle伪列 rowid和rownum
2011-03-23 10:00 3497整理ROWID一 一,什么是伪列RowID?1,首先是一种数 ... -
Oracle10gR2 主备自动切换之客户端Failover配置
2011-01-20 10:32 9291. 主库检查和设置假设新增的服务名为ORCL_TAF.LK. ... -
Oracle10g配置Dataguard的相关参数解释
2011-01-20 10:24 1235参考自 http://space.itpub.ne ... -
wrap加密oracle包
2011-01-19 11:52 1275大家都知道oracle的很多系统包是没法看它的源码的,orac ... -
利用hcheck检查数据字典一致性状态
2011-01-17 17:42 1778利用hcheck可以检查oracle数据字典的一致性状态,主要 ... -
插入相同的数据量普通表和临时表产生的redo对比
2011-01-17 16:08 965往临时表里插入相同量 ... -
Database Link与GLOBAL_NAMES参数
2011-01-12 13:36 1009当GLOBAL_NAMES参数设置为TRUE时,使用DATAB ... -
Oracle Streams学习二(清除流配置)
2011-01-09 23:34 1159在完成streams部署之后,如果需要重新配置或舍弃配置,可以 ... -
red hat enterprise 下完全删除oracle 数据库
2011-01-05 01:28 1726步骤 1 以oracle用户登录主、备节点。步骤 2 ... -
Oracle常用dump命令
2010-12-20 00:31 801Oracle常用dump命令,记录一下备查。 一.M ... -
oracle执行DML(事物过程)的深入研究(二)
2010-12-14 15:02 1515接上一节的 oracle执行DML(事物过程)的深入研究(一) ... -
oracle执行DML(事物过程)的深入研究(一)
2010-12-14 10:26 2778用户所执行 DML (即执行事务)操作在 Oracle 内部按 ... -
Oracle基本数据类型存储格式研究(二)—数字类型
2010-12-14 00:35 1445数字类型包含number,intege ... -
Oracle基本数据类型存储格式研究(一)—字符类型
2010-12-13 23:32 11431.char char是定长字符型,内部代码是:96,最多可 ... -
关于oracle rowid的一些内容 -- 转载
2010-12-13 15:47 752本文讨论的是关于oracle ...
相关推荐
• Use the tools based on Automatic Workload Repository to tune the database • Use Statspack reports to tune the database • Diagnose and tune common database performance problems • Use Enterprise ...
NULL 博文链接:https://askerain.iteye.com/blog/2294041
Automatic Workload Repository是10g引入的一个重要组件。在里面存贮着近期一段时间内,默认是7天,数据库活动状态的详细信息。 AWR报告是对AWR视图进行查询而得到的一份自动生成的报告。可以通过下面的脚本手工得到...
本篇文章,小编为大家介绍一下关于AWR 深入分析( Automatic Workload Repository )有需要的朋友可以参考一下
Oracle Database 10g 提供了一个显著改进的工具:自动工作负载信息库 (AWR:Automatic Workload Repository)。Oracle 建议用户用这个取代 Statspack。AWR 实质上是一个 Oracle 的内置工具,它采集与性能相关的统计...
Oracle AWR(Automatic Workload Repository)是 Oracle Database 10g 中一个显著改进的工具,用于采集性能相关的统计数据,并从这些统计数据中导出性能量度,以跟踪潜在的问题。AWR 实质上是一个 Oracle 的内置工具...
oracle查看awr的详细介绍 AWR 是 Oracle 10g 版本 推出的新特性, 全称叫Automatic Workload Repository-自动负载信息库, AWR 是通过对比两次快,照(snapshot)收集到的统计信息,来生成报表数据,生成的报表包括多个...
使用Oracle Automatic Workload Repository和SQL Tuning Sets诊断和调整系统性能 使用认证、授权、细粒度审核和细粒度访问控制来实施健壮的安全性 使用Oracle Real Application Clusters和Oracle Active Data ...
Automatic Workload Repository(AWR)是10g引入的一个重要组件。在里面存贮着近期一段时间内(默认是 7 天)数据库活动状态的详细信息
AWR报告生成手动配置,调整AWR配置,dbms_workload_repository包
•Configure and manage disk groups using Oracle Automatic Storage Management •Work with services, voting disks, and Oracle Clusterware repository •Diagnose performance problems with Oracle Wait ...
AWR 是 Oracle 10g 版本 推出的新特性, 全称叫Automatic Workload Repository-自动负载信息库, AWR 是通过对比两次快照(snapshot)收集到的统计信息,来生成报表数据,生成的报表包括多个部分
使用Oracle Automatic Workload Repository和SQL Tuning Sets诊断和调整系统性能 使用认证、授权、细粒度审核和细粒度访问控制来实施健壮的安全性 使用Oracle Real Application Clusters和Oracle Active Data ...
Automatic Workload Repository-自动负载信息库 AWR 是通过对比两次快照(snapshot)收集到的统计信息,来生成报表数据,生成的报表包括多个部分
AWR 是 Oracle 10g 版本 推出的新特性, 全称叫Automatic Workload Repository-自动负载信息库, AWR 是通过对比两次快,照(snapshot)收集到的统计信息,来生成报表数据,生成的报表包括多个部分.
AWR全称叫Automatic Workload Repository自动负载信息库,AWR 是通过对比两次快照(snapshot)收集到的统计信息,来生成报表数据,生成的报表包括多个部分,通过AWR报告,DBA可以容易地获知最近数据库的活动状态,...
AWR 是 Oracle 10g 版本 推出的新特性, 全称叫Automatic Workload Repository-自动负载信息库, AWR 是通过对比两次快照(snapshot)收集到的统计信息,来生成报表数据,生成的报表包括多个部分
原书名: OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 原出版社: McGraw-Hill Osborne Media 作者: (美)John Watson Roopesh Ramklass Bob Bryla 译者: ...
前言概述AWR 是 Oracle 10g 版本 推出的新特性, 全称叫 Automatic Workload Repository-自动负载信息库, AWR 是