New Configuration Parameters

optimize temp table resolution

Summary Information
Default value	0
Range of values	0, 1
Status	Static
Display level	Comprehensive
Required role	System Administrator
Configuration group	Query Tuning

Allows stored procedures that reference temporary tables created outside the procedure to not require recompiling for each execution. Trace flag 299 previously supported this functionality.

enable ISM

Summary Information
Default value	0
Range of values	0 – 2
Status	Static
Display level
Required role	System Administrator
Configuration group	Physical Memory

Enables and disables Adaptive Server to use integrated service management (ISM) on the Solaris platform. Valid values are:

0 – use ISM if possible; if ISM is not available, use regular shared memory.
1 – use only regular shared memory.
2 – use only ISM.

enable HugePages

Summary Information
Default value	0
Range of values	0 – 2
Status	Static
Display level
Required role	System Administrator
Configuration group	Physical Memory

Enables and disables Adaptive Server to use huge pages on Linux platforms that support huge pages. Valid values are:

0 – use huge pages if possible; if huge pages are not available, use regular pages.
1 – use only regular pages.
2 – use only huge pages.

max util parallel degree

Summary Information
Default value	1
Range of values	1– 255
Status	Dynamic
Display level	Basic
Required role	System Administrator
Configuration group	Query Tuning

max util parallel degree specifies the server-wide maximum number of worker processes allowed per query used by the create index with consumers and update stats with consumers commands.

solaris async i/o mode

Summary Information
Default value	0
Values	0, 1
Status	Static
Display level
Required role	System Administrator
Configuration group	Disk I/O

Allows you to select various asynchronous IO modes on the Solaris platform. This parameter is effective if Adaptive Server is running in threaded kernel mode. This parameter is static, therefore is effective after restarting Adaptive Server.

0 – (Default) Use this mode if the Solaris patch containing the fix for Oracle BugID 16054425 is not installed. You may see sub-optimal IO performance.

1 – (Recommended) You must have the Solaris patch containing the fix for Oracle BugID 16054425 installed.

Install the following Oracle patch for your platform:

For Solaris 10 SPARC: 148888-03
For Solaris 10 x86/x64: 148889-03
For Solaris 11, latest SRU containing fix for Oracle Bug 16054425

Note: If solaris async i/o mode is set to 1 without the patch for Oracle BugID 16054425, Adaptive Server may report 694 or 823 errors and require restarting the server. Oracle Bug 15868517 refers to backport of Oracle Bug 16054425 for S10U11.