Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to kill a user active session?

How to kill a user active session?

From: Maheshwara Rao, L., Teki <teki01_at_mediaone.net>
Date: Tue, 25 Jul 2000 23:23:50 -0400
Message-Id: <10569.112962@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0036_01BFF68F.63ACF9E0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

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 :

  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.
  2. 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_000_0036_01BFF68F.63ACF9E0 Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml_at_01BFF68F.6383C700">
<title>RE: Urgent: NT 8.0.5 restarted after 76 days, now slow</title>
<!--[if gte mso 9]><xml>

 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>

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

 </w:WordDocument>
</xml><![endif]-->
<style>
<!--

 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
p
	{margin-right:0in;
	mso-margin-top-alt:auto;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
	{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;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}

 /* List Definitions */
@list l0
	{mso-list-id:-132;
	mso-list-type:simple;
	mso-list-template-ids:-89516842;}
@list l0:level1
	{mso-level-tab-stop:1.25in;
	mso-level-number-position:left;
	margin-left:1.25in;
	text-indent:-.25in;}
@list l1
	{mso-list-id:-131;
	mso-list-type:simple;
	mso-list-template-ids:-1712704604;}
@list l1:level1
	{mso-level-tab-stop:1.0in;
	mso-level-number-position:left;
	margin-left:1.0in;
	text-indent:-.25in;}
@list l2
	{mso-list-id:-130;
	mso-list-type:simple;
	mso-list-template-ids:1360706354;}
@list l2:level1
	{mso-level-tab-stop:.75in;
	mso-level-number-position:left;
	margin-left:.75in;
	text-indent:-.25in;}
@list l3
	{mso-list-id:-129;
	mso-list-type:simple;
	mso-list-template-ids:-1964234868;}
@list l4
	{mso-list-id:-128;
	mso-list-type:simple;
	mso-list-template-ids:1238137330;}
@list l4:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:1.25in;
	mso-level-number-position:left;
	margin-left:1.25in;
	text-indent:-.25in;
	font-family:Symbol;}
@list l5
	{mso-list-id:-127;
	mso-list-type:simple;
	mso-list-template-ids:498472216;}
@list l5:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:1.0in;
	mso-level-number-position:left;
	margin-left:1.0in;
	text-indent:-.25in;
	font-family:Symbol;}
@list l6
	{mso-list-id:-126;
	mso-list-type:simple;
	mso-list-template-ids:-220051398;}
@list l6:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:.75in;
	mso-level-number-position:left;
	margin-left:.75in;
	text-indent:-.25in;
	font-family:Symbol;}
@list l7
	{mso-list-id:-125;
	mso-list-type:simple;
	mso-list-template-ids:-75738068;}
@list l7:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;
	font-family:Symbol;}
@list l8
	{mso-list-id:-120;
	mso-list-type:simple;
	mso-list-template-ids:1601616800;}
@list l8:level1
	{mso-level-tab-stop:.25in;
	mso-level-number-position:left;
	margin-left:.25in;
	text-indent:-.25in;}
@list l9
	{mso-list-id:-119;
	mso-list-type:simple;
	mso-list-template-ids:-1570710152;}
@list l9:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:.25in;
	mso-level-number-position:left;
	margin-left:.25in;
	text-indent:-.25in;
	font-family:Symbol;}
@list l10
	{mso-list-id:1716612671;
	mso-list-type:hybrid;
	mso-list-template-ids:450914390 1550495988 67698713 67698715 67698703 =
67698713 67698715 67698703 67698713 67698715;} @list l10:level1
	{mso-level-tab-stop:27.0pt;
	mso-level-number-position:left;
	margin-left:27.0pt;
	text-indent:-.25in;}
ol
	{margin-bottom:0in;}
ul
	{margin-bottom:0in;}

-->
</style>
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Hi=  All,<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>En= vironment
: Solaris 2.6 : db version : 8.0.4<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>On= e of my
developers was accessing the database thru SQL*NET.<span = style=3D"mso-spacerun:
yes">&nbsp; </span>He was doing simple commands (like descry. Table = structures,
etc) in SQL PLUS.<span style=3D"mso-spacerun: yes">&nbsp; </span>After = some time
his screen hung.<span style=3D"mso-spacerun: yes">&nbsp; </span>He could = not
close the screen.<span style=3D"mso-spacerun: yes">&nbsp; </span>He = ended sql
task through task manager on PC.<span style=3D"mso-spacerun: yes">&nbsp;
</span>After this, I queried the table v$session and the following are =
the
details of v$session table query.<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Us= ername &#8211;
hall<span style=3D"mso-spacerun: yes">&nbsp;&nbsp; </span>:::: sid<span

style=3D"mso-spacerun: yes">&nbsp; </span>-- 13<span =
style=3D"mso-spacerun:
yes">&nbsp; </span>::::<span style=3D"mso-spacerun: yes">&nbsp; =

</span>serial#

--5555<span style=3D"mso-spacerun: yes">&nbsp; </span>:::<span style=3D"mso-spacerun: yes">&nbsp; </span>status - = active<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><s= pan
style=3D"mso-spacerun: yes">&nbsp; </span>I gave the following = command.<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><s= pan
style=3D"mso-spacerun: =
yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>ALTER SYSTEM KILL SESSION =

&#8217;13,5555&#8217;;<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>No= w, I got
error ---- ORA &#8211; 00030 : user session ID does not = exist<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>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.<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>I = got same
error message as above. (while the above activity is going on, other = developers
were accessing db through SQL<span style=3D"mso-spacerun: yes">&nbsp;
</span>NET).<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>QU= ESTIONS
: <o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal =

style=3D'margin-left:27.0pt;text-indent:-.25in;mso-list:l10 level1 = lfo12;
tab-stops:list 27.0pt'><![if !supportLists]><span = class=3DEmailStyle18><font
size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>1.<font size=3D1 face=3D"Times New = Roman"><span
style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font></span></font></span><![endif]><span
class=3DEmailStyle18><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Can any body please = explain,
<span style=3D"mso-spacerun: yes">&nbsp;</span>why this above error came =
even
when I can see the username, sid and status as active in = v$session.<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal style=3D'margin-left:9.0pt'><span =
class=3DEmailStyle18><font
size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal =

style=3D'margin-left:27.0pt;text-indent:-.25in;mso-list:l10 level1 = lfo12;
tab-stops:list 27.0pt'><![if !supportLists]><span = class=3DEmailStyle18><font
size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>2.<font size=3D1 face=3D"Times New = Roman"><span
style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font></span></font></span><![endif]><span
class=3DEmailStyle18><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Also, please, is = there any
other way to kill an active user =
session?<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal style=3D'margin-left:9.0pt'><span =
class=3DEmailStyle18><font
size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'><span style=3D"mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><s= pan
style=3D"mso-spacerun: yes">&nbsp;</span>Thanks in = advance,<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Ra= o<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!= [if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoAutoSig><!--[if supportFields]><span =
class=3DEmailStyle18><font=20
size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'><span =
style=3D'mso-element:field-begin'></span><span=20 style=3D"mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail=20 Signature&quot; <span =
style=3D'mso-element:field-separator'></span></span></font></span><![endi= f]--><font
color=3Dnavy><span style=3D'color:navy'><a = href=3D"mailto:teki01_at_mediaone.net"

title=3D"Return Address">teki01_at_mediaone.net</a></span></font><font =
color=3Dnavy><span
style=3D'color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></=
p>

<p class=3DMsoNormal><!--[if supportFields]><span =
class=3DEmailStyle18><font=20 Received on Tue Jul 25 2000 - 22:23:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US