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

guideline:
2 times the number of bytes per row times the number of rows in your biggest index.
Adding a datafile should only been done if the disk fills up. You also should take an exact number of extents fits in your datafile.

Hth,

Sybrand Bakker, Oracle DBA

<u191833496_at_spawnkill.ip-mobilphone.net> wrote in message news:l.985234641.1655517578@[203.193.9.2]...
> 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
Received on Thu Mar 22 2001 - 00:40:07 CST