2 Replies Latest reply: Oct 7, 2012 11:43 AM by Marco V. RSS

    Query about Log_Checkpoint_interval Parameter

    sandy121
      What's the utility for Log_Checkpoint_interval ? Does it have any impact on performance of DB?
        • 1. Re: Query about Log_Checkpoint_interval Parameter
          sb92075
          918868 wrote:
          What's the utility for Log_Checkpoint_interval ? Does it have any impact on performance of DB?
          ANY activity has impact on performance; but if it is so small that it can not accurately be measured does it matter.

          How do I ask a question on the forums?
          SQL and PL/SQL FAQ

          when all else fails Read The Fine Manual

          http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams132.htm#REFRN10095
          • 2. Re: Query about Log_Checkpoint_interval Parameter
            Marco V.
            What kind of problems are you experiencing ?

            Have a look at this note:
            Checkpoint Tuning and Troubleshooting Guide [ID 147468.1]
            ...
            LOG_CHECKPOINT_INTERVAL influences when a checkpoint occurs, which means 
            careful attention should be given to the setting of this parameter, keeping it 
            updated as the size of the redo log files is changed.  The checkpoint 
            frequency is one of the factors which impacts the time required for the 
            database to recover from an unexpected failure.  Longer intervals between 
            checkpoints mean that if the system crashes, more time will be needed for the 
            database to recover.  Shorter checkpoint intervals mean that the database will 
            recover more quickly, at the expense of increased resource utilization during 
            the checkpoint operation.
            ...