Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to monitor the progress of inserts
Juan,
Don't you think it would be easier to use dbms_application_info and set the number of records in ACTION column? no worries with autonomous transaction, dbms_output etc. Plus you have a chance to have your application well behaved and instrumented. Someone might even thank you for it later. 8:)
Then it it remains is select from v$session ... sounds good?? As for I am concerned, my processes are pretty much verbose, they tell me exactly what I want to know. But we are talking about the question from the original poster.
Raj
On Wed, 2 Feb 2005 09:30:29 -0400, Juan Carlos Reyes Pacheco
<juancarlosreyesp_at_gmail.com> wrote:
> Hi,
> The point rjamya is you don't specified what you want exactly, but
> what I understand
> is someone is doing a SPECIFIC process, and you want to know how much
> inserts that SPECIFIC PROCESS had done before he commit, FROM ANOTHER
> SESSION.
>
> In that case you can call an autonomous transaction instead of the
> dbms_outoup in that session, this is
>
> CREATE OR REPLACE PROCEDURE SAVE_CONTROL_OF_INSERTS
> ( nNumber )
> IS
> PRAGMA AUTONOMOUS_TRANSACTION;
> BEGIN
> UPDATE TABLE TEST SET INSERTS=INSERTS+nNumber ;
> COMMIT;
> END;
> /
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 02 2005 - 10:01:48 CST