will select for update in RAC causes the GC busy wait events
Hi
select x,y from tab where key_col = :val for update wait 1
we had load test conducted on our application and the following is the results of that load test
My DBA complaining the above select for update query is the culprit for
i am using oracle 10g(10.2.0.5.0) in RAC
in one of my procdeure I have select for update sayselect x,y from tab where key_col = :val for update wait 1
we had load test conducted on our application and the following is the results of that load test
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 3,320 64.5
log file
sync
1,097,086
1,460 1 28.4
Commit
gc current block busy 15,856 1,049 66 20.4 Cluster
log file parallel write 996,497 718 1 13.9 System I/O
gc cr block 2-way 1,290,935 342 0 6.6 Cluster
-------------------------------------------------------------My DBA complaining the above select for update query is the culprit for
1