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_at_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: oracledbam_at_hotmail.com
>
> 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: ListGuru_at_fatcity.com (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: MGogala_at_oxhp.com
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: ListGuru_at_fatcity.com (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).
Received on Tue Nov 05 2002 - 08:53:42 CST
