Setting Up and Running Summary Advisor on an Exalytics Machine (Oracle-by-Example)
- by Saresh
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.