Re: Active sql statement

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 17 Feb 1999 21:32:49 -0000
Message-ID: <919287243.15865.2.nnrp-01.9e984b29@news.demon.co.uk>

Look on my website under '3 scripts to cover all your tuning'. V$sqlarea/v$sql is the dynamic performance table you need to query.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Serge Montet wrote in message <7afbf3$du0$1_at_platane.wanadoo.fr>...
> 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 Wed Feb 17 1999 - 15:32:49 CST