temp extent size for DMT

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