求助分析AWR 10.2.0.5.0 + RAC 2节点+ AIX-Based Systems (64-bit)
TOP 5 log file sync 很高， 平均 77 ms ， 求助请给些思路
EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
log file sync3,054,284235,9017738.0Commit
gc buffer busy806,573173,69621528.0Cluster
db file sequential read20,311,467127,413620.6User I/O
gcs log flush sync2,653,58354,253208.8Other
CPU time 26,985 4.4
AWR 附件下载地址 http://pan.baidu.com/s/1jHhjavW
TOP 5 log file sync 很高， 平均 77 ms ， 求助请给些思路
EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
log file sync3,054,284235,9017738.0Commit
gc buffer busy806,573173,69621528.0Cluster
db file sequential read20,311,467127,413620.6User I/O
gcs log flush sync2,653,58354,253208.8Other
CPU time 26,985 4.4
AWR 附件下载地址 http://pan.baidu.com/s/1jHhjavW
