- 论坛徽章:
- 0
|
最近做性能测试,顺便研究一下AWR report 的使用。
测试时数据库做full backup 时,同时做实体试图更新
看了一下AWR report,想请教高手,那个Avg wait(很多都有这项统计) 代表啥?是不是它的值越小,性能越好?
下面节选了我的report 中的Top5 event:
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
db file scattered read 197,716 2,372 12 77.2 User I/O
log file sequential read 12,562 1,643 131 53.5 System I/O
RMAN backup & recovery I/O 135,909 1,383 10 45.0 System I/O
CPU time 311 10.1
log file parallel write 11,733 276 24 9.0 System I/O
------------------------------------------------------------- |
|