Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> delay in commit statements
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