Top SQLs from Statspack Vs SQLs from v$session_lonops

From: <>
Date: Thu, 5 Mar 2009 15:38:14 -0800 (PST)
Message-ID: <>

Hi All

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? or
Statspack report would suffice.

Kind Regards

Shweta Received on Thu Mar 05 2009 - 17:38:14 CST

Original text of this message