Топ-100
 
CerebroSQL

Oracle registry information

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

Component registry info

Version and status information of loaded database components

registry component.jpg

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

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

  from dba_registry_history h