RE: Oracle sessions and OS processes

From: Mohan, Ross <Ross.Mohan_at_PictureVision.com>
Date: Thu, 12 Oct 2000 11:44:10 -0400
Message-Id: <10647.119080@fatcity.com>

Linda,

I do not. I might be able to swag an answer, but i suspect you want something more cognitively nutritive than that.

Maybe you can knock at the door of the Cave of Steve Adams, and see if he is home? <G>

Ross

-----Original Message-----

From: Linda Wang [mailto:lwang_at_messagemedia.com] Sent: Wednesday, October 11, 2000 11:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle sessions and OS processes

Ross,
Do you know why the OS stime is different from the start_time in v$session_longops for the same serial# ?

Thanks.
Linda

-----Original Message-----

Sent: Tuesday, October 10, 2000 2:56 PM
To: Multiple recipients of list ORACLE-L

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

-----Original Message-----

Sent: Tuesday, October 10, 2000 3:06 PM
To: Multiple recipients of list ORACLE-L

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 also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohan, Ross
INET: Ross.Mohan_at_PictureVision.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

--

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