Database Software

Hi All,

I am working on a 3 node RAC cluster ( Oracle 10.2.0.3) which is hosted on LINUX OS. I am facing couple of wait events.

Can anyone highlight some experienced approach to resolve this.

Additional info

1- SGA - 2 GB for each instance+ ASMM feature used.

2- No of users- 500

3- Database size: 50 GB

4- Application: Siebel

I have generated few AWR, following are the top 5 wait events received-

Instance 1

CPU time 16,490 19.4
db file sequential read 1,887,338 16,014 8 18.9 User I/O
gc buffer busy 3,371,214 13,091 4 15.4 Cluster
cr request retry 14,962 13,068 873 15.4 Other
db file scattered read 1,159,370 11,664 10 13.8 User I/O

gc buffer busy 4,538,932 22,866 5 22.5 Cluster
db file sequential read 2,688,068 21,634 8 21.3 User I/O
CPU time 16,683 16.5
read by other session 1,885,038 11,777 6 11.6 User I/O
db file scattered read 1,431,366 10,497 7 10.4 User I/O

db file scattered read 3,337,773 29,839 9 24.2 User I/O
db file sequential read 4,001,053 23,927 6 19.4 User I/O
CPU time 21,665 17.5
gc buffer busy 4,070,342 13,219 3 10.7 Cluster
cr request retry 8,559 7,437 869 6.0 Other

Thanks and Regards