Ceci est une ancienne révision du document !

• components

SET lines 500
col comp_name FOR a40
col versionfor 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;