Oracle registry information

Information about loaded components in the database Oracle, their version and status, as well as installed patches

Component registry info

Version and status information of loaded database components

select dr.COMP_NAME, dr.VERSION, dr.STATUS, dr.SCHEMA, dr.PROCEDURE

from USER_REGISTRY dr

select dr.COMP_NAME, dr.VERSION, dr.STATUS, dr.SCHEMA, dr.PROCEDURE

from DBA_REGISTRY dr

Information about updates, downgrades, and critical fixes that have been installed in the database.

select h.ACTION_TIME, h.ACTION, h.NAMESPACE, h.VERSION, h.COMMENTS

from dba_registry_history h