Skip to Main Content
Forums

Oracle Database Discussions

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!

When was a stored procedure executed today ?

York35Jan 6 2017 — edited Jan 9 2017

I am using DB version: 11gR2 (11.2.0.4) on RHEL 6.6

I have a stored procedure and I would like to know when, and if possible , who executed this procedure today ?

I know that V$SQL contains only SQL text from the procedures. But, I have other procedures with very similar SQLs being executed. So, I cannot differentiate between them.

So, I would like to know if there a straightforward way of know when a stored procedure was executed today ?

This procedure was not executed by a DBMS_JOB.

Auditing was not enabled for this procedure's execution.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2017
Added on Jan 6 2017
#general-database-discussions
24 comments
9,255 views