Is it Possible to Alter Session by Changing "CURSOR_SHARING" to "FORCE" at the Start of FTP Process Execution?
(Doc ID 2385000.1)
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'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!