DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2000
    Mt. Laurel, NJ USA
    Need to find a way to monitor a triggers execution time. I'm assuming that the "base" SQL / transaction encompasses the triggers execution time as well. Need to pull that out. Also, if there is a way to identify the SQL for the trigger (V$SQLAREA?), that would also be beneficial.

  2. #2
    The trigger is a block of SQL, which SHOULD turn up in any trace file for using TKPROF.

    that should show you the time, I believe.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.