Search notes:

Oracle: DBA_REGISTRY_SQLPATCH - CDB_REGISTRY_SQLPATCH

Information about SQL patches that have been installed in the database.
Each record corresponds to an installation attempt of a given patch, either apply or roll back (column action).
DBA_REGISTRY_SQLPATCH is updated by the datapatch utility.
select
   sqp.action_time,
   sqp.install_id,
   sqp.action,
   sqp.status,
   sqp.description,
   sqp.flags,
   sqp.logfile,
   sqp.patch_descriptor,
   sqp.patch_directory,
   sqp.patch_id,
   sqp.patch_type,
   sqp.patch_uid,
   sqp.ru_logfile,
   sqp.source_build_description,
   sqp.source_build_timestamp,
   sqp.source_version,
   sqp.target_build_description,
   sqp.target_build_timestamp,
   sqp.target_version
from
   sys.dba_registry_sqlpatch sqp
order by
   sqp.action_time desc
;

See also

dba_registry
dbms_qopatch
sys.registry$history
data dictionary

Index