RE: "log file sync" waits can occur for read only commits

From: Adrian <ade.turner_at_gmail.com>
Date: Sat, 26 Jan 2008 19:51:24 -0000
Message-ID: <479b8f3f.02ba420a.13db.ffffb4d0@mx.google.com>

It's a likely commit without a transaction present.

e.g.

select * from dual;
commit;

Regards
Adrian

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sriram Ramachandran
Sent: 25 January 2008 20:16
To: oracle-l_at_freelists.org
Subject: "log file sync" waits can occur for read only commits

Hi,

   We are running Oracle Apps 11.5.10.2/DB 10.2.0.3 on RH Linux 4.0. We are noticing log file sync along with db file sequential read frequently in the Top 5 timed events in the AWR report.Oracle support pointed me to the BUG 5087592 - "log file sync" waits can occur for read only commits as a possible cause. Can someone tell me what "read only commits" means?

We are also trying to reduce the number of commits in the application.

Thanks in advance,
Sriram  

---

---

Looking for last minute shopping deals? Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
--

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

No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.11/1244 - Release Date: 25/01/2008 19:44  

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.11/1244 - Release Date: 25/01/2008 19:44  

--

http://www.freelists.org/webpage/oracle-l Received on Sat Jan 26 2008 - 13:51:24 CST