Procedure execution - Possible to monitor?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Procedure execution - Possible to monitor?

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    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


  2. #2
    Join Date
    Feb 2001
    Posts
    389
    query v$sqlarea
    or enable trace for the session

  3. #3
    Join Date
    Feb 2001
    Posts
    41
    you can also view v_$session and v_$sqltext
    Best Regards,
    Harsh Shah

  4. #4
    Join Date
    Jul 2000
    Posts
    243
    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

  5. #5
    Join Date
    Sep 2000
    Posts
    77
    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
  •  


Click Here to Expand Forum to Full Width