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

Index > ORACLE Server Parameters > log_checkpoint_interval

log_checkpoint_interval


Oracle 11.1.0:

Parameter Name:log_checkpoint_interval
Description:# redo blocks checkpoint threshold
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:log_checkpoint_interval
Description:# redo blocks checkpoint threshold
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:log_checkpoint_interval
Description:# redo blocks checkpoint threshold
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:log_checkpoint_interval
Description:# redo blocks checkpoint threshold
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

Parameter Name:log_checkpoint_interval
Description:# redo blocks checkpoint threshold
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.0.6:

Parameter Name:log_checkpoint_interval
Description:# redo blocks checkpoint threshold
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 7.3.4:

Parameter Name:log_checkpoint_interval
Description:# redo blocks checkpoint threshold
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Related Error Messages:

ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
    Cause: An attempt to start MTTR advisory was made, which failed because either FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL was specified.

    Action: Set FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL to 0.


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

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