Hi,
I would like to find out the last compiled time of an object. I am aware of CREATED, LAST_DDL_TIME and TIMESTAMP from USER_OBJECTS.
My point is that I would lkie to know when a compiled object was last compiled. For example:
OBJECT_NAME CREATED LAST_DDL_TIME Created - DDL change/min
------------------------------ ----------------- -------------------- ------------------------------
LOG_SHUTDOWN 13/12/11 14:45:17 13/12/11 14:45:17 0
LOG_STARTUP 13/12/11 14:36:40 13/12/11 14:44:02 7
When I do DDL changes it shows in LAST_DDL_TIME. However, if I just recompile log_shutdown trigger above (it is already valid)
ALTER TRIGGER log_shutdown compile;
Trigger altered.
LAST_DDL_TIME shows the same with no change:
OBJECT_NAME CREATED LAST_DDL_TIME Created - DDL change/min
------------------------------ ----------------- -------------------- ------------------------------
LOG_SHUTDOWN 13/12/11 14:45:17 13/12/11 14:45:17 0
Well no DDL changes. I guess my question is where can I get the time of compiling a plan whether the plan is currently being executed or not.
Thanks,
Mich
Edited by: Mich Talebzadeh on 14-Dec-2011 07:48