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: v$wait_event: wait_time < 0

Re: v$wait_event: wait_time < 0

From: <fitzjarrell_at_cox.net>
Date: Thu, 14 Jun 2007 07:47:45 -0700
Message-ID: <1181832465.227814.66190@x35g2000prf.googlegroups.com>


On Jun 14, 9:06 am, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> I know this question was asked before but I don't think the answer was
> clear. I have the following returned from a query of v$session_wait
>
> SID EVENT WAIT_TIME SECONDS_IN_WAIT STATE
> --- -------------- --------- --------------- -----------------
> 19 latch free -1 361 WAITED KNOWN TIME
>
> The seconds_in_wait is constantly increasing. According to the 9i docs,
> the wait_time of -1 and state indicate that the wait event was very
> short and is now over. But if I look at the server process for sid 19,
> it's eating up cpu like there's no tomorrow (12.4% on an 8 cpu server).
> What exactly is the server process doing? Normally you can tell by the
> wait events but apparently not in this case.
>
> This process sat on the "latch free" event for 20 minutes with the
> seconds_in_wait increasing. If I run it again it may show up as sitting
> on "scattered read" for 20 minutes before finishing. A third time it may
> sit on "sql*net message from client" all the while the server process is
> running away with cpu. What is going on
>
> DB Version is 9.2.0.5. O/S is solaris.
>
> TIA
You may be experiencing bugs 3216002, 3239873, 3405237, 3490914, 3756797 in 9.2.0.5 which were corrected in 9.2.0.6 and later patches. You might want to look at Metalink Note 283897.1.

David Fitzjarrell Received on Thu Jun 14 2007 - 09:47:45 CDT

Original text of this message

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