Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > large_pool_size

large_pool_size


Oracle 11.1.0:

Parameter Name:large_pool_size
Description:size in bytes of large pool
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:large_pool_size
Description:size in bytes of large pool
Type:TYPE=6 Obsoleted:TRUE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:large_pool_size
Description:size in bytes of large pool
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:large_pool_size
Description:size in bytes of the large allocation pool
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

Parameter Name:large_pool_size
Description:size in bytes of the large allocation pool
Type:CHAR Obsoleted:TRUE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Parameter Name:large_pool_size
Description:size in bytes of the large allocation pool
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-00091: LARGE_POOL_SIZE must be at least %s
    Cause: The value of LARGE_POOL_SIZE is below the minimum size.

    Action: Increase the value of LARGE_POOL_SIZE past the minimum size.

ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC

    Cause: The value of LARGE_POOL_SIZE is less than the value of LARGE_POOL_MIN_ALLOC.

    Action: Increase the value of LARGE_POOL_SIZE past the value of LARGE_POOL_MIN_ALLOC.


This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ large_pool_size ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US