RE: SQL_Trace versus Statspack

2003-11-19 Thread Reardon, Bruce (CALBBAY)
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

RE: SQL_Trace versus Statspack

2003-11-19 Thread Jamadagni, Rajendra
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