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!

When a procedure/pakage/view used last time

User_4PRTUMar 23 2017 — edited Mar 23 2017

Hi all,

I want to know how to get information about the procedure/view/packages used last time. Is there any query/table where data stored related to view/procedure used last.

It can also understand by- I've a lots of procedure/view in my schema. I've to check what is the execution history of db objects like procedures/views without having audit trail.

Regards,

Nagesh Tiwari

Message was edited by: 1975833

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2017

Added on Mar 23 2017

8 comments

401 views