RE: Long running operations, v$session_longops

  • From: "Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>
  • To: <niall.litchfield@xxxxxxxxx>,<gints.plivna@xxxxxxxxx>
  • Date: Thu, 4 Jan 2007 13:36:58 +0100

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@xxxxxxxxx] 
Sent: donderdag 4 januari 2007 13:11
To: gints.plivna@xxxxxxxxx
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@xxxxxxxxx> 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 

Other related posts: