redo log switch
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: redo log switch

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

    Are there any disadvantages in having log switch occur every 90mins ?

    Doesn't oracle recommend 1 every 30 - 60 mins ?

    Thanks

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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    instance recovery will be longer, that is the drawback

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Cheers Pando..

    Isn't Instance recovery/any recovery also based on checkpoints though.

    Oracle only starts applying redo info after the last checkpoint doesn't it ?

    If checkpoints are regular, this will decrease time to recover wouldn't it ?

    please confirm

    Thanks in advance

    Suresh.



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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well the point is when there is a log switch there is a checkpoint, the reason to make log swith less often is to avoid excess checkpoints, so if your log switch is every 90 minutes and checkpoint every 5 minutes then it is pointless setting your log so large so it switches log every 90 minutes

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Thanks for the info Pando.

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

  6. #6
    Join Date
    Aug 2000
    Posts
    13

    Best would be to go with recommended

    Oracle Recommends 20-30 Minutes but I would say it depends on the amount of transactions, Concurrently executing in the database.

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