Already a member?
Sign in
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
Edited by olapdba
22 words added
view changes
- complete history)
Edited by olapdba
22 words added
view changes
- complete history)
Keyword tags: None
More Info: links to this page