Optimization of Oracle
This setup is an optimization setup designed specifically for Oracle.
It is used, if it is set to Yes, to use a specific optimization strategy for the left list (FIRST ROWS, which is optimizing the response time necessary to obtain the first values).
The ORAOPTNB additional setup is used, if it is not null, to give the number of searched lines as fast as possible. This is helping to improve the optimization.
Level of localization / Global variable
This parameter is defined at the level Folder. It belongs to Chapter SUP (Supervisor) and the Group PRF (Performances), The following parameters are also associated with this chapter and group :
- AUZMEMO (Create all memos)
- CLOMAX (Max no.)
- LAUNCHSYNC (Sync launch after patch integration)
- MAXSPEACV (Specific ACV limit)
- MAXUPDTRS (Update transaction limit)
- MEMTXT (Size of text memory)
- NBTRABUFF (Number of lines in memory)
- NXTREC (Threshold for last read access)
- ORAOPTNB (Oracle optimization)
- ORATRAPATH (Oracle optimization)
- ROLLBACK (Lock attempts before rollback)
- SELWARN (Limit for control memos)
- TIMLCK (Unlock time in seconds)
- TIMOUT (Time limit for response)
The global variable GORAOPTMIZ is associated with it.