Because Oracle OLAP runs in the Oracle Database kernel, it inherits all the benefits of the Oracle Database. Many things that are normally done to improve performance or troubleshoot the Oracle Database will affect Oracle OLAP as well. Here, we will focus on how to configure, tune, back up, and troubleshoot Oracle OLAP analytic workspaces.
Configuring and Tuning Oracle OLAP
Oracle OLAP's multidimensional objects use the same database memory, processes, and storage as any other type of object in the database. As a result, Oracle OLAP benefits from the proper tuning and configuration of the Oracle Database itself. For the most part, if the Oracle Database is running efficiently, Oracle OLAP should be functioning efficiently as well. As with an Oracle database, if the Oracle OLAP design is off, the performance is off, so make sure you validate the design. If the design is bad, no amount of tuning can solve the big problem.