Check oracle Patch version +winbudle patches, and dba registery

Check oracle Patch version +winbudle patches, and dba registery


SQL> set pagesize 0
SQL> set long 90000

SQL> Select ACTION_TIME , ACTION ,VERSION , COMMENTS from dba_registry_history order by action_time desc ;

 

SQL> Select ACTION_TIME , ACTION ,status,VERSION,description from dba_registry_sqlpatch order by action_time desc;

 

SQL> select comp_name, version, status from dba_registry