CURSOR_SHARING
Determines what kind of SQL statements can share the same cursors.
Property | Description |
Parameter type | String |
Default value | EXACT |
Recommended Value | Force |
Oracle FLEXCUBE relevance
Some of the FLEXCUBE sql statements are generated dynamically. So they contain literal values in the WHERE clause conditions. This results in large numbers of nearly identical statements with separate parse trees in Oracle's library cache, which can slow performance and cause latch problems.
By setting cursor_sharing to FORCE database convert literals to bind variables before parsing the statement.
Parent topic: Database Initialization Parameters