Re: Top SQLs from Statspack Vs SQLs from v$session_lonops
From: <shweta.kaparwan_at_googlemail.com>
Date: Fri, 6 Mar 2009 03:20:11 -0800 (PST)
Message-ID: <dcae5723-83b2-428e-beae-475af18a707e_at_v15g2000yqn.googlegroups.com>
On Mar 6, 8:41 am, Gints Plivna <gints.pli..._at_gmail.com> wrote:
> v$session_longops captures long operations for some specific operation
> types (full table scans, hash joins etc) if they exceed certain
> thresholds. BUT it doesn't capture for example nested loops even if
> they run for hours, or there might be many long operations in a single
> SQL statement execution. You can read more about them here:http://www.gplivna.eu/papers/v$session_longops.htm
>
> Gints Plivnahttp://www.gplivna.eu
Date: Fri, 6 Mar 2009 03:20:11 -0800 (PST)
Message-ID: <dcae5723-83b2-428e-beae-475af18a707e_at_v15g2000yqn.googlegroups.com>
On Mar 6, 8:41 am, Gints Plivna <gints.pli..._at_gmail.com> wrote:
> v$session_longops captures long operations for some specific operation
> types (full table scans, hash joins etc) if they exceed certain
> thresholds. BUT it doesn't capture for example nested loops even if
> they run for hours, or there might be many long operations in a single
> SQL statement execution. You can read more about them here:http://www.gplivna.eu/papers/v$session_longops.htm
>
> Gints Plivnahttp://www.gplivna.eu
Nice article.
many thanks
Shweta Received on Fri Mar 06 2009 - 05:20:11 CST