How to find Oracle is configured for OLTP or OLAP?
OLTP does not require any specific configuration.

Checking the availability of OLAP libraries:

SQL&gt; select * from v$option where parameter = 'OLAP';

PARAMETER  VALUE
---------- -----
OLAP       TRUE


Checking the availability of OLAP components in the database:

SQL&gt; select comp_name, version, status
     from dba_server_registry where comp_name like '%OLAP%';

COMP_NAME                 VERSION    STATUS
------------------------- ---------- ----------
OLAP Analytic Workspace   11.2.0.4.0 VALID
Oracle OLAP API           11.2.0.4.0 VALID
OLAP Catalog              11.2.0.4.0 VALID


Checking if OLAP is in use (note that, this works with sampled data, the sample interval by default is 1 week, it does not represent the real-time situation):

SQL&gt; select name, detected_usages, currently_used from
     dba_feature_usage_statistics where name like 'OLAP%' order by name;

NAME                           DETECTED_USAGES CURRE
------------------------------ --------------- -----
OLAP - Analytic Workspaces                   0 FALSE
OLAP - Cubes                                 0 FALSE