-
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.
-
instance recovery will be longer, that is the drawback
-
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.
-
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
-
Thanks for the info Pando.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|