
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

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.

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