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

Index > ORACLE Server Parameters > skip_unusable_indexes

skip_unusable_indexes

Oracle 11.1.0:

Parameter Name:skip_unusable_indexes
Description:skip unusable indexes if set to TRUE
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:skip_unusable_indexes
Description:skip unusable indexes if set to TRUE
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:skip_unusable_indexes
Description:skip unusable indexes if set to TRUE
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

No such parmeter in Oracle 9.2.0.

Oracle 8.1.7:

No such parmeter in Oracle 8.1.7.

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-26024: SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
    Cause: MAX_SGA is larger than the larger of initialization parameters SHARED_POOL_SIZE and SGA_TARGET.

    Action: Specify the value of MAX_SGA to be less than the maximum of SHARED_POOL_SIZE and SGA_TARGET. Likely only 75% or lower.

ORA-26028: index %s.%s initially in unusable state

    Cause: MAX_SGA is larger than the larger of initialization parameters SHARED_POOL_SIZE and SGA_TARGET.

    Action: Specify the value of MAX_SGA to be less than the maximum of SHARED_POOL_SIZE and SGA_TARGET. Likely only 75% or lower.

ORA-26029: index %s.%s partition %s initially in unusable state

    Cause: MAX_SGA is larger than the larger of initialization parameters SHARED_POOL_SIZE and SGA_TARGET.

    Action: Specify the value of MAX_SGA to be less than the maximum of SHARED_POOL_SIZE and SGA_TARGET. Likely only 75% or lower.

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

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