ORA-01652: unable to extend temp segment by 512 in tablespace TEMP 
Author Message
 ORA-01652: unable to extend temp segment by 512 in tablespace TEMP
Can anyone help me with a formula/method for estimating a good size for temp
tablespace.  Thanks.

 -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web  -----
  http://www.***.com/ ,000+ groups
   NewsOne.Net prohibits users from posting spam.  If this or other posts



Sat, 22 May 2004 10:39:49 GMT
 ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

Quote:

> Can anyone help me with a formula/method for estimating a good size for temp
> tablespace.  Thanks.

>  -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web  -----
>   http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups

I lack a good set of rules for this as we have more or less gone with
a gut feel about how much space we need.  Some things you can think
about:

1- you need to allocate enough space to temp to allow droping and
re-creating your largest index.

2- Some people have said that you need at least enough to allow
someone to "select * from largest_table order by x" but I am not sure
you have to allow selecting all the rows from your largest table in a
specific order. In theory you should be able to support this, but in
many applications this is an unrealistic situation.

3- If you have an existing system or access to similar systems look to
see what they are using during peak online and peak batch activity
times.

Good luck

-- Mark D Powell --



Sat, 22 May 2004 22:18:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

2. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

3. ORA-01652 unable to extend temp segment by num in tablespace name

4. ORA-01652: unable to extend temp segment by 1598 in tablespace

5. ORA-01652: unable to extend temp segment by 1598 in tablespace

6. 01652: unable to extend temp segment

7. extend temp segment - ora 01652

8. ORA-1652: unable to extend temp segment by 7680 in tablespace

9. ORA-1652: unable to extend temp segment by 8192 in tablespace

10. TEMP tablespace, resizing (ORA-01652)

11. ORA-1652: unable to extend temp segment

12. temp segment in non-temp tablespace??


 
Powered by phpBB® Forum Software