You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them.Which two tasks would you perform to test the new statistics? (Choose two.)
You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database.You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.Which two methods would you use to achieve this? (Choose two.)
You recently joined a new team administering a database.You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
Examine the Time Model Statistics section of an AWR report:Which two inferences can be definitely derived from this section? (Choose two.)
Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)
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.)
