* components
set lines 500
col comp_name for a40
col version for a25
col status for a10
SELECT comp_name, VERSION_FULL, status FROM dba_registry;
COMP_NAME VERSION_FULL STATUS
---------------------------------------- ------------------------------ ----------
Oracle Database Catalog Views 19.21.0.0.0 VALID
Oracle Database Packages and Types 19.21.0.0.0 VALID
Oracle Real Application Clusters 19.21.0.0.0 VALID
JServer JAVA Virtual Machine 19.21.0.0.0 VALID
Oracle XDK 19.21.0.0.0 VALID
Oracle Database Java Packages 19.21.0.0.0 VALID
OLAP Analytic Workspace 19.21.0.0.0 VALID
Oracle XML Database 19.21.0.0.0 VALID
Oracle Workspace Manager 19.21.0.0.0 VALID
Oracle Text 19.21.0.0.0 VALID
Oracle Multimedia 19.21.0.0.0 VALID
COMP_NAME VERSION_FULL STATUS
---------------------------------------- ------------------------------ ----------
Spatial 19.21.0.0.0 VALID
Oracle OLAP API 19.21.0.0.0 VALID
Oracle Label Security 19.21.0.0.0 VALID
Oracle Database Vault 19.21.0.0.0 VALID
15 rows selected.
* Patch applied
set lines 1000
col action_time for a20
col action for a15
col status for a15
SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time, action, status,patch_id ,description
FROM dba_registry_sqlpatch
ORDER by action_time;