Use Oracle OLAP with Autonomous AI Database

Oracle OLAP is available on Autonomous AI Database. Oracle OLAP supports uses such as planning, forecasting, budgeting, and analysis.

Enable Oracle OLAP on Autonomous AI Database

Describes the steps to use Oracle OLAP on Autonomous AI Database.

  1. Run DBMS_CLOUD_ADMIN.ENABLE_FEATURE to enable Oracle OLAP.

    EXEC DBMS_CLOUD_ADMIN.ENABLE_FEATURE('OLAP');

    Running this command also enables Java, if it is not already enabled.

    See ENABLE_FEATURE Procedure for more information.

  2. Restart the Autonomous AI Database instance.

    See Restart Autonomous AI Database for more information.

  3. After the restart operation completes, wait for about 20 minutes to allow the Oracle OLAP installation jobs to complete.

  4. Verify that Oracle OLAP is installed.

    For example:

    SELECT comp_name, version, status FROM dba_registry
             WHERE comp_id IN ('APS','XOQ','JAVAVM');
    COMP_NAME                    VERSION    STATUS

---------------------------- ---------- ------
JServer JAVA Virtual Machine 19.0.0.0.0 VALID
OLAP Analytic Workspace      19.0.0.0.0 VALID
Oracle OLAP API              19.0.0.0.0 VALID

  5. Verify that Oracle OLAP is working.

    set serveroutput on
EXEC dbms_aw.execute('show eversion');

    This should show results like:

    Oracle OLAP Release 19.23.0.1.0

For more information, see the following: