Re: Why my query plan changed ?

Ajay,

I haven't worked with CURSOR_SHARING, so I cannot give you an answer based on experience, but just speculation. Perhaps someone else on the list has better advice.

    Since the goal of CURSOR_SHARING=FORCE is to avoid continual parsing and optimizing, I would assume that when you submit a SQL statement to Oracle, it is first converted to an equivalent statement with bind variables, and then Oracle will search for an existing equivalent SQL statement, and if it finds one, will use that execution plan. Therefore in answer to your question, I would assume that CURSOR_SHARING=FORCE would have the same side effect, that whatever execution plan is generated, all subsequent queries will share it.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l