query latest patch level (PSU and OJVM). How to do that?
Hi.
Is there any way to extract current patchlevel from sqlplus ?
I'm interested to know the latest/newest PSU and OJVM patchset (marked in red).
For example:
set linesize 150
set pagesize 100
col ACTION_TIME format a25
col VERSION format a20
col ID format 9,999,999
col COMMENTS format a30
col BUNDLE_SERIES format a15
col NAMESPACE format a15
col ACTION format a20
select to_char(ACTION_TIME, 'DD-Mon-YYYY HH24:MI:SS') AS "ACTION_TIME", ACTION, VERSION, COMMENTS, BUNDLE_SERIES from registry$history;
ACTION_TIME | ACTION | VERSION | COMMENTS | BUNDLE_SERIES |
------------------------- -------------------- -------------------- ------------------------------ ---------------
01-Oct-2013 22:55:45 | APPLY | 11.2.0.4 | Patchset 11.2.0.2.0 | PSU |
13-Nov-2014 15:56:24 | APPLY | 11.2.0.4 | Patchset 11.2.0.2.0 | PSU |