DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=to:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:in-reply-to:x-mimeole:thread-index:from:message-id;
        b=makzfDtPilajHEQmP+oJO4vCZXB38K1Jx5AFGhc3WJZ3Jg69zAoMBwKicokdRsCFfDK934tczQFjRC3dKeBMo1LgPo4HyNhUMNUDFJQfkffSMAlhSR9gCM9CE8OoiStOTsHkfz1lEJnh0jmDmBvZXMN3wM6wuZpxyPw+MrCc5mo=
To: <sriram_kr_2000@yahoo.com>,
 <oracle-l@freelists.org>
Subject: RE: "log file sync" waits can occur for read only commits
Date: Sat, 26 Jan 2008 19:51:24 -0000
MIME-Version: 1.0
Content-Type: text/plain; charset="windows-1250"
In-Reply-To: <824623.87816.qm@web51504.mail.re2.yahoo.com>
From: Adrian <ade.turner@gmail.com>
Message-ID: <479b8f3f.02ba420a.13db.ffffb4d0@mx.google.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: ade.turner@gmail.com

It's a likely commit without a transaction present.

e.g.

select * from dual;
commit;

Regards
Adrian

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]
On Behalf Of Sriram Ramachandran
Sent: 25 January 2008 20:16
To: oracle-l@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