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