Re: How to estimate the size of temp segment required?

u191833496_at_spawnkill.ip-mobilphone.net wrote:
>
> Hello,
>
> I have a complicated and clumsy :( query that causes ORA-01652:
> unable to extend temp segment by 12137 in tablespace TEMP.
> I know this can be resolved by adding datafile to the temp tablespace.
> The problem is that I have added serveral times but still see the
> problem. Is there any way to estimate the requirement on the temp
> tablespace, except by setting to the tablespace to autoextend and
> see how large it grows? I know the structures of the tables
> and the number of rows in the tables. Or is there any method of
> minimizing the requirement of temp tablespace? I have tried to
> read the oracle docs but could not find the information :(
>
> Anthony Tsang
>
>
> --
> Sent by thtsang from my-deja part of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new

Try setting events (I think) 10032 or 10033 - this will tell you info about sorts

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"