Re: reg. problem with Temp Tablespace
From: DB Dule <DBdude_From_NY_at_yahoo.com>
Date: Sat, 29 Dec 2007 05:45:00 -0800 (PST)
Message-ID: <959fbecd-f0ea-400b-a1ec-4bea669c1381@d4g2000prg.googlegroups.com>
Date: Sat, 29 Dec 2007 05:45:00 -0800 (PST)
Message-ID: <959fbecd-f0ea-400b-a1ec-4bea669c1381@d4g2000prg.googlegroups.com>
On Dec 29, 2:13 am, calms <calmsqur..._at_gmail.com> 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