Re: Top SQLs from Statspack Vs SQLs from v$session_lonops

From: <>
Date: Fri, 6 Mar 2009 03:20:11 -0800 (PST)
Message-ID: <>

On Mar 6, 8:41 am, Gints Plivna <> 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:$session_longops.htm
> Gints Plivna

Nice article.
many thanks

Shweta Received on Fri Mar 06 2009 - 05:20:11 CST

Original text of this message