Oracle Patch Registry Report
Lists all patches applied to the Oracle database from the SQL patch registry. Useful for verifying patch history, patch status, and database version compliance.
oraclesqlmaintenance-cleanupv1.0.0
0 stars0 downloads17 views0 comments
By OracleDba • Created
Code
(23 lines)1234567891011121314151617181920212223
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/patch_registry.sql
-- Author : Tim Hall
-- Description : Lists all patches applied.
-- Call Syntax : @patch_registry
-- Requirements : Access to the DBA views.
-- Last Modified: 25/01/2024
-- -----------------------------------------------------------------------------------
set linesize 150
column status format a10
column action_time format a30
select install_id,
patch_id,
patch_uid,
patch_type,
action,
status,
target_version,
action_time
from dba_registry_sqlpatch
order by 1;