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

Index > ORACLE Server Parameters > use_indirect_data_buffers

use_indirect_data_buffers

Oracle 11.1.0:

Parameter Name:use_indirect_data_buffers
Description:Enable indirect data buffers (very large SGA on 32-bit platforms)
Type:BOOL Obsoleted:TRUE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 10.2.0:

Parameter Name:use_indirect_data_buffers
Description:Enable indirect data buffers (very large SGA on 32-bit platforms)
Type:BOOL Obsoleted:TRUE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 10.1.0:

Parameter Name:use_indirect_data_buffers
Description:Enable indirect data buffers (very large SGA on 32-bit platforms)
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 9.2.0:

Parameter Name:use_indirect_data_buffers
Description:Enable indirect data buffers (very large SGA on 32-bit platforms
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Parameter Name:use_indirect_data_buffers
Description:Enable indirect data buffers (very large SGA on 32-bit platforms
Type:BOOL Obsoleted:TRUE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Parameter Name:use_indirect_data_buffers
Description:Enable indirect data buffers (very large SGA on 32-bit platforms
Type:BOOL 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-00385: cannot enable Very Large Memory with new buffer cache parameters
    Cause: User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32) } AND use_indirect_data_buffers is set to TRUE. This is illegal.

    Action: Very Large Memory can only be enabled with the old (pre-Oracle_8.2) parameters.

ORA-07305: ksmcsg: illegal database buffer size.

    Cause: The database buffer size must be a multiple of the extended cache mapping size for indirect data buffers to be used.

    Action: Verify that the db_block_size parameter is correct in INIT.ORA, or disable the use_indirect_data_buffers parameter.

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

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