Improving OFS PCD Engine Performance

D.2 Improving OFS PCD Engine Performance

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

Add CursorSharingMode entry in respective ofsIRC.ini file as shown below to take advantage of setting cursor sharing parameter at session level.
```
;CursorSharingMode can be enabled and set to SIMILAR or EXACT or FORCE
[debug]
CursorSharingMode=EXACT
```
Engine reads value against Key CursorSharingMode and sets CURSOR_SHARE at DB Session level accordingly.
The engine executes the following statement if the value is set against CursorSharingMode Key. ALTER SESSION SET CURSOR_SHARING = <Input Value> in upper case <Input Values>: EXACT, FORCE, SIMILAR
If NO value is supplied, the Engine does not set any alter statement.
ofsIRC.ini file is present in $FIC_DB_HOME/conf folder.
To comment on this cursor sharing parameter setting, comment as shown below in the ofsIRC.ini file:
```
;CursorSharingMode can be enabled and set to SIMILAR or EXACT or FORCE
[debug]
;CursorSharingMode=EXACT
```