Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find the last execution time of a Procedure.
Life is much easier, just use "audit execute on <proc name>"
No need for the x$<tables> :)
Regards,
Waleed
-----Original Message-----
[mailto:Prasada.Gunda_at_hartfordlife.com]
Sent: Thursday, January 22, 2004 11:19 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Is there anyway to find out from data dictionary views when was a database procedure/function last executed. Would like know the solution for 8i and 9i databases. We have some older code in the databases and do not know if any application is using it or not.
I appreciate your help.
Thanks & Best Regards,
Prasad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Prasada.Gunda_at_hartfordlife.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 23 2004 - 19:14:26 CST