Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)
Examine the parameters set for your database instance:You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads at different times. You notice in an ADDM report that the shared pool is inadequately sized. You resize the shared pool by decreasing the sizes of other pools, which results in inadequate sizes for other pools. You want to automate the sizing of SGA components.Which two actions should you perform? (Choose two.)
Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)
Examine the parameters set for your database instance:You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in the SQL Plan Management Base.Which action is taken by the optimizer? (Choose the best answer.)
Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expressions are using materialized views.You notice that some queries are performing poorly because they are not benefiting from query rewrites.Which three actions would you take to improve the performance of queries? (Choose three.)
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.Which three objectives can be achieved by the Resource Manager? (Choose three.)
