[askdba] Re: Malfunctioning Session
- From: <sanjay.khangarot@xxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Thu, 28 Oct 2004 09:10:59 +0530
Well suppose in a real system environ I have one application who authorises=
the users on the basis of the rights provided in the tables ( not oracle=
users) but generic user and in the application we need to check the privs=
to them.
The user are allowed to generate the run time query.. and can execute=
those.
As I have stated it may be an infinite loop generated by a user, or a bad=
behaving sql which affecting the performace. I need to pick that session=
and need to kill it..
I was just trying to simulate an environ and wanted to figure out how can I=
pick the session and kill it? It was just one trial to understand better=
the dynamic performace views and to correlate the info available there.=0D
I had moved on the various options like=0D
Picking of the sql from v$sql on the basis of CPU_TIME can figure out which=
is the sql consuming max time, but from there how can I reach to the=
Session level.. still not able to resolve..
If someone has any Idea ( Ganesh Already pointed out one), just let me=
know...
till the time I will keep experimeting :)
Regards=0D
Sanjay=0D
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On
Behalf Of Irfan Khan
Sent: Wednesday, October 27, 2004 5:45 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Malfunctioning Session
Hi Sanjay,
Just a thought
If u dont know who is the user and what machine, How will u know that =3D
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 =3D
one=3D3D
session some one wrote an infinite loop...=3D3D0D
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 ...=3D3D0D
On Wed, 27 Oct 2004 16:03:53 +0530, sanjay.khangarot@xxxxxxxxx
<sanjay.khangarot@xxxxxxxxx> wrote:
>=3D3D0D
> Hi,
> It is for my understanding..
>=3D3D0D
> I was just simulating my system for some waits, and wanted to know =3D
that=3D3D
how=3D3D3D
> can I figure out which session is malfunctioning?I have tried to go =3D
with=3D3D
=3D3D3D
> v$session_wait but it does not give me the info about the session =3D
which=3D3D
is=3D3D3D
> consuming maximum resources, and I can not go for the v$sesstat as I =3D
do=3D3D
=3D3D3D
> not know what are the resource consumed by the session?
>=3D3D0D
> Confidentiality Notice=3D3D3D0D
>=3D3D0D
> The information contained in this electronic message and any =3D
attachments=3D3D
to=3D3D3D
> this message are intended
> for the exclusive use of the addressee(s) and may contain confidential =
=3D
or=3D3D
=3D3D3D
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro =3D
or=3D3D
=3D3D3D
> Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
>=3D3D0D
>
Confidentiality Notice=3D3D0D
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 =3D
or=3D3D
privileged information. If
you are not the intended recipient, please notify the sender at Wipro =3D
or=3D3D
Mailadmin@xxxxxxxxx immediately
and destroy all copies of this message and any attachments.
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:
