For example:
SQL> col action for a15
SQL> col ACTION_TIME for a30
SQL> col COMMENTS for a30
SQL> col version for a15
SQL> set lin 100
SQL> select action,action_time,version,comments from registry$history;
ACTION ACTION_TIME VERSION COMMENTS
--------------- ------------------------------ --------------- ------------------------------
UPGRADE 10-DEC-09 10.47.04.162576 AM 11.1.0.7.0 Upgraded from 11.1.0.6.0
APPLY 10-DEC-09 12.50.17.018749 PM 11.1.0.7 CPUJul2009
CPU 10-DEC-09 12.52.37.373144 PM view recompilation
Hi,
ReplyDeleteregistry$history view was avaliable from 10gR1 (10.1.0.5 most probably).Before 10gR1 version still optach lsonventory has to be used for it.
Regards,
Anand