Oracle
1Z0-062 · Question #243
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, thedatabase is running with peak workload. You want to analyze some of the mo
The correct answer is C. SQL Access Advisor. https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm #TDPDW00813
Managing Performance
Question
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, thedatabase 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?
Options
- AAutomatic Database Diagnostic Monitor (ADDM)
- BSQL Tuning Advisor
- CSQL Access Advisor
- DSQL Performance Analyzer
- EAutomatic Workload Repository (AWR) report
How the community answered
(39 responses)- B8% (3)
- C85% (33)
- D3% (1)
- E5% (2)
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm #TDPDW00813
Topics
#SQL Access Advisor#performance tuning#indexes#materialized views
Community Discussion
No community discussion yet for this question.