How To Find What PSU (CPU) Installed In Your DB ?

Hi,
I have come across some question from users how to check which PSU is installed the Oracle Database.
 
So, here you go
log to the database  and issue :
 
col action_time for a30
col action for a6
col namespace for a10
col version for a10
col comments for a30
set lines 300
select * from registry$history;

SQL> /

ACTION_TIME  ACTION NAMESPACE  VERSION    COMMENTS       BUNDLE_SERIES
———————- —— ———- ———-       ———- ———————- ——————————

08-DEC-14 1   APPLY  SERVER            11.2.0.2  Patchset  11.2.0.2.0            PSU

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>