RE: Wait on commit
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "adar666@xxxxxxxxxxxx" <adar666@xxxxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Aug 2008 13:00:51 -0400
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
--
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
mark.bobak@xxxxxxxxxxxx
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
