ORACLEAWR简介
AWR
AUTOMATED WORKLOAD REPOSITORY
Oracle 10g provides the AWR. The AWR is a repository of performance information collected by the database to aid in the tuning process for DBAs. The main focus for the Oracle database in version 10g is self-manageability. AWR is the place where the data to aid in self-management is stored.
WHAT DOES AWR DO?
Historically people used bstat and estat to collect Oracle statistics over a time period and then compare them to each other. The bstat/estat approach was replaced with statspack available in Oracle 8i. Statspack was a package provided by Oracle that did roughly the same thing but better. Statspack has now been surpassed in functionality by AWR which is always collecting execution statistics for future analysis and tuning performed by all of the expert components provided by Oracle. Oracle recommends that all statspack users switch to AWR in 10g.
The statistics saved in the AWR provide full trending an analysis. In addition, database up/down events will not lose data in the AWR.
AWR collects data in the following categories:
Base Statistics - general database performance metrics since instance start-up.
SQL – statistics for each executed SQL statement (# executions, # physical reads, etc)
Deltas – the rate of change of important stats over time. Similar to our collection technologies that do before and after snapshots and only show the deltas over the specified period of time.
Expert Advice – results of the expert analysis engine provided in 10g.
The metrics collected by AWR are easily obtained from v$metricname:
Total Wait Counts Total Time Waited Number of Sessions Waiting (Event) Total Wait Counts Total Time Waited Database Time Spent Waiting (%) Average Users Waiting Counts Host CPU Utilization (%) Database Time Per Sec Txns Per Logon Executions Per Sec Executions Per Txn Session Limit % Process Limit % PGA Cache Hit % Shared Pool Free % Library Cache Miss Ratio Library Cache Hit Ratio Row Cache Miss Ratio Row Cache Hit Ratio Response Time Per Txn Database CPU Time Ratio Database Wait Time Ratio SQL Service Response Time User Limit % Current Open Cursors Count Current Logons Count Global Cache Blocks Lost Global Cache Blocks Corrupted Global Cache Average Current Get Time Global Cache Average CR Get Time GC Current Block Received Per Txn GC Current Block Received Per Second GC CR Block Received Per Txn GC CR Block Received Per Second PX downgraded to serial Per Sec PX downgraded Parallel Operation Per Sec PX downgraded 75% or more Per Sec PX downgraded 50% or more Per Sec PX downgraded 25% or more Per Sec Branch Node Splits Per Txn Branch Node Splits Per Sec Leaf Node Splits Per Txn Leaf Node Splits Per Sec User Rollback Undo Records Applied Per
Oracle AWR 介绍_计算机软件及应用_IT/计算机_专业资料。Oracle AWR 介绍 Oracle Database 10g 提供了一个显著改进的工具:自动工作负载信息库 (AWR:Automatic ...
Oracle AWR_互联网_IT/计算机_专业资料。Oracle AWROracle AWR 收藏 一、WHY——为什么会出现 ASH 和 AWR? 1. 10g 之前 用户的连接将产生会话,当前会话记录...
Oracle_AWR_报告分析实例讲解_IT/计算机_专业资料。Oracle_AWR_报告分析实例讲解WORKLOAD REPOSITORY report for DB Name ICCI DB Id Instance Inst num Release ...
oracle awr报告详解_计算机软件及应用_IT/计算机_专业资料。在oracle的性能分析上,awr报告能提供最需要的信息,这个文档可以帮助入门的人学习awr报告,怎么读awr报告...
解读ORACLE AWR报告_IT/计算机_专业资料。oracle调优报告解读分析解读AWR 报告 Basic Information AWR报表的开头部分记录了数据库名称、DBID、实例名、实例号、上次...
Oracle awr 的是使用方法_IT认证_资格考试/认证_教育专区。Oracle awr 的是使用方法ASH 和 AWR 的故事 1.1 关于 ASH 我们都知道,用户在 ORACLE 数据库中...
ORACLE 性能诊断 AWR 报告的使用和分析为满足业务的运行要求,高性能要求是目前 IT 系统普遍面临的最棘手问题,尤其是客户面对着 目前越来越庞大系统和数据, 系统整合...
ORACLE AWR报告生成步骤_计算机软件及应用_IT/计算机_专业资料。本人ORACLE数据管理部分就是自学的入门级水准 所以文档如果有问题的话 希望大家多多包涵。...
oracle awr报告生成与分析_计算机软件及应用_IT/计算机_专业资料。oracle awr 报告生成与分析 Automatic Workload Repository(AWR)是 10g 引入的一个重要组件。 ...
热门文档