I been dealing with log file sync showing up in my top 10 of my awr report.
I made changes to eliminate the log file sync, however there was one
additional recommendation that I don't feel comfortable about and can't
seem to get clarification from support.
They are recommending to promote the LGWR background process to become a
critical thread by placing the thread in the FX scheduling class at
priority sixty will cause the thread to be treated as critical.
when i check our current setting. i was already at 60.
QL> host ps -ecf | grep lgwr
oracle 21338 21337 FX 0 15:22:17 pts/85 0:00 grep lgwr
oracle 21337 18771 FX 0 15:22:17 pts/85 0:00 /bin/sh -c ps -ecf
| grep lgwr
oracle 25393 25382 FX 60 Aug 29 ? 545:15 ora_lgwr_cg
What I don't understand is how this value is determined can it go higher
and what are the consequence of changing this value higher? Not sure how
increasing the value help the io issue..
Anyone every make changes to this process.
