Re: Active sql statement

download TOAD from www.toadsoft.com for a free utility that will show you this info in a nice grid.

-Rick

HItesh Patel <hpatel_at_pathcom.com> wrote in article <36CC9257.D1329953_at_pathcom.com>...
> Try this.
>
> select disk_reads,sql_text,user_executing from v$sqlarea
> where user_executing != 0
> order by disk_reads;
>
> This query will show you the most IO intensive queries which are running
> now. Though the disk_reads might be sum total since last load_time of the
> sql in the shared pool.
>
> I hope this helps,
> Thanks,
> Hitesh Patel
>
> Serge Montet wrote:
>
> > Hello,
> >
> > I am searching for a script which can show to me the most intensive
SQL
> > (in term of IO and/or CPU) statements in my database ?
> > Sure someone has got it!
> >
> > Thanks.
>
>
Received on Sun Feb 21 1999 - 12:01:04 CST