Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








New OTN Webcast on Oracle OLAP 10g Release 2
August 15, 2005
Mark Rittman

There's a new webcast available on OTN on the new features in Oracle OLAP 10g Release 2 (the link's in the top right-hand corner, requires RealPlayer). You can also download the presentation as a Windows .exe file or as a set of PDF slides.


Having listened to the webcast and taken a look through the slides, the new features coming with 10g Release 2 are

  • Improvements to cube build time, through the extension of compressed composites to cubes with non-additive and skip-level aggregation
  • Improvements to query performance, through optimizations to the SQL - analytic workspace interface layer (which should make BI Beans and Discoverer for OLAP queries more responsive)
  • Support for transportable tablespaces, so you bundle up your AWs into a tablespace, run a transportable tablespace export then "plug them in" to a new database. Useful for publishing AWs from your ETL database into the "presentation layer" database.
  • Multiple language support within the OLAP API

From what I've managed to pick up from speaking to people, the two key features here are the extension of compressed composites to cover most cube aggregation scenarios, and the improvements that have been made to the interface between the OLAP API and analytic workspaces. If you've used the relational version of Discoverer you'll know it's pretty responsive, and if you've directly queried an AW using the OLAP Worksheet you'll know that it's responsive as well, but the problem that we've had with 9iR2 and 10gR1 OLAP is that the interface between SQL and the AW has seems a bit slow, to the point where tools such as Discoveer for OLAP are visibly less responsive than OFA and OSA. Hopefully what's coming along with 10gR2 will address this, and Discoverer for OLAP running against a 10gR2 database will be as fast as OSA or Express Analyzer.


Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational