首页 > 代码库 > AWR报告简易分析
AWR报告简易分析
Snap Id | Snap Time | Sessions | Cursors/Session | |
Begin Snap: | 35669 | 2012-11-8 13:00 | 1246 | 11.3 |
End Snap: | 35679 | 2012-11-8 18:00 | 834 | 16 |
Elapsed: | 300.14 | |||
DB Time: | 2,841.67 | |||
Operating System Statistics | Time Model Statistics | |||
Statistic | Total | Statistic Name | Time (s) | % of DB Time |
NUM_LCPUS | 0 | sql execute elapsed time | 87,551.84 | 99.97 |
NUM_VCPUS | 0 | DB CPU | 248.77 | 0.28 |
AVG_BUSY_TIME | 126,487 | parse time elapsed | 2.76 | 0 |
AVG_IDLE_TIME | 1,675,188 | hard parse elapsed time | 1.47 | 0 |
AVG_IOWAIT_TIME | 2,687 | failed parse elapsed time | 0.45 | 0 |
AVG_SYS_TIME | 11,000 | PL/SQL execution elapsed time | 0.84 | 0 |
AVG_USER_TIME | 114,879 | hard parse (sharing criteria) elapsed time | 0.32 | 0 |
BUSY_TIME | 48,496 | hard parse (bind mismatch) elapsed time | 14.16 | 0.01 |
IDLE_TIME | 8,623,372 | sequence load elapsed time | 9.8 | 0.01 |
IOWAIT_TIME | 7,728 | repeated bind elapsed time | 0.01 | 0 |
SYS_TIME | 5,691 | PL/SQL compilation elapsed time | 2.03 | 0 |
USER_TIME | 42,512 | connection management call elapsed time | 1.7 | 0 |
LOAD | 0 | inbound PL/SQL rpc elapsed time | 0.02 | 0 |
OS_CPU_WAIT_TIME | 7,404,200 | DB time | 87577.44 | |
RSRC_MGR_CPU_WAIT_TIME | 0 | background elapsed time | 1585.54 | |
PHYSICAL_MEMORY_BYTES | 135,319,207,936 | background cpu time | 206.8 | |
NUM_CPUS | 48 | |||
NUM_CPU_CORES | 24 | |||
每个CPU耗时:= | DB Time/逻辑cpu个数 | 59.20 | min | |
DB利用率:= | DB Time/(NUM_CPUS*Elapsed)*100% | 19.72% | NUM_CPUS是逻辑cpu个数 | |
CPU利用率:= | (DB CPU + background cpu time )/(NUM_CPUS*Elapsed )*100% | 0.08% | NUM_CPUS是实际cpu个数 | |
%User = | USER_TIME/(BUSY_TIME+IDLE_TIME)*100% | 0.49% | ||
%Sys = | SYS_TIME/(BUSY_TIME+IDLE_TIME)*100% | 0.07% | ||
%Idle = | IDLE_TIME/(BUSY_TIME+IDLE_TIME)*100% | 99.44% | ||
ELAPSED_TIME= | (BUSY_TIME+IDLE_TIME)/1000 | Elapsed*60*60 | ||
8671.868 | 1080504.00 | |||
Service Statistics | ||||
ordered by DB Time | ||||
Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
SYS$USERS | 87,476.00 | 146.00 | 3,262 | 51,625 |
oradb11 | 101.00 | 102.00 | 0 | 545 |
SYS$BACKGROUND | 0 | 0 | 1 | 26 |
Total DB Time | 87577.0 | |||
Total DB Cpu | 248.0 | |||
% DB Time | 0.28% |
AWR报告简易分析
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。