Re: User using the most resources

From: Richard Karsch <r.karsch_at_tu-bs.de>
Date: Fri, 19 Jan 2001 23:29:57 +0100
Message-ID: <3A68BFE4.AAF28197@tu-bs.de>

hi Anurag,

maybe you are looking for something like:

select A.User_Name, B.Disk_Reads, B.Buffer_Gets, B.Rows_Processed, C.SQL_Text
from V$Open_Cursor A, V$SQLArea B, V$SQLText C where A.User_Name=Upper('&&User')
and A.Address = C.Address
and A.Address = B.Address
order by A.User_Name, A.Address, C.Piece;

regards Richard

anuragmin_at_my-deja.com wrote:

> Hi,
> I am using oracle 8.0.5 on wondows NT. Is there a script which will
> give the most resource intensive sql and also the user executing it.
>
> Thanks in advance
> Anurag
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 19 2001 - 16:29:57 CST