For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace.You want to control the usage of the UNDO tablespace only for these user sessions.How would you avoid the issue from repeating in future? (Choose the best answer.)
Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics for objects accessed by the query and test query performance with the new statistics without affecting other sessions connected to the instance.The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.Which two actions would you take to accomplish the task? (Choose two.)
Examine the structure of the EMPLOYEES table.EMPLOYEE_ID is the primary key. No other indexes exist on this table.View the Exhibit to examine the commands and their output.Which two actions should you perform to make the cursor bind aware? (Choose two.)
Examine the output of the query executed to diagnose the reason for performance degradation of queries:Which three factors will you investigate further to identify the cause of the performance degradation? (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.)
