List of installed Database Patches

Looking for installed patches on the database I have always used
opatch lsinventory
(since 9.2 and up)
From CPUJan2006 onwards you can just query
select * from registry$history;
See Metalink Note:352783.1 for more information.


Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

List RMAN backups size

AWR Generating & Setting