Re: V$SESSION_LONGOPS sofar/totalwork *always* = 1 in 10g ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 30 Nov 2006 17:10:45 -0800
Message-ID: <1164935442.149431@bubbleator.drizzle.com>

Anurag Varma wrote:

> Just because a query is running for several hours does NOT mean it
> would show
> up in v$session_longops.
>
> Anurag

Unless someone specifically uses the DBMS_APPLICATION_INFO package which is what I assumed was the case. Perhaps you are correct that it is not.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Nov 30 2006 - 19:10:45 CST