RE: Wait on commit

From: Bobak, Mark <>
Date: Wed, 13 Aug 2008 13:00:51 -0400
Message-ID: <>

When the wait happens, what's V$SESSION_WAIT tell you? log file sync? Have you looked at the performance characteristics of the disk where the online redo log is?



Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059

ProQuest...Start here.

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

From: [] On Behalf Of Yechiel Adar Sent: Wednesday, August 13, 2008 12:50 PM To: ORACLE-L
Subject: Wait on commit

Oracle 10.2 on windows rac.

I have a procedure that is working fine until it does commit and then everything stops for a few seconds.
Since this is a web application this is not acceptable.

Causes and solutions please.


Adar Yechiel
Rechovot, Israel


-- Received on Wed Aug 13 2008 - 12:00:51 CDT

Original text of this message