Not sure if that is what you want... and not sure if this will really work, just a quick thought...
Invalidate the procedure, so next time it will be used, it will be recompiled, and then you can see at LAST_DDL_TIME in ALL_OBJECTS to find out when it was used first after invalidating. Regards Naveen > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Friday, January 23, 2004 1:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to find the last execution time of a Procedure. > > > > Thanks Raj. I have confidence on you and hope we will meet in > next CTOUG > meeting. > > Best Regards, > Prasad > 860 843 8377 > > > > > > "Jamadagni, > > > Rajendra" To: > Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > <Rajendra.Jamadagn cc: > > > [EMAIL PROTECTED]> Subject: RE: > How to find the last execution time of a Procedure. > > Sent by: > > > [EMAIL PROTECTED] > > > com > > > > > > > > > 01/22/2004 01:59 > > > PM > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > But you better check with experts as my knowledge of x$ is > feather-weight > .. also there is a column on x$kglob called kglhdexc ... to > me it seems > the execution count (I feel like "Mr. Monk" already). so if execution > count is > 0 then you can say that it actually got executed. > > But if this doesn't work, in the next CTOUG meeting, I'll try > to hide away > from you. > > YMMV > Raj > -------------------------------------------------------------- > ------------------ > > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > -----Original Message----- > [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 1:24 PM > To: Multiple recipients of list ORACLE-L > > > > Thanks for input Raj. > > I was also thinking on the same lines (Querying v$views > periodically and > store it in some metadata table) if there is no easier way to > figure out > from DBA_ views. > > As far as changing the production code, as you know, It has > to go thru the > dev/test databases first and then go thru the release process > to implement > into the production. It is painful process. > > I will use x$kglob instead of changing production code and > all that release > stuff. Thanks for your help, Raj. > > Best Regards, > Prasad > 860 843 8377 > > ************************************************************** > ************************ > > This e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is > privileged, attorney > work product or exempt from disclosure under applicable law. > If you have > received this message in error, or are not the named > recipient(s), please > immediately notify corporate MIS at (860) 766-2000 and delete > this e-mail > message from your computer, Thank you. > ************************************************************** > ************************4 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jamadagni, Rajendra > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > > > > > > > ************************************************************** > *********** > PRIVILEGED AND CONFIDENTIAL: This communication, including > attachments, is for the exclusive use of addressee and may > contain proprietary, confidential and/or privileged > information. If you are not the intended recipient, any use, > copying, disclosure, dissemination or distribution is > strictly prohibited. If you are not the intended recipient, > please notify the sender immediately by return e-mail, delete > this communication and destroy all copies. > ************************************************************** > *********** > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).