We are doing Interest processing on a SET of 10,000 Bank A/cs using a
Single Database connect process.
SQL Query :-
select field names,rowid into :b0,:b1,...
from TBA_ENTITY_INTEREST_TBL
where (entity_id=:b105 and entity_type=:b106)
for update of same (above) field names
nowait;
Above SQL
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
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