I have a db procedure, which runs at the background ones in every 12 hours. This db procedures has various update and insert statements (about 16 dml stm).
Is it possible to see from any of the data_dictionary tables, which portion of the procedure is under execution.
The only way I know is putting dbms_output.put line statement at every statement. Hope there is a better way of knowing it.
or enable trace for the session
you can also view v_$session and v_$sqltext
you can use utl_file to write te data you want to dbms_output.put_line, and you simply copy your output file to a different dir when you whant to read it
You can use DBMS_APPLICATION_INFO package also