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…
Examine the partial AWR report taken for a time period of 60 minutes: Which two inferences can you draw from this report? (Choose two.) A. The database user calls are issuing frequent explicit commits. B. The CPUs are busy executing…
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.) A. the V$ACTIVE_SESSION_HISTORY view B. the…
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…
Examine the Time Model Statistics section of an AWR report: Which two inferences can be definitely derived from this section? (Choose two.) A. The available CPU resources were not utilized to their maximum capacity. B. All sequence numbers used during…
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…
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.) A. Set the…
In which three situations can dynamic statistics be used? (Choose three.) A. when the sampling time is a small fraction of the total time for a query B. when an execution plan is suboptimal because of complex predicates C. when…
You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services. You execute the command to enable tracing of the ORCL1 service: Which two statements are true? (Choose two.) A.…
Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.) A. setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open…