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
sys.registry$history