DBA_REGISTRY displays information about the components loaded into the database.

SELECT COMP_ID,COMP_NAME,VERSION,STATUS
FROM DBA_REGISTRY
ORDER BY COMP_NAME;

COMP_ID	COMP_NAME	VERSION	STATUS
JAVAVM	JServer JAVA Virtual Machine	11.2.0.1.0	VALID
APS	OLAP Analytic Workspace	11.2.0.1.0	VALID
AMD	OLAP Catalog	11.2.0.1.0	VALID
OWB	OWB	11.2.0.1.0	VALID
APEX	Oracle Application Express	3.2.1.00.10	VALID
OCA	Oracle Application Server Certificate Authority	10.1.2.0.2	VALID
DCM	Oracle Application Server Distributed Configuration Management	10.1.2.0.2	VALID
B2B	Oracle Application Server Integration B2B	10.1.2.0.2	VALID
BAM	Oracle Application Server Integration BAM	10.1.2.0.2	VALID
MRC	Oracle Application Server Metadata Repository Version-R	10.1.2.0.2	VALID
SSO	Oracle Application Server Single Sign-On	10.1.2.0.2	VALID
SYNDICATION	Oracle Application Server Syndication Services	10.1.2.0.2	VALID
UDDI	Oracle Application Server UDDI Registry	10.1.2.0.2	VALID
WCS	Oracle Application Server Web Clipping	10.1.2.0.2	VALID
WIRELESS	Oracle Application Server Wireless	10.1.2.0.2	VALID
DISCOVERER	Oracle Business Intelligence Discoverer	10.1.2.0.2	VALID
ODM	Oracle Data Mining	11.2.0.1.0	VALID
CATALOG	Oracle Database Catalog Views	11.2.0.1.0	VALID
CATJAVA	Oracle Database Java Packages	11.2.0.1.0	VALID
CATPROC	Oracle Database Packages and Types	11.2.0.1.0	VALID
OID	Oracle Internet Directory	10.1.2.0.2	VALID
OLS	Oracle Label Security	10.2.0.4.0	OPTION OFF
ORDIM	Oracle Multimedia	11.2.0.1.0	VALID
XOQ	Oracle OLAP API	11.2.0.1.0	VALID
RAC	Oracle Real Application Clusters	11.2.0.1.0	INVALID
CONTEXT	Oracle Text	11.2.0.1.0	VALID
WORKFLOW	Oracle Workflow	10.1.2.0.2	VALID
XML	Oracle XDK	11.2.0.1.0	VALID
XDB	Oracle XML Database	11.2.0.1.0	VALID
SDO	Spatial	11.2.0.1.0	VALID

ITPub博客

Database Components Information Table - DBA_REGISTRY