Examine the Load Profile section of an AWR report: Which two inferences can you derive from the details in this section? (Choose two.) A. The values for Redo size and Block changes imply that only updates were performed by transactions.…
Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.) A. A high value indicates that the buffer cache is adequately sized for the current…
Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.) A. distributing available CPU by allocating percentages of CPU time to different users and applications B. limiting the…
Which two statements are true about server-generated alerts? (Choose two.) A. They are always logged in the alert log. B. They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE. C. They are generated…
Examine the parameters: Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the…
A senior DBA asks you to decrease the values of the connect_time_scale and think_time_scale replay processing parameters to 50 to preprocess the workload for replay. What three could be reasons for this change? (Choose three.) A. to reduce the elapsed…
Examine the partial Activity Over Time section of an Active Session History (ASH) report: Which two inferences are correct? (Choose two.) A. In the first time slot, five different sampled sessions were connected to the database instance. B. In the…
You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables…
Examine the parameters set for your database instance: You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some queries. While diagnosing, you notice a large number of hard parses occurring for several…
Which three actions should you perform to reduce shared pool fragmentation and avoid the “ORA-04031: unable to allocate …. bytes of shared memory” error for the shared pool? (Choose three.) A. Configure the Server Result Cache. B. Configure shared server…