Which four statements would be true if you use bind var…

You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the
instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE
clause, causing a large number of hard parses to occur.
Which four statements would be true if you use bind variables for these queries? (Choose four.)

You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the
instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE
clause, causing a large number of hard parses to occur.
Which four statements would be true if you use bind variables for these queries? (Choose four.)

A.
Mutex contention in the library cache will be reduced.

B.
The optimizer will use one parent cursor and one child cursor for each SQL statement with different literal
values.

C.
Hard parses will be reduced for the queries.

D.
The optimizer will use bind peeking and subsequent execution of the queries will always generate the same
plans irrespective of the cardinality.

E.
The optimizer will generate the same plan for all bind values if no histograms exist on the columns used in
the WHERE clause of these queries.

F.
The optimizer will use bind peeking and use the literal value to determine the execution plan for these
queries.



Leave a Reply 0

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