Re: Fast Growing TEMP tablespace

Garsen Subramoney wrote:
>
> Hi
>
> One of our developers has developed a procedure that gows my TEMP tablespace
> at an enormous rate (my TEMP goes from 200 MB to 800MB in half an hour.)
>
> The effect of this is that the whole database which is running on an RS6000
> is brought almost to a shutdown.
>
> What type of proces can cause this much damage? Could bad use of cursors
> lead to such damage?
>
> Thanks

Search for ORDER BY, GROUP BY or SELECT DISTINCT (when it is not necessary. This is a common newbie error).

Kai
--
$f

Unix, WinNT and MS-DOS. The Good, The Bad and The Ugly. Kai Poitschke MailTo:kai.poitschke[at]computer.org Date/Time: $d/$t Received on Tue Dec 07 1999 - 11:37:38 CST