Oracle
1Z0-054 · Question #144
You noticed a high number of SQL statements with the same PLAN_HASH_VALUES. View Exhibit1 to see the details. View Exhibit2 to see the details of the SQL text for the statements. What do you infer…
The correct answer is B. The statements are not using the same cursor. See the full explanation below for the reasoning.
Question
You noticed a high number of SQL statements with the same PLAN_HASH_VALUES. View Exhibit1 to see the details. View Exhibit2 to see the details of the SQL text for the statements. What do you infer from the results?
Exhibits
Options
- AThe statements are using the same cursor.
- BThe statements are not using the same cursor.
- CRemoving the bind variable would improve performance.
- DThe cursor for the statement is aging out of the shared pool very quickly.
How the community answered
(38 responses)- A8% (3)
- B76% (29)
- C13% (5)
- D3% (1)
Community Discussion
No community discussion yet for this question.