[askdba] Re: Malfunctioning Session
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Wed, 27 Oct 2004 11:57:38 +0100
Totally Lost here .. What are u trying to do ...
On Wed, 27 Oct 2004 16:03:53 +0530, sanjay.khangarot@xxxxxxxxx
<sanjay.khangarot@xxxxxxxxx> wrote:
>
> Hi,
> It is for my understanding..
>
> I was just simulating my system for some waits, and wanted to know that how=
> can I figure out which session is malfunctioning?I have tried to go with=
> v$session_wait but it does not give me the info about the session which is=
> consuming maximum resources, and I can not go for the v$sesstat as I do=
> not know what are the resource consumed by the session?
>
> 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:
