RE: Wait on commit
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 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_at_proquest.com
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.
http://www.freelists.org/webpage/oracle-l Received on Wed Aug 13 2008 - 12:00:51 CDT