Re: Help! Hung Process

From: David Sisk <davesisk_at_ipass.net>
Date: Fri, 30 Jul 1999 10:44:25 -0400
Message-ID: <AJio3.494$tp2.193@news.ipass.net>

Hi:

Look in the V$SESSION_WAITS dynamic view for info on a particular session.
For instance level measures, download the CheckTuning.sql script from my site below. (It's under the downloads section. You might want to read the section on Performance->Instance as well.)

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

sjoshi_at_ingr.com wrote in message <7ns8b2$cnu$1_at_nnrp1.deja.com>...
>Hello All
> I was just wondering if there is a way to tell which user process
>has hung up in Oracle, at what event(Select,Update) and how long it's
>been running. Also how can I get statistics on processes like memory,
>hit ratios, etc.
>
>thanks
>Sunit
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 30 1999 - 09:44:25 CDT