What is the result of setting the CURSOR_SHARING = SIMILAR initialization parameter?

What is the result of setting the CURSOR_SHARING = SIMILAR initialization parameter?

What is the result of setting the CURSOR_SHARING = SIMILAR initialization parameter?

A.
turn off all literal replacement for the shared cursor

B.
causes the optimizer to share cursors for all statements

C.
causes the optimizer to examine the statement of ensure cursor sharing occurs for safe literals only

D.
causes the optimizer to ignore all indexes and static’s to establish the appropriate execution path



Leave a Reply 1

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