Re: reg. problem with Temp Tablespace
Date: Sat, 29 Dec 2007 05:45:00 -0800 (PST)
On Dec 29, 2:13 am, calms <calmsqur..._at_gmail.com> wrote:
> 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
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