双节点rac , 系统很慢，上传awr 报告，请各位给分析一下

yobyin

awr 报告.

系统负载很高，
db time /eclipsed time = 750/60=12.5

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
db file sequential read 2,850,396 28,548 10 63.38 User I/O
DB CPU   11,332   25.16   
db file parallel read 7,523 3,104 413 6.89 User I/O
gc cr multi block request 772,516 1,984 3 4.41 Cluster
direct path read temp 945,428 572 1 1.27 User I/O




请各位给瞧瞧

[ 本帖最后由 yobyin 于 2012-6-14 11:45 编辑 ]

不了峰

应该调 一下top sql就好了.
如
        select moentityid, moentitycode from mo_moentity where motypeid=:1
这个SQL一定有问题 .