Oracle Exam 1Z0-064 Topic 2 Question 27 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 27
Topic #: 2

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

ACreate the KEEP cache and cache the tables used in the queries.

BSet the CURSOR_SHARING parameter to FORCE.

CUse bind variables instead of literals.

DCreate SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.

ESet the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

Show Suggested Answer

Suggested Answer: B, E

by Charlene at May 04, 2022, 02:00 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!