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

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

RE: How to kill a user active session?

From: Anies Yahoo <anies_th_at_yahoo.com>
Date: Wed, 26 Jul 2000 13:24:42 +0700
Message-Id: <10569.112971@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_003C_01BFF704.DB4DC4A0 Content-Type: text/plain;

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

RE: Urgent: NT 8.0.5 restarted after 76 days, now slow

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

  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

------=_NextPart_000_003C_01BFF704.DB4DC4A0 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.2314.1000" 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>
 <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>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 lang=3DEN-US link=3Dblue style=3D"tab-interval: .5in" =
vLink=3Dblue>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2> <P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><SPAN=20
class=3DEmailStyle18><FONT face=3DArial size=3D2><SPAN=20 style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><SPAN=20
class=3D230322006-26072000></SPAN></SPAN></FONT></SPAN>&nbsp;</P> <P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><SPAN=20
class=3DEmailStyle18><FONT face=3DArial size=3D2><SPAN=20 style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt">&gt;<SPAN=20
class=3D230322006-26072000> </SPAN>1.<FONT face=3D"Times New Roman" = size=3D1><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 </SPAN></FONT></SPAN></FONT></SPAN><SPAN class=3DEmailStyle18><FONT = face=3DArial=20
size=3D2><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt">Can any=20
body please explain, <SPAN style=3D"mso-spacerun: yes">&nbsp;</SPAN>why = this above=20
error came even when I can see the username, sid and status as active in =

v$session.</SPAN></FONT></SPAN></P>
<P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><SPAN=20
class=3DEmailStyle18><FONT face=3DArial size=3D2><SPAN=20 style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"></SPAN></FONT></SPAN>&nbsp;</P>
<P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.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,=20 you&nbsp;could kill that session</SPAN></o:p></SPAN></SPAN></P> <P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.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></SPAN></o:p></SPAN></SPAN>&nbsp;</P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN = class=3DEmailStyle18><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt">&gt;<SPAN=20
class=3D230322006-26072000> </SPAN>2.<FONT face=3DArial size=3D2><SPAN=20 style=3D"FONT: 7pt 'Times New =
Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 </SPAN></FONT></SPAN></SPAN><SPAN class=3DEmailStyle18><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 = session?</SPAN></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN = class=3DEmailStyle18><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"></SPAN></SPAN>&nbsp;</P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN = class=3DEmailStyle18><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><SPAN=20
class=3D230322006-26072000></SPAN>u<SPAN class=3D230322006-26072000>se=20 the&nbsp;instance manager (the one of utilities&nbsp;in enterprise=20 manager).</SPAN></SPAN></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN = class=3DEmailStyle18><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><SPAN=20
class=3D230322006-26072000></SPAN></SPAN></SPAN>&nbsp;</P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN = class=3DEmailStyle18><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><SPAN=20

