do a watch in the /tmp directory and see how big the sort file grows.

something like "watch -n 1 -d 'ls -l'" should work

-steve

Rick Debay wrote:

>
> And it's only this query, some people have run ridiculously stupid
> queries that took hours and returned result sets with hundreds of
> thousands of rows, and this error didn't occur.
>
> Disclaimer: This message (including attachments) is confidential and
> may be privileged. If you have received it by mistake please notify
> the sender by return e-mail and delete this message from your system.
> Any unauthorized use or dissemination of this message in whole or in
> part is strictly prohibited. Please note that e-mails are susceptible
> to change. RxStrategies, Inc. shall not be liable for the improper or
> incomplete transmission of the information contained in this
> communication or for any delay in its receipt or damage to your
> system. RxStrategies, Inc. does not guarantee that the integrity of
> this communication has been maintained nor that this communication is
> free from viruses, interceptions or interference.
>
>