CURSOR_SHARING determines what kind of SQL statements can share the same cursors.
The possible values are EXACT which is the default value and SIMILAR and FORCE.
EXACT: Only allows statements with identical text to share the same cursor.
Allows the creation of a new cursor if sharing an existing cursor, or if the cursor plan is not optimal.
FORCE: Allows the creation of a new cursor if sharing an existing cursor, or if the cursor plan is not optimal.
SIMILAR: Causes statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect either the meaning of the statement or the degree to which the plan is optimized.
For more Information Visit:
https://asrblogger.com/
Join Telegram : https://t.me/asrBlogger
Scripts from Github : https://github.com/anishs10/dbscripts
#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba