Top SQLs from Statspack Vs SQLs from v$session_lonops
From: <shweta.kaparwan_at_googlemail.com>
Date: Thu, 5 Mar 2009 15:38:14 -0800 (PST)
Message-ID: <3675945c-e719-4b7c-bcf8-68c94fd6d99f_at_t7g2000yqa.googlegroups.com>
Hi All
Date: Thu, 5 Mar 2009 15:38:14 -0800 (PST)
Message-ID: <3675945c-e719-4b7c-bcf8-68c94fd6d99f_at_t7g2000yqa.googlegroups.com>
Hi All
I'm trying to understand the difference vs TOP SQL statement from Statspack report vs. SQLs shown by v$session_longops.
Suppose,
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