CURSOR_SHARING

Determines what kind of SQL statements can share the same cursors.

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.