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 with no DML activity. Some users complain about poor performance of these queries.You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)
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.)
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 syntactically almost identical SQL statements that differ only in literal values in the WHERE clause.Which two actions would you recommend to improve performance? (Choose two.)
Which three actions should you perform to reduce shared pool fragmentation and avoid the "ORA-04031: unable to allocate .... bytes of shared error for the shared pool? (Choose three.) memory"
Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)
You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latestAutomatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache waits in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the AWR report: mutexWhich three statements are true in this scenario? (Choose three.)
