HELP! Session ID from a PID!

From: <larionov_at_yahoo.com>
Date: Fri, 25 Jun 1999 19:51:34 GMT
Message-ID: <7l0mk1$dsr$1@nnrp1.deja.com>

Hi,

I found that on the system I manage ( Oracle 8.032 on Solaris2.6 ) there is sometimes some oracle processes which take 25% or more of CPU.
How can I find their SID in order to kill them.

OK, I tried v$session, but it does not help when dealing with parallel query processes.

For example the offending process is ora_p068_SID, and v$session in this case does not return any rows.

Maybe there are some other dynamic views which I can use to determine their SID ( and serial number )?

Please help!

When posting please send a copy to
larionov_at_yahoo.com

Thank you!

Michael.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 25 1999 - 14:51:34 CDT