Thanks John and everyone for their suggestions.
Best Regards,
Prasad
John Kanagaraj
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
We for one don't like ANYTHING invalid in production database ... either it is valid
or it gets dropped.
Raj
-Original Message-
Sent: Friday, January 23, 2004 2:24 AM
To: Multiple recipients of list ORACLE-L
Not sure if that is what you want... and not sure if this will really work,
Thanks for your input, Naveen. But, It is hard to do that since everything
is under Production Support Team control.
Best Regards,
Prasad
Raj,
I am no X$ expert either, but X$KGLOB is exposed to us lowly DBAs as
V$DB_OBJECT_CACHE and KGLHDEXC is actually the EXECUTIONS column.
Prasada, you can check V$DB_OBJECT_CACHE for TYPE in ('PACKAGE','PACKAGE
BODY') and KEPT = 'NO' and keep pinning these using DBMS_POOL.KEEP via a
scheduled
Life is much easier, just use audit execute on proc name
No need for the x$tables :)
Regards,
Waleed
-Original Message-
[mailto:[EMAIL PROTECTED]
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
not easily, but you could probably scan through x$kglob (frequently) and see if the
name exists ... if it is, it means it was loaded for execution.
Another solution might be to modify old code and have them add a row in a separate
table using autonomous transaction to indicate they got
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
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
Thanks Raj. I have confidence on you and hope we will meet in next CTOUG
meeting.
Best Regards,
Prasad
860 843 8377
Jamadagni,
10 matches
Mail list logo