Configuration Parameters

New Configuration Parameters

Enables abstract plan sharing between different users. Tables of a query using a shared abstract plan must be explicitly prefixed with the owner name or belong to the DBO user.

See Abstract Plan Sharing Between Different Users

Configure the use of large buffer pools during the recovery phase for load database and load transaction commands.

The enable large pool for load configuration parameter defaults to 0 if enable functionality group is set to 0, and to 1 if it is set to 1.

See Improvements to the Recovery Log Scan During load database and load tran

Configure Engine Local Cache (ELC) size for procedure cache memory.

See Modify the ELC Size

Sets the look-ahead size (in numbers of log records) to be used by the recovery prefetch scan. Set to 0 if the scan is to determine the look-ahead size dynamically, or to a value > 0 if the look-ahead size is to be set to a specific number of log records to look-ahead.

See Improvements in Prefetch Used by Recovery

Changed Configuration Parameters

The configuration parameter, enable plan sharing is no longer dependent on the enable functionality group parameter.