Re: undo header/block

You guys are right. I am trying to fix something which is not an issue at all. I think I understand better now about this rollback stuff.

rgds
Daud

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<apgc15$be6$1$8302bc10_at_news.demon.co.uk>...
> Consider the scale - 24 UNDO waits per day
> will typically be less than 0.5 seconds per day,
> which isn't really much of a problem.
>
> If you have a busy system, with lots of updates
> and queries taking place in any 'localised' section
> of the database, it is almost inevitable that one process
> may want to rollback (for consistency) some work that
> was done so recently that there is a collision on active
> UNDO blocks. There are a number of scenarios - but
> if the time lost is tiny, there's no point in trying to 'fix'
> the issue.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
Received on Sun Oct 27 2002 - 21:30:54 CST