log file sync

From: Michael Calisi <oracle455_at_gmail.com>
Date: Wed, 30 Sep 2015 15:26:14 -0400
Message-ID: <CAJkYCMEW3Lzy4bx6j+SwmUCSK24O5wehKdM6p5+x5XxV19kOBg_at_mail.gmail.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 30 2015 - 21:26:14 CEST