Setting Up and Running Summary Advisor on an Exalytics Machine (Oracle-by-Example)

Posted by Saresh on Oracle Blogs See other posts from Oracle Blogs or by Saresh
Published on Sun, 10 Nov 2013 04:04:42 +0000 Indexed on 2013/11/11 16:06 UTC
Read the original article Hit count: 336

Filed under:

If you are running Oracle BI on an Exalytics machine, you can use Summary Advisor to identify the aggregates that will increase query performance. Summary Advisor intelligently recommends an optimal list of aggregate tables based on query patterns that will achieve maximum query performance gain while meeting specific resource constraints. Summary Advisor then generates an aggregate creation script that can be run to create the recommended aggregate tables. Aggregate tables reduce query times by storing precomputed results for queries that include rolled-up data. This tutorial covers steps to set up, configure, and run Summary Advisor on an Exalytics machine using TimesTen database as a target for storing aggregates.

You can find the Oracle By Example (OBE) in the Oracle Learning Library (OLL). The content in OLL is available to all customers, partners, and employees.

© Oracle Blogs or respective owner

Related posts about /Oracle