Which two statements are true about cursor sharing? (Choose two.)
A.
Setting cursor_sharing to FORCE can result in a plan that is suboptimal for the majority of values bound to a bind variable when executing a cursor with one or more bind variables.
B.
Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.
C.
Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache.
D.
Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.
E.
Adaptive Cursor Sharing requires histograms on filtered columns, used in equality predicates, to allow different execution plans to be generated for statements whose bound values would normally generate different plans at hard parse time.
A is true because of skewed values in column
E is true because histograms are required for adaptive curso sharing look at: https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/improving-rwp-cursor-sharing.html#GUID-277432AA-CD1C-4A75-AB28-7358E63265B3
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-084 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
217972f
2 weeks, 1 day ago