[askdba] Re: Malfunctioning Session
- From: "Irfan Khan" <irfan.khan@xxxxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Wed, 27 Oct 2004 08:14:40 -0400
Hi Sanjay,
Just a thought
If u dont know who is the user and what machine, How will u know that =
something has gone in infinite loop on the first hand?
Regards
Irfan Khan
-----Original Message-----
From: sanjay.khangarot@xxxxxxxxx [mailto:sanjay.khangarot@xxxxxxxxx]
Sent: Wednesday, October 27, 2004 7:03 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Malfunctioning Session
Suppose I have 10 session connected to a database and out of the 10, in =
one=3D
session some one wrote an infinite loop...=3D0D
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 ...=3D0D
On Wed, 27 Oct 2004 16:03:53 +0530, sanjay.khangarot@xxxxxxxxx
<sanjay.khangarot@xxxxxxxxx> wrote:
>=3D0D
> Hi,
> It is for my understanding..
>=3D0D
> I was just simulating my system for some waits, and wanted to know =
that=3D
how=3D3D
> can I figure out which session is malfunctioning?I have tried to go =
with=3D
=3D3D
> v$session_wait but it does not give me the info about the session =
which=3D
is=3D3D
> consuming maximum resources, and I can not go for the v$sesstat as I =
do=3D
=3D3D
> not know what are the resource consumed by the session?
>=3D0D
> Confidentiality Notice=3D3D0D
>=3D0D
> The information contained in this electronic message and any =
attachments=3D
to=3D3D
> this message are intended
> for the exclusive use of the addressee(s) and may contain confidential =
or=3D
=3D3D
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro =
or=3D
=3D3D
> Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
>=3D0D
>
Confidentiality Notice=3D0D
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.
Other related posts:
