Initialization Parameters, 70 of 188

LARGE_POOL_SIZE

Parameter type:
String

Syntax
LARGE_POOL_SIZE = integer [K | M]

Parameter class:
Static

Default value:
0 if

The pool is not required by parallel execution and

DBWR_IO_SLAVES is not set.

Otherwise, derived from the values of PARALLEL_MAX_SERVERS, PARALLEL_THREADS_PER_CPU, PARALLEL_SERVER_INSTANCES, MTS_DISPATCHERS, and DBWR_IO_SLAVES.

Range of values:
600K to at least 2 GB (actual maximum is operating system specific)

LARGE_POOL_SIZE lets you specify the size in bytes of the large pool allocation heap. The large pool allocation heap is used in multi-threaded server systems for session memory, by parallel execution for message buffers, and by backup processes for disk I/O buffers. (Parallel execution allocates buffers out of the large pool only when PARALLEL_AUTOMATIC_TUNING is set to TRUE.)

CAUTION: When Oracle derives a default value, it adds 250K per session for the multi-threaded server if MTS_DISPATCHERS is configured. The final derived value also includes a port-specific amount of memory for backup I/O buffers. The total derived default value can either be too large to allocate or can cause performance problems. In that case, set LARGE_POOL_SIZE to a number sufficiently small so that the database can start.

You can specify the value of this parameter using a numeric value or number, optionally followed by K or M to specify kilobytes or megabytes, respectively.
See Also: Oracle8i Designing and Tuning for Performance and Oracle8i Migration for more information on setting this parameter.

Parameter type:	String
Syntax	`LARGE_POOL_SIZE = integer [K \| M]`
Parameter class:	Static
Default value:	0 if The pool is not required by parallel execution and `DBWR_IO_SLAVES` is not set. Otherwise, derived from the values of `PARALLEL_MAX_SERVERS`, `PARALLEL_THREADS_PER_CPU`, `PARALLEL_SERVER_INSTANCES`, `MTS_DISPATCHERS`, and `DBWR_IO_SLAVES`.
Range of values:	600K to at least 2 GB (actual maximum is operating system specific)
`LARGE_POOL_SIZE` lets you specify the size in bytes of the large pool allocation heap. The large pool allocation heap is used in multi-threaded server systems for session memory, by parallel execution for message buffers, and by backup processes for disk I/O buffers. (Parallel execution allocates buffers out of the large pool only when `PARALLEL_AUTOMATIC_TUNING` is set to `TRUE`.)
CAUTION: When Oracle derives a default value, it adds 250K per session for the multi-threaded server if `MTS_DISPATCHERS` is configured. The final derived value also includes a port-specific amount of memory for backup I/O buffers. The total derived default value can either be too large to allocate or can cause performance problems. In that case, set `LARGE_POOL_SIZE` to a number sufficiently small so that the database can start.
You can specify the value of this parameter using a numeric value or number, optionally followed by K or M to specify kilobytes or megabytes, respectively. See Also: Oracle8i Designing and Tuning for Performance and Oracle8i Migration for more information on setting this parameter.