Which two inferences can you derive from the details in this section?

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. B. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred […]

Read More

Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing

Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessionsthat are competing for resources? (Choose four.) A. distributing available CPU by allocating percentages of CPU time to different users and applications B. limiting the degree of parallelism of any operation performed by members of a group of users C. limiting […]

Read More

Which two statements are true about server-generated alerts?

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 only when the STATISTICS_LEVEL initialization parameter is set to ALL. D. They can be generated […]

Read More

Which two actions could improve the performance?

Examine the parameters: Your database supports a mixed workload and users have dedicated server connections. Users complain aboutthe increased response time of a few queries that are performing large sort operations. On investigation, younotice an increase in the number of multipass work area executions and high number of direct path writewait events.Which two actions could […]

Read More

Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database?

Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage.One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then addedback to the diskgroup, database performance is affected by rebalance operations.Which two actions would you recommend to lower the impact of rebalance operations on […]

Read More

Which three statements are true in this scenario?

You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set tothe default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a largenumber of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutexwaits in the Top 10 foreground events section. […]

Read More

Which two statements are true about ADDM or Real-Time ADDM?

Which two statements are true about ADDM or Real-Time ADDM? (Choose two.) A. ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted. B. ADDM runs in Partial mode to analyze any hung database […]

Read More

bytes of shared memory” error for the shared pool?

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 mode. C. Identify the packages or procedures that are causing the “ORA-04031: unable to allocate …. […]

Read More

Which two actions would you recommend to improve performance?

Examine the parameters set for your database instance: You are administering a database that supports an OLTP workload. Users complain about the degradedperformance of some queries. While diagnosing, you notice a large number of hard parses occurring forseveral syntactically almost identical SQL statements that differ only in literal values in the WHERE clause.Which two actions […]

Read More