Which two actions would you recommend to improve perfor…

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 theWHEREclause. Which two actions would you recommend to
improve performance?(Choose two.)

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 theWHEREclause. Which two actions would you recommend to
improve performance?(Choose two.)

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

B.
Set theCURSOR_SHARINGparameter toFORCE.

C.
Use bind variables instead of literals.

D.
Create SQL plan baselines for the almost identical SQL statements and loadthem into the
cursor cache.

E.
Set theOPTIMIZER_CAPTURE_SQL_PLAN_BASELINESparameter toTRUE.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


vasya

vasya

imo should be B and C

job

job

B,C : although B in real life is a terrible thing to do at system level. see astktom

Larisa

Larisa

If you do B, than is no need for C. I would say either B+E, or C+E. Because query rewriting doesn’t seem to be the scope of the question, I’ll go for B+E