Re: reg. problem with Temp Tablespace

From: DB Dule <>
Date: Sat, 29 Dec 2007 05:45:00 -0800 (PST)
Message-ID: <>

On Dec 29, 2:13 am, calms <> wrote:
> Hi,
> Currently im using 17gb for temp tablespace.
> fyi, mine is oracle datawarehouse with 1.5 TB of data.
> I increased the temp tablespace with 8gb of space. but again im getting the same error.

how is the explain plan of currently running queries? Either a query is processing huge number of rows in DW env or query is doing cartesian join. Have you turned on start transformation since this is DW?
I have seen cartesian product query was chewing up 8 gig of Temp space that was fired against a 800 MB schema tables. Received on Sat Dec 29 2007 - 07:45:00 CST

Original text of this message