Re: Top SQLs from Statspack Vs SQLs from v$session_lonops
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 6 Mar 2009 00:41:07 -0800 (PST)
Message-ID: <42a59fcc-dc27-4026-961d-50d9025610c5_at_d19g2000yqb.googlegroups.com>
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
Date: Fri, 6 Mar 2009 00:41:07 -0800 (PST)
Message-ID: <42a59fcc-dc27-4026-961d-50d9025610c5_at_d19g2000yqb.googlegroups.com>
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 Plivna
http://www.gplivna.eu
Received on Fri Mar 06 2009 - 02:41:07 CST