Топ-100
 
CerebroSQL

Oracle registry information

Information about loaded components into the Oracle database, installed patches

Component registry info

Version and status information of loaded database components

registry component.jpg

-> Request to retrieve data <-

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.jpg

-> Request to retrieve data <-

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

-----