Oracle Database Discussions

We have a 3 Node RAC cluster and the applications using Load Balancer... When the App query is touching Node-2 query execution is taking more time than Node-1. Checked all the db parameters and they are same.. Not sure if we are missing anything
We are suspecting if the physical memory is being utilized at fulled..

Can some one guide me on how to fix the issue

Thanks
Bharath


**Node-1**


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.04 0.17 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 1.44 1.41 0 2174 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 1.49 1.59 0 2174 0 8

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 416

Rows Row Source Operation
------- ---------------------------------------------------
8 HASH UNIQUE (cr=6348 pr=33 pw=0 time=1802362 us)
8 HASH JOIN (cr=2174 pr=0 pw=0 time=1410367 us)
67909 NESTED LOOPS OUTER (cr=2151 pr=0 pw=0 time=1759624 us)
67909 HASH JOIN (cr=2151 pr=0 pw=0 time=333512 us)
80 TABLE ACCESS FULL ORGANIZATION (cr=248 pr=0 pw=0 time=152385 us)
77942 MERGE JOIN CARTESIAN (cr=1903 pr=0 pw=0 time=668790 us)
1 TABLE ACCESS FULL ORGANIZATION_TYPE (cr=16 pr=0 pw=0 time=276 us)
77942 BUFFER SORT (cr=1887 pr=0 pw=0 time=354729 us)
77942 TABLE ACCESS FULL PROMO_GRAPHIC_REQUEST (cr=1887 pr=0 pw=0 time=233878 us)
0 TABLE ACCESS BY INDEX ROWID PROMO_VIDEO_REQ_MEDIA (cr=0 pr=0 pw=0 time=940149 us)
0 INDEX UNIQUE SCAN PROMO_VIDEO_REQ_MEDIA_PK (cr=0 pr=0 pw=0 time=375506 us)(object id 111682)
1245 TABLE ACCESS FULL STATUS (cr=23 pr=0 pw=0 time=5053 us)


Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 39 0.05 0.13
library cache pin 1 0.00 0.00
row cache lock 1 0.00 0.00
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 18.37 18.37

Node-2


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 5.03 5.00 0 5657 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 5.03 5.00 0 5657 0 8

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 416

Rows Row Source Operation
------- ---------------------------------------------------
8 HASH UNIQUE (cr=5657 pr=0 pw=0 time=5003458 us)
8 HASH JOIN (cr=2174 pr=0 pw=0 time=4934492 us)
67909 NESTED LOOPS OUTER (cr=2151 pr=0 pw=0 time=4437301 us)
67909 HASH JOIN (cr=2151 pr=0 pw=0 time=2739532 us)
80 TABLE ACCESS FULL ORGANIZATION (cr=248 pr=0 pw=0 time=8151 us)
77942 MERGE JOIN CARTESIAN (cr=1903 pr=0 pw=0 time=1637061 us)
1 TABLE ACCESS FULL ORGANIZATION_TYPE (cr=16 pr=0 pw=0 time=295 us)
77942 BUFFER SORT (cr=1887 pr=0 pw=0 time=913041 us)
77942 TABLE ACCESS FULL PROMO_GRAPHIC_REQUEST (cr=1887 pr=0 pw=0 time=233907 us)
0 TABLE ACCESS BY INDEX ROWID PROMO_VIDEO_REQ_MEDIA (cr=0 pr=0 pw=0 time=1104336 us)
0 INDEX UNIQUE SCAN PROMO_VIDEO_REQ_MEDIA_PK (cr=0 pr=0 pw=0 time=435877 us)(object id 111682)
1245 TABLE ACCESS FULL STATUS (cr=23 pr=0 pw=0 time=3811 us)


Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 2 0.00 0.00
gc current block 2-way 8 0.00 0.00
SQL*Net message from client 2 4.99 4.99