RE: delay in commit statements

Hi Arvind,

        what about to see the performance of the disks where the redo logs are?.

You can use iostat to see the service time.Ttake into account that it is the total time taken by a read/write to complete. It is the sum of the time spent waiting on the wait queue and the time spent being service on the active queue.

If you have troubles interpreting the iostat output, let me know.

HTH Carlos.

> ----------
> De: aheda_at_cdotd.ernet.in[SMTP:aheda_at_cdotd.ernet.in]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Lunes 17 de Julio de 2000 08:24
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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
>
>
>
> --
> Author:
> INET: aheda_at_cdotd.ernet.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jul 17 2000 - 12:29:58 CDT