How to Know what all patches are applied ????
Printable View
How to Know what all patches are applied ????
Patches OS or patches Oracle?
Oracle patches Boss
v$version will correctly reflect the patchlevel you are at; boss.
V$VERSION tells us in what version we are.
We had deadlocks occuring often .we sent the udump files to Oracle.they sent us a patch.After applying the patch also we have the same version only.
There are some small patches which don't update the v$version - or list the patched version when running say SQL *Plus.
Try looking in the unix.rgs file (in $ORACLE_HOME/orainst ) if on unix (nt.rgs if NT).
This may display a higher version number here.