DBA_REGISTRY_HIERARCHY

DBA_REGISTRY_HIERARCHY displays information about the components loaded into the database, grouped by owner and organized in the component hierarchy.

Column	Datatype	NULL	Description
COMP_ID	VARCHAR2(4000)		Component identifier
VERSION	VARCHAR2(30)		Component version loaded
STATUS	VARCHAR2(11)		Component status: INVALID VALID LOADING LOADED UPGRADING UPGRADED DOWNGRADING DOWNGRADED REMOVING REMOVED
MODIFIED	VARCHAR2(20)		Time when the component was last modified