Same for me,
I never had problems in killing at the os level , unix
or nt.
- "Mohan, Ross" <Ross.Mohan_at_PictureVision.com> a
écrit : > 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
> 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Received on Wed Oct 11 2000 - 03:34:55 CDT
