Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how tack if a stored procedure is being called

Jack SamApr 10 2013 — edited Apr 11 2013
Is there any way to track if a stored procedure is being called and by whom?
is there any table/view that I can look up?
Or I can create a trigger in case stored procedure is executed, insert rows in a statistics table?
Or I change the stored procedure code to do such insert to collect the trace?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2013
Added on Apr 10 2013
5 comments
632 views