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

Home -> Community -> Mailing Lists -> Oracle-L -> What is this Session Doing

What is this Session Doing

From: Ganesh Raja <ganesh.raja_at_gmail.com>
Date: Fri, 24 Sep 2004 11:28:12 +0100
Message-ID: <f754edf040924032837f0e468@mail.gmail.com>


Hi,

I have a query that has spawned parallel slaves. All the slaves are now waiting for a single slave to respond back. This slave process is churning away and eating up lot of CPU. [According to prstat]

When I see in v$sess_io i don't see any activity of this Process and since it is on the CPU it is not waiting .. So what is happening here.

The weird thing is that that the CPU statistics for this process are not being updated on v$sessstat

Any help is greatly appreciated.

Cheers
Ganesh R

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 24 2004 - 05:23:47 CDT

Original text of this message

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