Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?

Which three features work together, to allow a SQL statement to have different cursors for
the same statement based on different selectivity ranges?

Which three features work together, to allow a SQL statement to have different cursors for
the same statement based on different selectivity ranges?

A.
Adaptive Cursor Sharing

B.
Bind variable used in a SQL statement

C.
SQL Plan Baselines

D.
Bind Variable Peeking

E.
Literals in a SQL statement

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

Rajeev

Rajeev

I think ABD is the right Answer.

Reply

Rajeev

Rajeev

…Which three features work together…

Adaptive cursor sharing (C) can generate different plans based on value of bind variable. To use this feature, SQL statement has to have bind variables(B) and Oracle has to read value of bind variable(D).

ABD features works _together_

Reply

Rajeev

Rajeev

Sorry it’s Adaptive cursor sharing (A)

Reply

mogukiller

mogukiller

ABD right answer.

If SQL Statement means same sql_id. With literals the sql_id changes.

Reply