Re: reg. problem with Temp Tablespace

calms wrote:
> Hi,
>
> Currently im using 17gb for temp tablespace.
> Im received a error stating, "cannot allocate temp segment for temp
> tablespace".
> I increased the temp tablespace with 8gb of space. but again im
> getting the same error.
>
> Can somebody plz suggest, what should be done, or how to determine the
> size of temp tablespace.
>
> fyi, mine is oracle datawarehouse with 1.5 TB of data.
>
> thks

Run EXPLAIN PLAN on your query as follows: EXPLAIN PLAN SET STATEMENT_ID = 'AAA' FOR <your query here>

Then output the results as follows:
SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','AAA','ALL'));

Post the result along with your complete version number.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org