other options
gazza, February 04, 2016 - 10:25 am UTC
Store logging data in a table (autonomous transaction)
or consider DBMS_PIPE?
February 04, 2016 - 11:55 am UTC
I prefer the former, and not so much the latter :-)
Cheers,
Connor
Thanks for the answer
Tauseef, February 04, 2016 - 10:31 am UTC
Thanks for the answer. I was disturbing myself and going through so many links on internet if this is possible. Thanks for the answer.
February 04, 2016 - 11:56 am UTC
Glad we could help
dbms_application_info
Rajeshwaran, Jeyabal, February 04, 2016 - 12:26 pm UTC
Having calls to dbms_application_info.set_client_info (like below), will show in v$session.client_info about how long we processed so far.
open example_cursor(v_start_date,v_end_Date);
LOOP
DBMS_OUTPUT.PUT_LINE('Loop no:'||I);
FETCH example_cursor
BULK COLLECT INTO v_tab_month_rec
LIMIT C_LIMIT;
EXIT WHEN v_tab_month_rec.COUNT = 0;
i = i+ v_tab_month_rec.count;
dbms_application_info.set_client_info('count ='||i);FORALL INDX IN 1 .. V_TAB_MORT_LOANS.COUNT
--DML statement here
END LOOP;
COMMIT;
February 04, 2016 - 5:49 pm UTC
Yes, though if you only want the info at runtime (and no historic record), DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS as suggested in the comment below is better.
DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS
Anton, February 04, 2016 - 12:26 pm UTC
If you only need to check for progress using DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS is the way to go.
February 04, 2016 - 5:49 pm UTC
Yes - assuming you don't want to keep the stats for later analysis.