At the IT Manager request, you are reviewing the databases that the DBA has implemented. You find STATISTICS_LEVEL configured as BASIC. What finding do you report back to the IT Manager?
Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?
When preparing a new database installation, you want to ensure automatic collection of timed statistics. Which three configuration parameters are applicable?
Which is a capability that Active Session History (ASH) reports enable you to perform?
Multitenant option?
What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?
