Re: Active sql statement

From: HItesh Patel <hpatel_at_pathcom.com>
Date: Thu, 18 Feb 1999 14:21:11 -0800
Message-ID: <36CC9257.D1329953@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 Thu Feb 18 1999 - 16:21:11 CST