OLAP option - Did You Know?This is a featured page

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 FLASHBACK QUERY (re-run) a Multidimensional Datatype (aka Analytic Workspace) query.

  • You can FLASHBACK TABLE (restore) an incarnation of a dropped 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.


olapdba
olapdba
Latest page update: made by olapdba , Jul 23 2009, 1:20 PM EDT (about this update About This Update olapdba Edited by olapdba

10 words added
4 words deleted

view changes

- complete history)
Keyword tags: None
More Info: links to this page
There are no threads for this page.  Be the first to start a new thread.