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:
asrblogger.com/
Join Telegram : t.me/asrBlogger
Scripts from Github : github.com/ani...
#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba
Негізгі бет How to use Cursor Sharing in Oracle for Faster Query Execution!?
No video
Пікірлер: 4