class=3D230322006-26072000></SPAN><SPAN =
class=3D230322006-26072000></SPAN>H<SPAN=20
class=3D230322006-26072000>TH,</SPAN></SPAN></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN = class=3DEmailStyle18><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><SPAN=20
class=3D230322006-26072000></SPAN></SPAN></SPAN>&nbsp;</P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><FONT =
color=3D#0000ff><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"></P></SPAN></SPAN>
<P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><SPAN=20
class=3DEmailStyle18><FONT color=3Dnavy><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></FONT></SPAN></FONT></SPAN>&nbsp;</P> <P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><SPAN=20
class=3DEmailStyle18><FONT color=3Dnavy><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></FONT></SPAN></FONT></SPAN>&nbsp;</P> <P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><SPAN=20
class=3DEmailStyle18><FONT color=3Dnavy><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></FONT></SPAN></FONT></SPAN>&nbsp;</P> <P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><SPAN=20
class=3DEmailStyle18><FONT color=3Dnavy><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>&nbsp;</SPAN><o:p></o:p></FONT></SPAN></FONT><= /SPAN></FONT><FONT=20
face=3DTahoma><FONT size=3D2>-----Original Message-----<BR><B>From:</B>=20 root_at_fatcity.com [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Maheshwara = Rao,=20
L., Teki<BR><B>Sent:</B> Wednesday, July 26, 2000 11:27 AM<BR><B>To:</B> =

Multiple recipients of list ORACLE-L<BR><B>Subject:</B> How to kill a = user=20
active session?<BR><BR></P></FONT></DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"></FONT>
<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt">Environment=20
  : Solaris 2.6 : db version : 8.0.4<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt">One of=20
  my developers was accessing the database thru SQL*NET.<SPAN=20   style=3D"mso-spacerun: yes">&nbsp; </SPAN>He was doing simple commands = (like=20
  descry. Table structures, etc) in SQL PLUS.<SPAN=20   style=3D"mso-spacerun: yes">&nbsp; </SPAN>After some time his screen = hung.<SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>He could not close the = screen.<SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>He ended sql task through = task manager=20
  on PC.<SPAN style=3D"mso-spacerun: yes">&nbsp; </SPAN>After this, I = queried the=20
  table v$session and the following are the details of v$session table=20   query.<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt">Username=20
  &#8211; hall<SPAN style=3D"mso-spacerun: yes">&nbsp;&nbsp; </SPAN>:::: = 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></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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt"><SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>I gave the following=20   command.<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt"><SPAN=20
  style=3D"mso-spacerun: =
yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
</SPAN>ALTER SYSTEM KILL SESSION=20

&#8217;13,5555&#8217;;<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt">Now, I=20
  got error ---- ORA &#8211; 00030 : user session ID does not=20   exist<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 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></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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt">I got=20
  same error message as above. (while the above activity is going on, = other=20
  developers were accessing db through SQL<SPAN style=3D"mso-spacerun: = yes">&nbsp;=20
</SPAN>NET).<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt">QUESTIONS=20
  : <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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal=20

  style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><![if !supportLists]><SPAN=20   class=3DEmailStyle18><FONT color=3Dnavy face=3DArial size=3D2><SPAN=20   style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
</SPAN></FONT></SPAN></FONT></SPAN><![endif]><SPAN =
class=3DEmailStyle18><FONT=20
  color=3Dnavy face=3DArial size=3D2><SPAN=20   style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt">Can=20
  any body please explain, <SPAN style=3D"mso-spacerun: = yes">&nbsp;</SPAN>why this=20
  above error came even when I can see the username, sid and status as = active in=20
  v$session.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN =
class=3DEmailStyle18><FONT=20
  color=3Dnavy face=3DArial size=3D2><SPAN=20   style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal=20

  style=3D"MARGIN-LEFT: 27pt; TEXT-INDENT: -0.25in; mso-list: l10 level1 = lfo12; tab-stops: list 27.0pt"><![if !supportLists]><SPAN=20   class=3DEmailStyle18><FONT color=3Dnavy face=3DArial size=3D2><SPAN=20   style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
</SPAN></FONT></SPAN></FONT></SPAN><![endif]><SPAN =
class=3DEmailStyle18><FONT=20
  color=3Dnavy face=3DArial size=3D2><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?<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 9pt"><SPAN =
class=3DEmailStyle18><FONT=20
  color=3Dnavy face=3DArial size=3D2><SPAN=20   style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: = 12.0pt"><SPAN=20
  style=3D"mso-spacerun: =
yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
</SPAN><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: = 12.0pt"><SPAN=20
  style=3D"mso-spacerun: yes">&nbsp;</SPAN>Thanks in=20   advance,<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: = 12.0pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><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: = 12.0pt">Rao<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: = 12.0pt"><![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=20
  color=3Dnavy><SPAN style=3D"COLOR: navy"><A = href=3D"mailto:teki01_at_mediaone.net"=20
  title=3D"Return Address">teki01_at_mediaone.net</A></SPAN></FONT><FONT=20
  color=3Dnavy><SPAN=20
  style=3D"COLOR: navy; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><!--[if supportFields]><span =
Received on Wed Jul 26 2000 - 01:24:42 CDT

Original text of this message

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