Re: Full table scans

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 06 May 2003 22:52:54 +0800
Message-ID: <3EB7CC46.3855@yahoo.com>

Kalle wrote:
>
> Hi all,
>
> how I am able to locate the worst possible sql-statements from sga..
>
> Merci Beaucoup...
>
> Kalle

select *
from v$sql
where (anything thats important to you)

eg

buffer_gets > ...
executions > ...
disk_reads > ...

rows_processed > ...
elapsed_time > ...

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"

Received on Tue May 06 2003 - 09:52:54 CDT