Re: How to kill a user active session?

From: Scott Shafer <scott.shafer_at_ildmail.com>
Date: Wed, 26 Jul 2000 09:27:58 -0500
Message-Id: <10570.113010@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0074_01BFF6E3.C99AAEB0 Content-Type: text/plain;

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

RE: Urgent: NT 8.0.5 restarted after 76 days, now slowIf you are using =

MTS, one of your shared servers is holding the session.  If you can kill =
the shared server at the OS level (it will respawn itself as needed) the =
session will disappear from the v$session view.  I have seen this happen =

quite often on O7.3.x when someone terminated a client app connection = non-gracefully (like a power outage in the middle of a large SQL = Navigator retrieval).

Scott Shafer
San Antonio, TX

Original Message -----=20 From: Koivu, Lisa=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, July 26, 2000 8:03 AM Subject: RE: How to kill a user active session?

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?

=20

> 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.

=20

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

=20

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

=20

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

=20

HTH,
=20

Anies.

=20

-----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,

=20

Environment : Solaris 2.6 : db version : 8.0.4

=20

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.

=20

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

=20

I gave the following command.

=20

ALTER SYSTEM KILL SESSION '13,5555'; =20

Now, I got error ---- ORA - 00030 : user session ID does not exist

=20

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.

=20

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

=20

QUESTIONS :=20 =20

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.

=20

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

=20

Thanks in advance,

=20

Rao

=20

teki01_at_mediaone.net

=20

------=_NextPart_000_0074_01BFF6E3.C99AAEB0 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><TITLE>RE: Urgent: NT = 8.0.5 restarted after 76 days, now slow</TITLE> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type>

<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 5.00.3105.105" 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-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" }
LI.MsoNormal {

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

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

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

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

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN-LEFT: 0in; = MARGIN-RIGHT: 0in; 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 bgColor=3D#ffffff lang=3DEN-US link=3Dblue style=3D"tab-interval: =

.5in"=20
vLink=3Dblue>
<DIV>If you are using MTS, one of your shared servers is = holding=20
the session.  If you can kill the shared server at the OS level (it = will=20
respawn itself as needed) the session will disappear from the v$session=20 view.  I have seen this happen quite often on O7.3.x when someone=20 terminated a client app connection non-gracefully (like a power outage = in the=20
middle of a large SQL Navigator retrieval).</DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>Scott Shafer</FONT></DIV>
<DIV><FONT size=3D2>San Antonio, TX</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A href=3D"mailto:lkoivu_at_qode.com" title=3Dlkoivu_at_qode.com>Koivu, = Lisa</A> </DIV>
 <DIV style=3D"FONT: 10pt arial">To: <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
 title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Wednesday, July 26, 2000 = 8:03=20
 AM</DIV>
 <DIV style=3D"FONT: 10pt arial">Subject: RE: How to kill a user = active=20
 session?</DIV>
 <DIV> </DIV>
 <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 align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20

size=3D2>-----Original Message----- From: Anies Yahoo [<A=20
=

href=3D"mailto:anies_th_at_yahoo.com">mailto:anies_th_at_yahoo.com</A>] S= ent:=20

Wednesday, July 26, 2000 3:34 AM To: Multiple recipients = of list=20

ORACLE-L Subject: RE: How to kill a user active=20 session? </DIV>
 <DIV> <SPAN=20

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

class=3D230322006-26072000>  <SPAN=20

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

class=3D230322006-26072000> 1.<SPAN=20

style=3D"FONT: 7pt 'Times New =
Roman'">      =20

<FONT = face=3DArial=20

size=3D2><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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. <SPAN=20

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

<SPAN=20

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

class=3D230322006-26072000>when you see the session_id in v$session, =

you could kill that session</o:p> <SPAN=20

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

class=3D230322006-26072000></o:p>  <SPAN=20

style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt">

<SPAN=20

style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><SPAN=20

class=3D230322006-26072000>  <SPAN=20

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

class=3D230322006-26072000>H<SPAN=20

class=3D230322006-26072000>TH, <SPAN=20

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

class=3D230322006-26072000>  <SPAN=20

class=3DEmailStyle18><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: =

12.0pt">

<SPAN=20

class=3DEmailStyle18><SPAN=20 style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><FONT=20

color=3D#0000ff><SPAN=20
=

class=3D230322006-26072000> <o:p></o:p><= /SPAN><FONT=20

face=3DTahoma>-----Original = Message----- From:=20

root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of = Maheshwara=20

Rao, L., Teki Sent: Wednesday, July 26, 2000 11:27=20 AM To: Multiple recipients of list = ORACLE-L Subject: How=20

to kill a user active session? </DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">

      <DIV class=3DSection1>
      <P class=3DMsoNormal><SPAN class=3DEmailStyle18><FONT color=3Dnavy =
face=3DArial=20
      size=3D2><SPAN=20
      style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Hi=20
      All,<o:p></o:p></SPAN></FONT></SPAN></P>
      <P class=3DMsoNormal><SPAN class=3DEmailStyle18><FONT color=3Dnavy =
face=3DArial=20
      size=3D2><SPAN=20
      style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: =