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

Thread: redo log switch

  1. 01-09-2002, 07:03 AM #1
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    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.
    Reply With Quote Reply With Quote
  2. 01-09-2002, 07:04 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    instance recovery will be longer, that is the drawback
    Reply With Quote Reply With Quote
  3. 01-09-2002, 07:13 AM #3
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    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.
    Reply With Quote Reply With Quote
  4. 01-09-2002, 07:16 AM #4
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
  5. 01-09-2002, 07:22 AM #5
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    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.
    Reply With Quote Reply With Quote
  6. 01-09-2002, 07:27 AM #6
    Irfkhan
    Irfkhan is offline Junior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width