ckpoint at log switch.. true/false ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ckpoint at log switch.. true/false ?

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Friends..

    During an Oracle8i course I attended, ckpoints were discussed. The instructor pointed out that a checkpoint does NOT occur when there is a log switch. I have read in countless manuals and documetation that a checkpoint DOES occur at every log switch.

    Can one of you experts please clear up who is right ?

    Thanks

    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Checkpoint does occur at each log switch. It can occur more frequently if configured.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    Sureshy,

    Who was the course with.

    I will make a note not to use them!

    Rgds

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    It was B&R taken about 6 weeks ago... Oracle University.

    I pointed out that it was in all of the documentation but he said that the documentation was wrong. I couldn't understand it either...

    Thanks for clearing up folks.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  5. #5
    Join Date
    Oct 2000
    Posts
    467
    well.. looks like the guy had some ego. So no more training with those guys.. eh ?

    Cheers
    Vinit

Posting Permissions

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



Click Here to Expand Forum to Full Width