Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Wait for a undo record

Re: Wait for a undo record

From: Access <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 23 Nov 2004 23:58:23 +0100
Message-ID: <41a3c095$0$9300$ba620e4c@news.skynet.be>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US