Since we change the PSU and BP patch numbering from Oracle Database 126.96.36.199.PSU6 to 12,1,0,2,160119 it is almost impossible to distinguish from the patch name only if you have applied a PSU or a BP.
In Oracle Database 12c there’s a package available which is very useful to query plenty of information about patches from within the database: DBMS_QOPATCH.
Here are a few helpful examples which I created by checking in our DBaaS Cloud database.
Which patches have been applied (or rolled back)?
SQL> set serverout on SQL> exec dbms_qopatch.get_sqlpatch_status; Patch Id : 20415564 Action : APPLY Action… Continue reading...