Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Wait for a undo record
<OakRogbak_erPine_at_yahoo.com> wrote in message
news:13fdc9b4.0411231036.3147cf1b_at_posting.google.com...
> I ran a statspack report against my 8.2.7.4 database. I ran it for a
> period of only 3.80 minutes (I usually try to do 15 minute periods).
> Among the Top 5 Wait Events it shows:
> Wait for a undo record 7,219 79,386
> 52.25
>
> 79386 cs = 793 seconds = 13.22 minutes
>
> How can this wait time be longer than than my snapshot period? Yes, I
> did have TIMED_STATISTICS turned on.
>
> Thanks,
> Roger
That's probably the cumulative wait time for all sessions. So if you have 100 sessions waiting 1 minute during a 3 minute interval, you have 100 minutes of wait time.
Matthias Received on Tue Nov 23 2004 - 16:58:23 CST