segspt_minfree

Description

Pages of system memory that cannot be allocated for ISM shared memory.

Data Type

Unsigned long

Default

5% of available system memory when first ISM segment is created.

Range

0 to 32,767

Units

Pages

Dynamic?

Yes

Validation

None. Values that are too small can cause the system to hang or performance to severely degrade when memory is consumed with ISM segments.

When to Change

On database servers with large amounts of physical memory using ISM, this parameter can be tuned downward. If ISM segments are not used, this parameter has no effect. A maximum value of 128 Mbytes (0x4000) is almost certainly sufficient on large memory machines.

Commitment Level

Unstable