Re: Fast Growing TEMP tablespace

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 07 Dec 1999 12:51:02 -0500
Message-ID: <384D4906.41B82A78@Unforgettable.com>

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

One thing that could cause it is a cartesian join of several tables. Beyond that, be wary of any joins in the applications. Test them out in sqlplus to see if they use a lot of temp tablespace. Well-behaved applications normally won't cause the growth that you are reporting.

What type of jobs is this? PL/SQL? PRO-C? OCI? VB? There are lots of things that can go wrong and you'd need to say more about the design of the app before anyone here can really be of much help. Received on Tue Dec 07 1999 - 11:51:02 CST