RE: Oracle sessions and OS processes

From: Mohan, Ross <Ross.Mohan_at_PictureVision.com>
Date: Tue, 10 Oct 2000 15:50:03 -0400
Message-Id: <10645.118900@fatcity.com>

it is not dangerous, in my experience, to kill the os shadows....

-----Original Message-----
From: Linda Wang [mailto:lwang_at_messagemedia.com] Sent: Tuesday, October 10, 2000 3:06 PM
To: Multiple recipients of list ORACLE-L Subject: Oracle sessions and OS processes

Hi,
I believe the session '172, 9' was hanging since 21-SEP. But when I tried to kill session, I go ORA-00030: user session ID does not exist Oracle Technical support said that only two choices: 1. Wait for pmonto clean it. (Since the session could not be marked as killed,

I do not believe pmon is doing anything for this) 2. Boune database (This is not a choice for a 24/7 shop.)

Does anybody know how Oracle processes related to the OS processes? Is it too dangerous to kill the OS processes (19732,28381,23335)?

select spid, sid, a.serial#, b.username
from v$session a, v$process b
where a.serial# = b.serial# and a.serial#=9;

SPID SID SERIAL# USERNAME --------- ---------- ---------- ---------------

19732            172          9 oracle
29381            172          9 oracle
23335            172          9 oracle



$ ps -ef |grep 19732

  oracle 19732     1  0   Oct 07 ?        0:05 oracleDEEP (LOCAL=NO)



$ ps -ef |grep 29381

  oracle 29381     1  0 08:34:30 ?        0:01 oracleDEEP (LOCAL=NO)



$ ps -ef |grep 23335

  oracle 23335     1  0   Oct 09 ?        0:01 oracleDEEP (LOCAL=NO)

SELECT s.SID,s.serial#,start_time,current_time from v$session_longops l,v$session s
where s.status='ACTIVE' and (sofar < totalwork) and l.sid=s.sid;

SID SERIAL# START_TIME CURRENT_TIME

---------- ---------- -------------------- --------------------
       172          9 21-SEP-2000 13:45:24 21-SEP-2000 13:45:24
       172          9 21-SEP-2000 10:02:17 21-SEP-2000 10:02:17

select sid,serial#,LAST_CALL_ET,ROW_WAIT_ROW#,status from v$session
     where sid=172 and serial#=9;

       SID    SERIAL# LAST_CALL_ET ROW_WAIT_ROW# STATUS
---------- ---------- ------------                 -------------            
           --------
       172          9      1706983            99

ACTIVE SQL> alter system kill session '172,9';
alter system kill session '172,9'
*
ERROR at line 1:
ORA-00030: user session ID does not exist

Thanks.
Linda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Linda Wang
  INET: lwang_at_messagemedia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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

Received on Tue Oct 10 2000 - 14:50:03 CDT