已索引

opatch lsinventory

最可靠的是 $ORACLE_HOME/OPatch/opatch lsinventory

11g

如果打补丁后没有执行 modified sql，则该视图不会更新。

set lines 200;
col ACTION_TIME for a35;
col ACTION for a15;
col NAMESPACE for a20;
col VERSION for a15;
col BUNDLE_SERIES for a10;
select ACTION_TIME,ACTION,NAMESPACE,VERSION,ID,BUNDLE_SERIES 
from dba_registry_history;


ACTION_TIME                         ACTION          NAMESPACE            VERSION                 ID BUNDLE_SER
----------------------------------- --------------- -------------------- --------------- ---------- ----------
12-AUG-15 05.34.43.553665 PM        APPLY           SERVER               11.2.0.4                 0 PSU
12-AUG-15 07.03.11.236039 PM        APPLY           SERVER               11.2.0.4                 7 PSU

12c

col LOGFILE for a60;
col DESCRIPTION for a50;
col BUNDLE_SERIES for a10;
col ACTION_TIME for a40;
set lines 300;
select PATCH_ID,PATCH_UID,VERSION,FLAGS,ACTION,STATUS,INSTALL_ID,ACTION_TIME,DESCRIPTION,BUNDLE_SERIES,BUNDLE_ID 
from dba_registry_sqlpatch;