top of page

Oracle registry information

CerebroSQL

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

Oracle registry general

Component registry info

Version and status information of loaded database components

​

registry component

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

  from USER_REGISTRY dr

or

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

  from DBA_REGISTRY dr

Patch history

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

​

Oracle patch history

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

  from dba_registry_history h

bottom of page