DBA_SERVER_REGISTRY

5.354 DBA_SERVER_REGISTRY

DBA_SERVER_REGISTRY displays information about all server components in the database that are loaded into the component registry.

Column	Datatype	NULL	Description
`COMP_ID`	`VARCHAR2(30)`	`NOT NULL`	Component identifier
`COMP_NAME`	`VARCHAR2(255)`		Component name
`VERSION`	`VARCHAR2(30)`		Component version loaded
`VERSION_FULL`	`VARCHAR2(30)`		Component full version
`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
`CONTROL`	`VARCHAR2(128)`	`NOT NULL`	User that created the component entry
`SCHEMA`	`VARCHAR2(128)`	`NOT NULL`	User that contains the objects for the component
`PROCEDURE`	`VARCHAR2(61)`		Validation procedure
`STARTUP`	`VARCHAR2(8)`		Indicates whether the component requires a startup after the upgrade (`REQUIRED`) or not
`PARENT_ID`	`VARCHAR2(30)`		Parent component identifier
`OTHER_SCHEMAS`	`VARCHAR2(4000)`		A list of ancillary schema names associated with the component