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

From: Gints Plivna <>
Date: Fri, 6 Mar 2009 00:41:07 -0800 (PST)
Message-ID: <>

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 Received on Fri Mar 06 2009 - 02:41:07 CST

Original text of this message