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.)

Question

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.)

Accepted Answer

B. Set the CURSOR_SHARING parameter to FORCE. C. Use bind variables instead of literals.

Answer

A. Create the KEEP cache and cache the tables used in the queries.

Answer

D. Create SQL plan baselines for the almost identical SQL statements and load them into the cursor

Answer

E. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

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…

Question

Exhibit

Options

How the community answered

Community Discussion