Oracle
1Z0-064 · Question #23
1Z0-064 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latest AWR report and find a large number of latch: shared pool wait events and also a high percentage of the hard parse elapsed time. Which two can be reasons for this? (Choose two.)
Options
- AThe I/O performance is slow.
- BBind variables are not used for similar queries, causing hard parses.
- CRepeated access to a small number of blocks.
- DExcessive time is spent on finding cached cursors in the library cache.
- EThe CURSOR_SHARING parameter is set to EXACT, which does not allow similar queries to
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.