query slow - not frequently
hi all ,
Below query ..
1)Getting longtime, when we executing to DB
2)Im not see any full table scan in that explain plan.
3)also i noticed , if i have execute first time it will took 2 minutes, same query executed another half hour it took 2 sec.
same query executed next 2 hours. it took same 2mintues (it's equal first time execution).
4) I have suspect it's like "memory size issue ".(buffer cache)
could you please give me ..idea or thoughts ?
query:
SQL> EXPLAIN PLAN FOR SELECT SUM(b.QUANTITY) FROM PINPDC.EVENT_T a, PINPDC.EVENT_BAL_IMPACTS_T b
2 WHERE a.ACCOUNT_OBJ_ID0= '494125' AND a.POID_ID0 = b.OBJ_ID0
Below query ..
1)Getting longtime, when we executing to DB
2)Im not see any full table scan in that explain plan.
3)also i noticed , if i have execute first time it will took 2 minutes, same query executed another half hour it took 2 sec.
same query executed next 2 hours. it took same 2mintues (it's equal first time execution).
4) I have suspect it's like "memory size issue ".(buffer cache)
could you please give me ..idea or thoughts ?
query:
SQL> EXPLAIN PLAN FOR SELECT SUM(b.QUANTITY) FROM PINPDC.EVENT_T a, PINPDC.EVENT_BAL_IMPACTS_T b
2 WHERE a.ACCOUNT_OBJ_ID0= '494125' AND a.POID_ID0 = b.OBJ_ID0
0