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 :

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

On= e 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.<o:p></o:p>

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

serial#

--5555  :::  status - = active<o:p></o:p>

<s= pan
style=3D"mso-spacerun: =
yes">        
ALTER SYSTEM KILL SESSION =

’13,5555’;<o:p></o:p>

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>

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

<![if !supportLists]>1.       =
<![endif]><span
class=3DEmailStyle18>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.<o:p></o:p>

<![if =
!supportEmptyParas]> <![endif]><o:p></o:p>

<![if !supportLists]>2.       =
<![endif]><span
class=3DEmailStyle18>Also, please, is = there any
other way to kill an active user =
session?<o:p></o:p>

          =
<o:p></o:p>

<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></=

<!--[if supportFields]><font=20 Received on Tue Jul 25 2000 - 22:23:50 CDT