Exam 1z0-084 topic 1 question 1 discussion

Actual exam question from Oracle's 1z0-084

Question #: 1
Topic #: 1

The CURSOR_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an AWR report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses? (Choose two.)

A. Create the KEEP cache and cache tables accessed by the SQL statements.
B. Create the RECYCLE cache and cache tables accessed by the SQL statements.
C. Increase the size of the library cache.
D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.
E. Set the CURSOR_SHARING parameter to FORCE.

Show Suggested Answer

Suggested Answer: CE 🗳️

by cowwwboyy at May 24, 2024, 10:02 p.m.

Comments

Submit Cancel

d87d280

1 month, 1 week ago

Selected Answer: DE

There are many incorrect answers in this test, and reliable answers were paid for, but arguments are left to those interested, and they are not always accurate. In this case, the two actions that could reduce the number of hard parses are D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE and E. Set the CURSOR_SHARING parameter to FORCE. This is because increasing the library cache does not mitigate or reduce hard parses; it will only allow more cursors to be stored due to the use of literals. Be careful!

upvoted 1 times

...

cujar2003

9 months, 2 weeks ago

Increase the size of the library cache and cursor_sharing=FORCE

upvoted 3 times

...