Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index