Thanks for the question, Priscila.
Asked: October 28, 2020 - 9:43 pm UTC
Last updated: November 02, 2020 - 3:11 am UTC
Version: Oracle 11.2.0.4 Enterprise Edition
Viewed 1000+ times
You Asked
Hi,
I need some help please. I have a database 11.2.0.4 that is generating a lot of redo log switch all night. But during the day the number of switches per hour is 5.
In the night the system loads are performed.
What should I do? Do I need to do a resize of the redos?
Currently they have 200M.
thanks
and Connor said...
Redo log switches is not in itself *very* bad thing, ie, that days of the system "freeziing" to do a large checkpoint are long gone. Although, some activities *do* occur on each switch, so there's a couple of things I'd recommend
1) Increase the size of the redo
You do this by adding new larger redo log file groups, and then dropping the older small ones once they are no longer current (V$LOG tells you which is current)
2) Take at look at
- v$segstat for "db block changes"
- v$sesstat for "redo size"
This should reveal some insight as to which sessions and which tables/indexes are experiencing the most change and generating the most redo. Perhaps there are some tuning opportunities there.
Is this answer out of date? If it is, please let us know via a Comment