Top SQLs from Statspack Vs SQLs from v$session_lonops
Date: Thu, 5 Mar 2009 15:38:14 -0800 (PST)
I'm trying to understand the difference vs TOP SQL statement from Statspack report vs. SQLs shown by v$session_longops.
I took Statspack report between 12:00 hr to 12:15 hrs. and during the same time i qurried the v$session_longops then is it most likely that all SQLs which are captured from v $session_longops view will also be present in the statspack report?.
at 12:10 hrs users reported that database is dead slow. and i have
Statspack snap getting genrated at every 15 mins .
So in such scenario whether v$session_longops will be helpful?
Statspack report would suffice.
Shweta Received on Thu Mar 05 2009 - 17:38:14 CST