Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Long running operations, v$session_longops

Re: Long running operations, v$session_longops

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 4 Jan 2007 12:10:44 +0000
Message-ID: <7765c8970701040410ode8ae5at788f3cfe6bbfc3d3@mail.gmail.com>


I like the article but you missed the most important one of all for me. You can, and should, when developing applications that contain operations that will/may take some time record the progress of these operations in V$SESSION_LONGOPS yourself by using DBMS_APPLICATION_INFO.

On 1/4/07, Gints Plivna <gints.plivna_at_gmail.com> wrote:

>

> At the end of the last year there were a few questions about long
> running operations. I was inspired by these questions to write an
> article describing longops.
> It can be found in http://www.gplivna.eu/papers/v$session_longops.htm
-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 04 2007 - 06:10:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US