We are doing Interest processing on a SET of 10,000 Bank A/cs using a
Single Database connect process.
SQL Query :-
select ,rowid into :b0,:b1,...
from TBA_ENTITY_INTEREST_TBL
where (entity_id=:b105 and entity_type=:b106)
for update of
nowait;
Above SQL Query Shows DIFFERING values (taken conc
Vivek,
as others have pointed out before, Statspack is instance wide snapshot. Trace file is
session specific.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly persona
Vivek did mention single DB connect process, so this should increase the possibility
of statspack matching the trace file
Did you have parallel query occurring - as then the single trace wouldn't have caught
everything.
Are you SURE no other users were active at the same time - eg look at logons