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 |