That process has an oracle session associated with it.
Before killing it, it would be nice to see what that
session is doing. You could do it by joining v$process and
v$session. The SPID column in v$process is "System PID" and
ADDR column corresponds to the PADDR in V$SESSION table.
> -Original Message-
> From: Seema Singh [mailto:oracledbam@;hotmail.com]
> Sent: Monday, November 04, 2002 2:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: MTS process HIGH CPU
>
>
> Hi
> I am using MTS in 8.1.6.I am wondering one of MTS process is
> locked 2 table
> since morning and this process is taking more CPU.Can I kill
> that process
> like "ora_s000_prod" by using alter system and then unix kill command?
> Thx
> -Seema
>
>
>
>
>
>
> _
> Choose an Internet access plan right for you -- try MSN!
> http://resourcecenter.msn.com/access/plans/default.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
