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?
A. SQL Performance Analyzer
B. SQL Access Advisor
C. SQL Tuning Advisor
D. Automatic Workload Repository (AWR) report E. Automatic Database Diagnostic Monitor (ADDM)
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currentl
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currentl
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!