Re: Temporary tablespace fills up

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 17 Jul 2001 16:46:26 +0100
Message-ID: <995384754.27070.0.nnrp-08.c30bdde2@news.demon.co.uk>

temporary tablespace is supposed to be full. Nothing to do with SGA as you say.

A tiptoe through the temptbsp documentation wouldn't go amiss.... ;-)

"traceable1" <traceable1_at_hotmail.com> wrote in message news:8551d8c9.0107170705.d3b727b_at_posting.google.com...
> We were having problems in 8.1.7 (or any 8i) with the TEMPORARY
> tablespace filling up. It didn't matter how big it was - the query
> would run until the TEMP space filled up. v$sort_segment would report
> that the space was free, but it would not allocate it. The process
> would run okay after restarting the database - I think the SGA needed
> to clear out.
> Anyway, the problem was solved by getting rid of the Parallel Query.
> At the beginning of the query, I set each table involved:
> ALTER TABLE [table_x] PARALLEL (DEGREE 1 INSTANCES 1);
Received on Tue Jul 17 2001 - 10:46:26 CDT