RAC waits and Node Affinity
Hi
We have a query that takes about 22 second in a 2 node RAC (10g R2) environment but takes only 3 seconds in a non rac single database 10g R2) environment
TKPROF with event 10046 results are below
2-Node RAC
==========
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.01 0 0 0 0
Fetch 2 10.75 22.88 29139 209096 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 10.75 22.90 29139 209096 0 6
Misses in library cache during parse: 0
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net more data from client 1 0.00 0.00
We have a query that takes about 22 second in a 2 node RAC (10g R2) environment but takes only 3 seconds in a non rac single database 10g R2) environment
TKPROF with event 10046 results are below
2-Node RAC
==========
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.01 0 0 0 0
Fetch 2 10.75 22.88 29139 209096 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 10.75 22.90 29139 209096 0 6
Misses in library cache during parse: 0
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net more data from client 1 0.00 0.00
0