Re: What is Happening in this Session

From: <yong321_at_yahoo.com>
Date: 12 Oct 2005 09:29:16 -0700
Message-ID: <1129134556.875492.12180@g49g2000cwa.googlegroups.com>

Ganesh Raja wrote:
> I have Got a Parallel Query Running for ages on my Oracle 9.2.0.6 /
> Solaris 8 (The Box has 20 Cpus and the Tables are Defined as Parallel
> with a Degree of 8).
>
> The Query has been running for the past 17 Hrs and the wait events show
> a Latch Free Event with a status of Waited Known Time.

Contact Oracle support. In the meantime, try a different version of connection driver (I assume you're not using SQL*Plus).

Does seq# in v$session_wait increment? What latch is it waiting on? Look at v$latch for the latch number shown in v$session_wait. Is there anything in v$latchholder? Show Oracle support the contents of v$latch_misses.

Yong Huang Received on Wed Oct 12 2005 - 11:29:16 CDT