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

Index > ORACLE Server Parameters > statistics_level

statistics_level

Oracle 11.1.0:

Parameter Name:statistics_level
Description:statistics level
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:statistics_level
Description:statistics level
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:statistics_level
Description:statistics level
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:statistics_level
Description:statistics level
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:IMMEDIATE

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-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled
    Cause: The user attempted to set statistics_level to BASIC with auto-tune SGA enabled which cannot be done because auto-tune SGA cannot work with statistics_level set to BASIC.

    Action: Disable auto-tune SGA and try setting the statistics_level to BASIC again.

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

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