[askdba] What is the Process Doing

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 24 Sep 2004 11:27:32 +0100


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.

Ganesh R

Other related posts: