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

First of all:

Is your temp tablespace really a temporary one ? Check the CONTENTS of it in DBA_TABLESPACES

If it isn't make it temporary.

If it is then check your SORT init.ora parameters. Perhaps you can try out something there.

Furthermore, if some tables are large and your applications do FULL TABLE SCANS on them, make your INITIAL parameter in your temp tablespace about the size of these tables. For NEXT I would suggest 1M.

In other words: creating new datafiles isn't always the answer.

Roelof

<u191833496_at_spawnkill.ip-mobilphone.net> schreef in bericht 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 - 04:38:38 CST