Performance Tuning Tricks Oracle Olap Cubes

Check if the available memory parameters for the DB SGA target are set high enough – this should be set at 35% of all RAM available to the db. OLAP_PAGE_POOL_SIZE should be set to 0 so that auto dynamic page pool is on and is managed by the database (will be set to 50% of PGA…

Oracle OLAP Dimensions And Cubes

Oracle 8i Enterprise Edition came with a database feature known as dimensions, which were an additional layer of metadata you could put over a table or set of tables, to define hierarchical relationships between columns. For example, you could say that one column, ‘COUNTRY’, was the parent of another column ‘REGION’, which itself was the parent…

Oracle OLAP Resources

Resources Oracle OLAP page on Oracle.com Oracle OLAP website on Oracle Technology Network Recommended Oracle OLAP Releases Wiki site maintained by Oracle OLAP Development Team Rittman Meade blog Oracle OLAP blog Oracle OLAP discussion forum Information about Oracle OLAP technology on ORAFAQ website Simba Technologies MDX provider for Oracle OLAP Accelerating Datawarehouses by using Oracle…

OLAP vs. OLTP

The data in a transactional database (OLTP) is normalized for update efficiency. Transactional queries join several normalized tables and are slow (as opposed to pre-joined, de-normalized analytical tables). Transactional databases are tuned for one specific application, and it is not productive to use them for analytical queries. The analytical database (OLAP) can be specifically tuned…