Which are three use cases in which SQL Performance Analyzer can be used?
SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?
Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)?
Oracle databases come with a built-in health monitor to run diagnostic checks on components of the database. Which three capabilities can be used to automate reporting?
For which one would you use an index fast full scan to improve performance?
A customer not familiar with Active Session History (ASH) asked you what it was used for. Which are two statements you can use to accurately describe (ASH) capabilities?