- 最后登录
- 2014-9-18
- 在线时间
- 20 小时
- 威望
- 4
- 金钱
- 129
- 注册时间
- 2012-3-12
- 阅读权限
- 10
- 帖子
- 14
- 精华
- 0
- 积分
- 4
- UID
- 290
|
1#
发表于 2012-6-11 17:12:43
|
查看: 20969 |
回复: 3
下面是我测试库的awr报告:DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC | xxxx | 3032207194 | xxxx | 1 | 01-Nov-11 09:11 | 11.2.0.1.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) | oraclevm02 | AIX-Based Systems (64-bit) | 16 | 8 | | 4.00 | Cache Sizes | Begin | End | | | Buffer Cache: | 352M | 352M | Std Block Size: | 8K | Shared Pool Size: | 624M | 624M | Log Buffer: | 6,684K | Instance Efficiency Percentages (Target 100%)Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 | Buffer Hit %: | 99.57 | In-memory Sort %: | 100.00 | Library Hit %: | 99.97 | Soft Parse %: | 99.72 | Execute to Parse %: | 36.64 | Latch Hit %: | 100.00 | Parse CPU to Parse Elapsd %: | 6.04 | % Non-Parse CPU: | 99.55 |
Foreground Wait Events DB/Inst: BDLMS/bdlms Snaps: 1417-1425
-> s - second, ms - millisecond - 1000th of a second
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by wait time desc, waits desc (idle events last)
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Avg
%Time Total Wait wait Waits % DB
Event Waits -outs Time (s) (ms) /txn time
-------------------------- ------------ ----- ---------- ------- -------- ------
OJVM: Generic 270 30 80 296 0.1 11.0
log file sync 917 0 1 1 0.3 .1
Disk file operations I/O 1,425 0 0 0 0.4 .0
db file sequential read 26 0 0 4 0.0 .0
library cache: mutex X 1 0 0 68 0.0 .0
buffer busy waits 4 0 0 13 0.0 .0
enq: JS - queue lock 1 0 0 7 0.0 .0
read by other session 1 0 0 5 0.0 .0
SQL*Net message to client 1,370 0 0 0 0.4 .0
asynch descriptor resize 2,024 100 0 0 0.6 .0
control file sequential re 320 0 0 0 0.1 .0
jobq slave wait 62,750 100 31,329 499 19.3
SQL*Net message from clien 1,370 0 17 13 0.4
-------------------------------------------------------------
请问maclean 这个OJVM: Generic是什么?文档上没找到。谢谢
[ 本帖最后由 jimmy 于 2012-6-11 17:22 编辑 ] |
|