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.