How to Find if Oracle is Configured for OLTP or OLAP

oracle

Is there any specific query or configuration to check Oracle is configured for OLTP or OLAP?I have gone through many sites.But I can find the difference between OLTP and OLAP and not query or configuration to check that difference?

Best Answer

OLTP does not require any specific configuration.

Checking the availability of OLAP libraries:

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

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

Checking the availability of OLAP components in the database:

SQL> 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> 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
Related Question