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

Index > ORACLE Server Parameters > optimizer_index_caching

optimizer_index_caching


Oracle 11.1.0:

Parameter Name:optimizer_index_caching
Description:optimizer percent index caching
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:optimizer_index_caching
Description:optimizer percent index caching
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:optimizer_index_caching
Description:optimizer percent index caching
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:optimizer_index_caching
Description:optimizer percent index caching
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Parameter Name:optimizer_index_caching
Description:optimizer percent index caching
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Parameter Name:optimizer_index_caching
Description:optimizer percent index caching
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

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

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