RE: How to kill a user active session?

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 26 Jul 2000 08:01:39 -0400
Message-Id: <10570.112993@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF6F9.43B9C180
Content-Type: text/plain;

charset="iso-8859-1"

You can also kill the o/s pid if alter system kill session is not working and you are absolutely sure this is a runaway process. -----Original Message-----
From: Anies Yahoo [mailto:anies_th_at_yahoo.com] Sent: Wednesday, July 26, 2000 3:34 AM
To: Multiple recipients of list ORACLE-L Subject: RE: How to kill a user active session?

> 1. Can any body please explain, why this above error came even when I can see the username, sid and status as active in v$session.

when you see the session_id in v$session, you could kill that session

> 2. Also, please, is there any other way to kill an active user session?

use the instance manager (the one of utilities in enterprise manager).

HTH, Anies.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Maheshwara Rao, L., Teki
Sent: Wednesday, July 26, 2000 11:27 AM
To: Multiple recipients of list ORACLE-L Subject: How to kill a user active session?

Hi All,

Environment : Solaris 2.6 : db version : 8.0.4

One of my developers was accessing the database thru SQL*NET. He was doing simple commands (like descry. Table structures, etc) in SQL PLUS. After some time his screen hung. He could not close the screen. He ended sql task through task manager on PC. After this, I queried the table v$session and the following are the details of v$session table query.

Username - hall :::: sid -- 13 :::: serial# --5555 ::: status - active

I gave the following command.

ALTER SYSTEM KILL SESSION '13,5555'; Now, I got error ---- ORA - 00030 : user session ID does not exist

I repeated the above sequence of actions after 5 minutes, i.e., querying the v$session and then giving the command --- alter system kill session.

I got same error message as above. (while the above activity is going on, other developers were accessing db through SQL NET).

QUESTIONS :

Can any body please explain, why this above error came even when I can see the username, sid and status as active in v$session.
Also, please, is there any other way to kill an active user session?

Thanks in advance,

Rao

teki01_at_mediaone.net <mailto:teki01_at_mediaone.net>

------_=_NextPart_001_01BFF6F9.43B9C180
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20 "urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: Urgent: NT 8.0.5 restarted after 76 days, now slow</TITLE>

<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml_at_01BFF68F.6383C700" rel=3DFile-List><!--[if gte mso 9]><xml>
<w:WordDocument>

  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>

