[askdba] Re: Malfunctioning Session

  • From: <sanjay.khangarot@xxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Wed, 27 Oct 2004 16:32:49 +0530

Suppose I have 10 session connected to a database and out of the 10, in one=
 session some one wrote an infinite loop...=0D
now I wanted to get that session ID to kill it.
I do not know anything about the user or m/c etc..




-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On
Behalf Of Ganesh Raja
Sent: Wednesday, October 27, 2004 4:28 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Malfunctioning Session


Totally Lost here .. What are u trying to do ...=0D


On Wed, 27 Oct 2004 16:03:53 +0530, sanjay.khangarot@xxxxxxxxx
<sanjay.khangarot@xxxxxxxxx> wrote:
>=0D
> Hi,
> It is for my understanding..
>=0D
> I was just simulating my system for some waits, and wanted to know that=
 how=3D
>  can I figure out which session is malfunctioning?I have tried to go with=
=3D
>  v$session_wait but it does not give me the info about the session which=
 is=3D
>  consuming maximum resources, and I can not go for the v$sesstat as I do=
=3D
>  not know what are the resource consumed by the session?
>=0D
> Confidentiality Notice=3D0D
>=0D
> The information contained in this electronic message and any attachments=
 to=3D
>  this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or=
=3D
>  privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or=
=3D
>  Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
>=0D
>




Confidentiality Notice=0D

The information contained in this electronic message and any attachments to=
 this message are intended
for the exclusive use of the addressee(s) and may contain confidential or=
 privileged information. If
you are not the intended recipient, please notify the sender at Wipro or=
 Mailadmin@xxxxxxxxx immediately
and destroy all copies of this message and any attachments.

Other related posts: