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. Automatic Database Diagnostic Monitor (ADDM)
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository (AWR) report

C

References: https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm#TDPDW00813