Re: TEMPORARY tablespace problem -- newbie problems

From: rob van laarhoven <rob_at_dsdelft.nl>
Date: 2000/06/14
Message-ID: <#YGePTe1$GA.302@net003s>#1/1

> My assumption was that the temporary tablespace was, in fact, temporary
 and
> that when a query or process completed it would release any objects that
> Oracle created, thereby freeing the space for use by another process. Is
> this wrong?

No, I think you are right.
Your queries simply fill up all the available space.

- rewrite the queries to be more efficient
- make the temporary tablespace bigger
- create more temp tablespaces. A big one for users that run 'big queries'

and one for normal users. In this case the normal users don't run out of temp space because someone is running a 'monster-query'

>
> Any help would be appreciated, as I am being hammered by a large client on
> this.
>
> Thanks.
>
> Rob
>
>
Received on Wed Jun 14 2000 - 00:00:00 CDT