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.