USER_RESOURCE_RESERVATION option

Function

Adjust memory use for the number of current users.

Allowed values

Integer

Scope

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

Default

1

Description

Sybase IQ tracks the number of open cursors and allocates memory accordingly. In certain circumstances, this option can be used to adjust the minimum number of current cursors that IQ thinks is currently using the product and hence allocate memory from the temporary cache more sparingly.

This option should only be set after careful analysis shows it is actually required. If you need to set this parameter, contact Sybase Technical Support with details.