How to Interpret the OS stats section of an AWR report (文档 ID 762526.1)
来源:互联网 发布:应聘php 编辑:程序博客网 时间:2024/04/28 20:58
In this Document
APPLIES TO:
Oracle Server - Enterprise Edition - Version 10.2.0.1 and laterInformation in this document applies to any platform.
GOAL
This article outline how to read the OS Stats section of an AWR report, and outlines what that section tells the user with regards to the CPU utilization.
FIX
Thew following is an example section of an AWR OS Statistics section with annotation in the column to the right:
-------------------------------- --------------------
NUM_LCPUS 0 /* probably 0 because LPARs not set up */
NUM_VCPUS 0 /* same thing */
AVG_BUSY_TIME 77,518 /* BUSY_TIME / NUM_CPUS */
AVG_IDLE_TIME 281,226 /* IDLE_TIME / NUM_CPUS */
AVG_IOWAIT_TIME 24,128 /* IOWAIT_TIME / NUM_CPUS */
AVG_SYS_TIME 5,664 /* SYS_TIME / NUM_CPUS */
AVG_USER_TIME 71,747 /* USER_TIME / NUM_CPUS */
BUSY_TIME 621,022 /* time equiv of %usr+%sys in sar output */
IDLE_TIME 2,250,637 /* time equiv of %idle in sar */
IOWAIT_TIME 193,913 /* time equiv of %wio in sar */
SYS_TIME 46,166 /* time equiv of %sys in sar */
USER_TIME 574,856 /* time equiv of %usr in sar */
LOAD 0 /* meaning unclear */
OS_CPU_WAIT_TIME 677,100 /* supposedly time waiting on run queues */
RSRC_MGR_CPU_WAIT_TIME 0 /* time waited coz of resource manager */
PHYSICAL_MEMORY_BYTES 16,508,780,544 /* total memory in use supposedly */
NUM_CPUS 8 /* number of CPUs reported by OS */
NUM_CPU_CORES 4 /* number of CPU sockets on motherboard */
So if you want to convert the times (expressed in seconds) back into percentages, then total elapsed time is following:
or
e = SYS_TIME + USER_TIME + IDLE_TIME + IOWAIT_TIME
(since BUSY_TIME = (SYS_TIME+USER_TIME) )
E should also be roughly close to the elapsed time of the report:
However, since the report itself takes time to run (actually the snapshots take time as well). Neither the snapshot, the V$ tables that the snapshot is taken from nor the report itself are from a single consistent point in time.
At this point you can see,
CPU used by this session 234,148 65.3 112.4
This is CPU time Oracle reports it used (though we don't include time spent in SQL*Net code and maybe not all background processes may be reporting the CPU time they used). It is expressed in centiseconds (1/100th of a second) rather than seconds. So:
will tell you what percent of the total CPU resources on the machine Oracle was keeping busy.
In fact it is probably easier to look at DB CPU statistic for this since that is already in seconds.
Note that:
i.e. the amount of CPU usage that seems to be because of things mostly happening outside the database.
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > RDBMS
- How to Interpret the OS stats section of an AWR report (文档 ID 762526.1)
- How to Interpret the "SQL ordered by Physical Reads (UnOptimized)" Section in AWR (文档 ID 1466035.1)
- How to Generate an AWR Report and Create Baselines (文档 ID 748642.1)
- How to Read PGA Memory Advisory Section in AWR and Statspack Reports (文档 ID 786554.1)
- How to Read Buffer Cache Advisory Section in AWR and Statspack Reports. (文档 ID 754639.1)
- How to Interpret the oraparam.ini File [ID 237097.1]
- How to interpret the meanings of HDD LEDs
- How to Export and Import the AWR Repository From One Database to Another (文档 ID 785730.1)
- Oracle AWR 报告中 No data exists for this section of the report 说明
- Oracle AWR 报告中 No data exists for this section of the report 说明
- Oracle AWR 报告中 No data exists for this section of the report 说明
- Oracle AWR 报告中 No data exists for this section of the report
- How to generate AWR report manually
- How to Calculate the Number of IOPS and Throughput of a Database (文档 ID 2206831.1)
- How to collect the full path name of the files in ASM diskgroups (文档 ID 888943.1)
- How to collect the full path name of the files in ASM diskgroups (文档 ID 888943.1)
- How To Add/Increase The Size Of Redo Log Files In Rac Environment? (文档 ID 779306.1)
- Regression Analysis: How to Interpret the Constant (Y Intercept)
- 弟弟的作业
- oracle gg 简单使用
- 正则表达式30分钟入门教程
- Spring Web Flow 2.0 入门详解
- C#的WinForm多线程应用(转)
- How to Interpret the OS stats section of an AWR report (文档 ID 762526.1)
- ThreadLocal详解
- 好文章——Web应用的组件化开发(二)
- c# winform多线程的小例子
- apple id几种账号的区别,企业账号,个人账号
- 闭包 说明和实例
- C#多线程学习(一) 多线程的相关概念
- 一个感觉很不错的程序
- 点击JButton 跳出一个文件选择框 获得文件的属性