</w:WordDocument>
</xml><![endif]-->
<STYLE>P.MsoNormal {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" }
LI.MsoNormal {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" }
DIV.MsoNormal {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" }
A:link {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
SPAN.MsoHyperlink {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
A:visited {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
SPAN.MsoHyperlinkFollowed {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
P.MsoAutoSig {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New = Roman"
}
LI.MsoAutoSig {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New = Roman"
}
DIV.MsoAutoSig {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New = Roman"
}
P {

FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: = "Times New Roman"; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; = mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {

COLOR: navy; mso-style-type: personal-reply; mso-ansi-font-size: = 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial
}
DIV.Section1 {

page: Section1
}
OL {

MARGIN-BOTTOM: 0in
}
UL {

MARGIN-BOTTOM: 0in
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US style=3D"tab-interval: .5in" vLink=3Dblue =
link=3Dblue>
<DIV>You=20
can also kill the o/s pid if alter system kill session is not working = and you=20
are absolutely sure this is a runaway process.</DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
 <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: Anies Yahoo=20 [mailto:anies_th_at_yahoo.com] Sent: Wednesday, July 26, 2000 = 3:34=20
 AM To: Multiple recipients of list = ORACLE-L Subject: RE:=20
 How to kill a user active session? </DIV> <DIV> <SPAN=20 class=3DEmailStyle18><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20
 class=3D230322006-26072000>  <SPAN=20 class=3DEmailStyle18><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">><SPAN=20
 class=3D230322006-26072000> 1.<SPAN=20
 style=3D"FONT: 7pt 'Times New =
Roman'">      =20 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Can=20
 any body please explain,  why this=20
 above error came even when I can see the username, sid and status as = active in=20
 v$session.
 <SPAN=20 class=3DEmailStyle18><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"> 
 <SPAN=20 class=3DEmailStyle18><SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><o:p><SPAN=20
 class=3D230322006-26072000>when you see the session_id in v$session,=20 you could kill that session</o:p> <SPAN=20 class=3DEmailStyle18><SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><o:p><SPAN=20
 class=3D230322006-26072000></o:p>  <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">><SPAN=20
 class=3D230322006-26072000> 2.<SPAN=20
 style=3D"FONT: 7pt 'Times New =
Roman'">      =20 <SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Also,=20
 please, is there any other way to kill an active user=20 session?
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"> 
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20
 class=3D230322006-26072000>use=20
 the instance manager (the one of utilities in enterprise=20 manager).
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20
 class=3D230322006-26072000>  <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20
 class=3D230322006-26072000>H<SPAN=20 class=3D230322006-26072000>TH, <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20
 class=3D230322006-26072000>  <SPAN=20
 class=3DEmailStyle18><SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20

  class=3D230322006-26072000>Anies.</SPAN></SPAN></SPAN></FONT><SPAN=20
  class=3DEmailStyle18><SPAN=20
  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =

12.0pt">
 <SPAN=20 class=3DEmailStyle18><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><FONT=20
 color=3D#0000ff><SPAN=20
 =
class=3D230322006-26072000> =

<SPAN=20 class=3DEmailStyle18><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><FONT=20
 color=3D#0000ff><SPAN=20
 =
class=3D230322006-26072000> <o:p></o:p>=
<FONT=20

 face=3DTahoma>-----Original = Message----- From:=20
 root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of =
Maheshwara Rao,=20

 L., Teki Sent: Wednesday, July 26, 2000 11:27 = AM To:=20
 Multiple recipients of list ORACLE-L Subject: How to kill a = user=20
 active session? </DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> <DIV class=3DSection1>
 <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Hi=20

All,<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Environment=20

: Solaris 2.6 : db version : =
8.0.4<o:p></o:p>

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">One=20

of my developers was accessing the database thru SQL*NET.<SPAN=20 style=3D"mso-spacerun: yes">  He was doing simple = commands (like=20

descry. Table structures, etc) in SQL PLUS.<SPAN=20 style=3D"mso-spacerun: yes">  After some time his = screen=20

hung.  He could not = close the=20

screen.  He ended sql = task=20

through task manager on PC.  =

After this, I queried the table v$session and the following = are the=20

details of v$session table =
query.<o:p></o:p>

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Username=20

– hall   =
:::: sid<SPAN=20

    style=3D"mso-spacerun: yes">&nbsp; </SPAN>-- 13<SPAN=20
    style=3D"mso-spacerun: yes">&nbsp; </SPAN>::::<SPAN=20
    style=3D"mso-spacerun: yes">&nbsp; </SPAN>serial# --5555<SPAN=20
    style=3D"mso-spacerun: yes">&nbsp; </SPAN>:::<SPAN=20
    style=3D"mso-spacerun: yes">&nbsp; </SPAN>status -=20

active<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20

style=3D"mso-spacerun: yes">  I gave the following=20 command.<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20

style=3D"mso-spacerun: =
yes">        =20

ALTER SYSTEM KILL SESSION=20
’13,5555’;<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Now,=20

I got error ---- ORA – 00030 : user session ID does not=20 exist<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">I=20

repeated the above sequence of actions after 5 minutes, i.e., = querying the=20

v$session and then giving the command --- alter system kill=20 session.<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">I=20

got same error message as above. (while the above activity is going = on,=20

other developers were accessing db through SQL<SPAN=20 style=3D"mso-spacerun: yes"> =20 NET).<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">QUESTIONS=20

: <o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<![if !supportLists]><SPAN=20

class=3DEmailStyle18><SPAN =

style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">1.<FONT=20

face=3D"Times New Roman" size=3D1><SPAN=20 style=3D"FONT: 7pt 'Times New =
Roman'">      =20

<![endif]><FONT=20

face=3DArial color=3Dnavy size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Can=20

any body please explain,  why=20

this above error came even when I can see the username, sid and = status as=20

active in v$session.<o:p></o:p> <FONT=20

face=3DArial color=3Dnavy size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<![if !supportLists]><SPAN=20

class=3DEmailStyle18><SPAN =

style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">2.<FONT=20

face=3D"Times New Roman" size=3D1><SPAN=20 style=3D"FONT: 7pt 'Times New =
Roman'">      =20

<![endif]><FONT=20

face=3DArial color=3Dnavy size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Also,=20

please, is there any other way to kill an active user=20 session?<o:p></o:p> <FONT=20

face=3DArial color=3Dnavy size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20

style=3D"mso-spacerun: =
yes">         =20

<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><SPAN=20

style=3D"mso-spacerun: yes"> Thanks in=20 advance,<o:p></o:p> <FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Rao<o:p></o:p>

<FONT face=3DArial = color=3Dnavy=20

size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p>=

<FONT=20

color=3Dnavy><A title=3D"Return = Address"=20

=
href=3D"mailto:teki01_at_mediaone.net">teki01_at_mediaone.net</A></FONT= ><FONT=20

color=3Dnavy><SPAN=20
style=3D"COLOR: navy; mso-color-alt: = windowtext"><o:p></o:p>

<!--[if supportFields]><span = Received on Wed Jul 26 2000 - 07:01:39 CDT