dba_registry shows all database components that are loaded into the component registry. | CID | ||
| APEX | Oracle Application Express | |
| APS | OLAP Analytic Workspace | |
| CATALOG | Oracle Catalog Views (i. e. the data dictionary) | $ORACLE_HOME/rdbms/admin/catalog.sql |
| CATJAVA | Oracle Java Packages | $ORACLE_HOME/rdbms/admin/catjava_sql |
| CATPROC | Oracle Packages and Types (the data dictionary for PL/SQL) | $ORACLE_HOME/rdbms/addmin/catproc.sql |
| CONTEXT | Oracle Text | |
| DV | Oracle Database Vault | $ORACLE_HOME/rdbms/admin/catmacpre.sql |
| EM | Oracle Enterprise Manager Repository | |
| JAVAVM | JServer JAVA Virtual Machine | |
| OLS | Oracle Label Security | $ORACLE_HOME/rdbms/admin/catols.sql, catolsd.sql |
| ORDIM | Oracle Multimedia | |
| OWM | Oracle Workspace Manager | |
| RAC | Real Application Clusters | $ORACLE_HOME/rdbms/admin/catclust.sql |
| SDO | Oracle Spatial | |
| XDB | Oracle XML Database | ORACLE_HOME/rdbms/admin/catqm_int.sql |
| XML | Oracle XDK for Java | |
| XOQ | Oracle OLAP API | $ORACLE_HOME/rdbms/admin/initxml.sql |
| ODM | Data Mining | |
| MGW | Messaging Gateway | |
| WK | Oracle Ultra Search |
select comp_id, comp_name, schema, procedure, version, status, modified, namespace, other_schemas from dba_registry order by lower(comp_name);