Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 - BrazilReceived on Thu Feb 27 1997 - 00:00:00 CST