Welcome! Wikis are websites that everyone can build together. It's easy!

OLAP option - Did You Know?

Of course all of these things are a possibe since the OLAP options is in the Oracle Database kernel and not a seperate process.

  • You can DBMS_FLASHBACK a Multidimensional Datatype (aka Analytic Workspace) query.

  • You can recover (or undelete) a Multidimensional Datatype from the Recycle Bin.

  • You can use Datapump (IMPDP/EXPDP) to backup and recover Multidimensional Datatypes. You can also do this through OLAP DML and traditional imp/exp.

  • You can use RESUMABLE_TIMEOUT to pause a build if you run out of storage until more is allocated.

  • You can implement a Virtual Private Database (VPD) on a Cube or Dimension View. There is an internal mechanism to do this as well using the PERMIT command inside the Multidimensional Datatype.

  • You can use the Job Scheduler (as part of Analytic Workspace Manager) to submit builds at specific times and concurrency.

  • You can monitor Oracle OLAP option performance via Database/Grid Control using AWR or ADDM just as you would anything else. Of course you can since Oracle OLAP option uses the same memory and resources (SGA/PGA and Tablespace).

  • You can use Real Application Clusters (RAC) with the Oracle OLAP option to scale-out Cube builds and querying users. Again restating the fact that the OLAP option is in the Database kernel and is not a seperate process.


Latest page update: made by olapdba , Apr 22 2008, 10:16 AM EDT (about this update About This Update olapdba Edited by olapdba

22 words added

view changes

- complete history)
Keyword tags: None
More Info: links to this page

There are no threads for this page. 

Anonymous  (Get credit for your thread)


Wiki pages
Top Contributors