If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Thank you Raminder.
How many temp tablespace needed(or is better) for one DB with about 200 concurrent user?(one,two or more ?).
If i have more than one temp tablespace , what is distribution of temporary extents allocation?
Sorry for my english!!
Best Regards.

you can have one tablespace and several datafiles so the point is not how many tablespace you should have, is how well are they distributed physically, tablespace is something logical, transparent to users, applications. Having more than one may provide more availability just in case one gets corrupted at physical level

My temporary tablespace (with 2 datafile) is about 4GB , and I want reduce size of this temporary tablespace by deleting one datafile(or reducing size of two datafile) because Hard disk is near full.
If I have 4 temp tablespace and 2000 user then I can assign each temp tablespace for 500 user.(alter user temporary tablespace temp1 ; ....). Is it correct?
Sorry for my english!!!
Best regards.

Originally posted by mahoori Hi ALL.
I want know finally :
1) Why oracle doesn't deallocate automatically(periodically) unused temporary extents in one temporary tablespace ?
2) for one server that can't shutdown , what is best way for temporary extents deallocations?
Best Regards.

1) To improve performance, extents are used over and over again, if SMON has to deallocate then that is extra work

2) I dont think there is a way to force SMON to free the extents, you would have to create a new temp tablespapce assign to users and drop the old one