temp extent size for DMT

I read Oracle Doc recommendation that the best extent size for TEMP tablespace (DMT) is sort_area_size (or multiple) + db_block_size. When i applied this to my DB 5 minutes later it hit an error.. unable to extent tablespace TEMP.... when i change back to original extent sizinh which is 520k, the db running with no error.
DB 8.1.7 on Solaris
Any idea on this?

So what size did you change it to?

changed to sort_area_size + db_block_size
first time
524288*2 + 8192 = 1056768 <- hit error
second time
524288 + 8192 = 532480 <- also hit error

now init 520k next 520k..
so far 2 week runnign without any problem... any idea slimdave?

i suspect if you may have specified 1056768 K or M?

Quote:

---

Originally posted by abhaysk
i suspect if you may have specified 1056768 K or M?

---

i did't specify anything.. where it should be on bytes.

any idea???

Just try giving

524288*1 + 8192 = 532480

Quote:

---

Originally posted by nagarjuna
Just try giving

524288*1 + 8192 = 532480

---

??? if you read my msg above.. i did tried this formula and hit error

anybody may explain why?

Uhhh I don't remember mentioning that to you.

Quote:

---

Originally posted by zainalj
??? if you read my msg above.. i did tried this formula and hit error

anybody may explain why?

---

I am sorry.. I missed it out. Try the following..

initial ==> 524288*1 + 8192 = 532480
next ==> 524288

Quote:

---

Originally posted by nagarjuna
I am sorry.. I missed it out. Try the following..

initial ==> 524288*1 + 8192 = 532480
next ==> 524288

---

hi nagarjuana, i just wonder why Oracle recommend next extent = sort_area_size+db_block_size where it won't work to my db

i tot ur name was marijuana...

hemmmm... seems nobody can tell why..

I guess, Oracle recomends the following for temporary tablespaces

initial to be multiples of sort_area_size + 1 db_block_size

and next to be multiples of sort_area_size

And to howmany folds ypiu are setting the the sort are size, you have to find out by trial and error I guess ;)

Quote:

---

Originally posted by nagarjuna
I guess, Oracle recomends the following for temporary tablespaces

initial to be multiples of sort_area_size + 1 db_block_size

and next to be multiples of sort_area_size

And to howmany folds ypiu are setting the the sort are size, you have to find out by trial and error I guess ;)

---

doc id 102339.1 refers,

When specifying the default storage parameters, set INITIAL=NEXT, because a process always writes data equal to SORT_AREA_SIZE to a temporary segment. - Use the following formula for calculating the value for NEXT: (n*s + b) with n = positive integer, s = value of SORT_AREA_SIZE initialization parameter, and b = value of DB_BLOCK_SIZE initialization parameter. Doing so, you achieve there will be enough space in every extent to store header-block information and the multiple sort run data. Example: suppose the following parameters are declared in your init.ora file: DB_BLOCK_SIZE = 8192 SORT_AREA_SIZE = 65536 Then the value for INITAL (and NEXT) could be: 1 * 65636 + 8192 = 64k + 8k = 72k.

please justify