How to know if a database is using precompilers?

Jun 9, 2014 1:12PM

Hi experts.

How to know if a database is using precompilers and/or OCI? Version 11.2.0.4

SQL> col comp_id format a9

SQL> col status format a6

SQL> col version format a11

SQL> col comp_name format a35

SQL> select SUBSTR(comp_id,1,12) comp_id, status, SUBSTR(version,1,10) version,SUBSTR(comp_name,1,4

0) comp_name FROM dba_registry ORDER BY 1;

COMP_ID STATUS VERSION COMP_NAME

--------- ------ ----------- -----------------------------------

AMD VALID 11.2.0.4.0 OLAP Catalog

APEX VALID 3.2.1.00.1 Oracle Application Express

APS VALID 11.2.0.4.0 OLAP Analytic Workspace

CATALOG VALID 11.2.0.4.0 Oracle Database Catalog Views

CATJAVA VALID 11.2.0.4.0 Oracle Database Java Packages

CATPROC VALID 11.2.0.4.0 Oracle Database Packages and Types

Precompilers and OCI (MOSC)