How to identify the applied patche-set of your Oracle Home

Many a times you will need to find the patch level of your database.

The easiest way to get this information is from the OPatch utility.  The OPatch utility can be found under $ORACLE_HOME/OPatch directory.

The command below will list out all the currently applied patches to your Oracle environment using the files in the oraInventory.

Example:

$ORACLE_HOME/OPatch/opatch lsinventory

The same information can be seen from dynamic views

Example:

SQL>select * from sys.v$version ;

SQL>select * from sys.registry$history;