D.1 Improving OFS FTP Engine Performance

For improving the OFS FTP Engine performance, follow the steps given below:

1. Add CursorSharingMode entry in respective ofstpol.ini file as shown below to take advantage of setting cursor sharing parameter at session-level.

   [debug]
   FileName=ofstpol
   CALC_LOG=3
   ACCESS_LOG=3
   ERROR_LOG=3
   ComponentName=RUN EXECUTABLE
   CursorSharingMOde=EXCT

2. Engine reads value against Key CursorSharingMode and sets CURSOR_SHARE at DB Session level accordingly.
3. The engine executes the below statement if the value is set against CursorSharingMode Key. ALTER SESSION SET CURSOR_SHARING = <Input Value> in upper case <Input Values>: EXACT, FORCE, SIMILAR
4. If NO value is supplied, the Engine does not set any altered statement.
5. ofsptol.ini file is present in $FIC_DB_HOME/conf folder.
6. To comment on this cursor sharing parameter setting, comment as shown below in the ofstpol.ini file:

   [debug]
   FileName=ofstpol
   CALC_LOG=3
   ACCESS_LOG=3
   ERROR_LOG=3
   ComponentName=RUN EXECUTABLE
   ;CursorSharingMode=EXACT