Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> delay in commit statements

delay in commit statements

From: <aheda_at_cdotd.ernet.in>
Date: Mon, 17 Jul 2000 14:54:58 +0500 (GMT+0500)
Message-Id: <10561.112152@fatcity.com>


hi
I am facing a problem that whenever commiting a change in the database the time taken by the update statement is negligible but that of the commit statement is very significant.
i.e. each commit statement in the application takes around 20-30 ms which is not bearable in real time app.
In the current setup the datafiles redofiles and indexs are all stored on different physical disc.
what could be the possible reasons of this delay

Arvind Received on Mon Jul 17 2000 - 04:54:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US