-
Hi,
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.
Badrinath
-
query v$sqlarea
or enable trace for the session
-
you can also view v_$session and v_$sqltext
Best Regards,
Harsh Shah
-
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
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|