Re: Full table scans

www.ixora.com.au
expensive_sql
suspicous_sql
will identify the heaviest sql statements disk-wise and memory-wise

else statspack, or v$sql

On Tue, 06 May 2003 11:21:02 GMT, Kalle <kminerva_at_jippii.fi> wrote:

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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed May 07 2003 - 16:03:10 CDT