We are on 81730/W2K.
I have a question related to the TEMP Tablespace.
What should be the configuration of TEMP tablespace?
1. Should it be defined as TEMPORARY or PERMANENT?
2. Should it be defined as Locally Managed or Dictionary managed?
What is the best configuration for TEMP tablespace to achieve the best performance.
Thanks in Adv.