Re: REDO log shifts are blocking for DB updates !!!

"Kjell R. Christensen" <krc_at_nera.no> wrote:

> Hi !
>
> We are currently implementing a 'time critical' system where all
> accesses towards the DB must be guaranteed a response time less or equal
> to 150 milliseconds.
> The transactions consists of both select and select for update
> statements.
>
> THE PROBLEM !!!
> Since transaction also contains updates, the REDO log file fills up and
> are switches on regular basis. During the switch the update statements
> are stalled/delayed for the same amount of time as it takes to switch
> REDO log file. Why ?????

        (...)
>
> An attached WORD file will show the delay graphically. Both axis are in
> milliseconds.
>

        Where is the attached word file?

        Thanks,

--
Luis Santos
Relacional Consultoria
Rio de Janeiro - Brazil