Is it Possible to Alter Session by Changing "CURSOR_SHARING" to "FORCE" at the Start of FTP Process Execution?
Last updated on MAY 04, 2018
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Since there is requirement which does not allow to permanently keep the value to 'FORCE', is there a way to change the value of CURSOR_SHARING to 'FORCE' only for the session of the FTP process (i.e. alter session at the beginning of FTP process)?
It has been noticed that the FTP processes run much faster if the database CURSOR_SHARING parameter is set to 'FORCE', instead of the default value, i.e. 'EXACT'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms