Results 1 to 4 of 4

Thread: Checkpoint

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Checkpoint

    Dear friends,

    In my database I've set log_checkpoint_timeout=600; ie; 10min

    No activity is happened during last 30 min.

    Will checkpoint occur or not?

    Pls explain

    regards
    sudheer

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273

    Re: Checkpoint

    Originally posted by sudheer_ics
    Dear friends,

    In my database I've set log_checkpoint_timeout=600; ie; 10min

    No activity is happened during last 30 min.

    Will checkpoint occur or not?

    Pls explain

    regards
    sudheer
    If you are sure that no activity that causes checkpoint occurs within 10 minutes, then this parameter will definately causes the checkpoint at after 10 minutes.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    The minimum value for LOG_CHECKPOINT_TIMEOUT is 900.
    If you set the value below 900 in the Standard Edition, then Oracle rounds it to 900.

  4. #4
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    Let's see what oracle say about LOG_CHECKPOINT_TIMEOUT

    Using LOG_CHECKPOINT_TIMEOUT
    Set the initialization parameter LOG_CHECKPOINT_TIMEOUT to a value n (where n is an integer) to require that the latest checkpoint position follow the most recent redo block by no more than n seconds. In other words, at most, n seconds worth of logging activity can occur between the most recent checkpoint position and the end of the redo log. This forces the checkpoint position to keep pace with the most recent redo block

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •