Re: Wait on commit

So, do you know what happens when a commit happens? What files/processes come into play? Having a knowledge of how the database works might be of assistance here.

Have you run an AWR report to see what waits you are experiencing?

 Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press) The LDS Church is looking for DBA's. You must be LDS to apply (please don't write to me and tell me I'm breaking the law. A church can choose to hire members of it's own faith. Look it up if you don't believe me).

• Original Message ---- From: Yechiel Adar <adar666_at_inter.net.il> To: ORACLE-L <oracle-l_at_freelists.org> Sent: Wednesday, August 13, 2008 10:49:30 AM 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

--

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

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 13 2008 - 12:25:35 CDT