DBA_SERVER_REGISTRY

Oracle 11gR1

DBA_SERVER_REGISTRY displays information about the components loaded into the database.

Column	Datatype	NULL	Description
COMP_ID	VARCHAR2(30)	NOT NULL	Component identifier
COMP_NAME	VARCHAR2(255)		Component name
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
CONTROL	VARCHAR2(30)	NOT NULL	User that created the component entry
SCHEMA	VARCHAR2(30)	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

Note:

1.

select COMP_ID, COMP_NAME, STATUS, MODIFIED, CONTROL, SCHEMA, PROCEDURE

from DBA_SERVER_REGISTRY;

COMP_ID	COMP_NAME	STATUS	MODIFIED	CONTROL	SCHEMA	PROCEDURE
XOQ	Oracle OLAP API	VALID	11-FEB-2007 07:39:14	SYS	SYS	XOQ_VALIDATE
APS	OLAP Analytic Workspace	VALID	11-FEB-2007 07:39:13	SYS	SYS	APS_VALIDATE
CATJAVA	Oracle Database Java Packages	VALID	11-FEB-2007 07:39:11	SYS	SYS	DBMS_REGISTRY_SYS.VALIDATE_CATJAVA
XML	Oracle XDK	VALID	11-FEB-2007 07:39:11	SYS	SYS	XMLVALIDATE
JAVAVM	JServer JAVA Virtual Machine	VALID	11-FEB-2007 07:39:10	SYS	SYS	INITJVMAUX.VALIDATE_JAVAVM
CATPROC	Oracle Database Packages and Types	VALID	11-FEB-2007 07:39:10	SYS	SYS	DBMS_REGISTRY_SYS.VALIDATE_CATPROC
CATALOG	Oracle Database Catalog Views	VALID	11-FEB-2007 07:39:09	SYS	SYS	DBMS_REGISTRY_SYS.VALIDATE_CATALOG
ORDIM	Oracle interMedia	VALID	11-FEB-2007 07:39:11	SYS	ORDSYS	VALIDATE_ORDIM
SDO	Spatial	VALID	11-FEB-2007 07:39:11	SYS	MDSYS	VALIDATE_SDO
CONTEXT	Oracle Text	VALID	11-FEB-2007 07:39:11	SYS	CTXSYS	VALIDATE_CONTEXT
XDB	Oracle XML Database	VALID	11-FEB-2007 07:39:12	SYS	XDB	DBMS_REGXDB.VALIDATEXDB
OWM	Oracle Workspace Manager	VALID	11-FEB-2007 07:39:10	SYS	WMSYS	VALIDATE_OWM
WK	Oracle Ultra Search	VALID	11-FEB-2007 07:39:13	SYS	WKSYS	VALIDATE_WK

Oracle data dictionary views

Oracle dynamic performance views