Re: sorting out to disk - question

1)Identify the sql statements in you application code which returns many rows AND which require sorting. These are the most likely to cause disk sorts.

2)Query v$sqlarea again :
Those SQL statement that show a high number of sorts in v$sqlarea are probably the ones causing disk sorts.

3) Use SQL_TRACE followed by TKPROF could also give you some hints.

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com

On Wed, 22 Aug 2001 14:17:54 -0400, mlm <nunya_at_business.com> wrote:

>Oracle 8.0.5.25
>NT 4.0 SP6
>1 GB RAM
>
>I've determined that we have some sorting to disk going on in the
>database. How can I find out what SQL statements are causing this?
>I've checked v$sqlarea, and there is a column that gives you the number
>of sorts for a particular query, but it doesn't specifiy whether it's a
>memory or disk sort.
>
>Any ideas?
>
>Thanks,
>mm
>
Received on Wed Aug 22 2001 - 13:44:42 CDT