RE: Long running operations, v$session_longops

I like the article as it is.

For the DBMS_APPLICATION_INFO usage, I am not a developer and rather ignorant on the how-to,

So that I am eager to read the paper with full of example by Niall.  

Bernard Polarski

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: donderdag 4 januari 2007 13:11
To: gints.plivna_at_gmail.com
Cc: oracle-l
Subject: Re: Long running operations, v$session_longops  

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:36:58 CST