Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance? 

Answer options:

A. SQL Performance Analyzer
B. SQL Access Advisor
C. SQL Tuning Advisor
D. Automatic Workload Repository (AWR) report
E. Automatic Database Diagnostic Monitor (ADDM)

B

Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160 (4th para)