Home » RDBMS Server » Server Administration » Optimum value of Temporary tablespace Oracle 10g
Optimum value of Temporary tablespace Oracle 10g [message #276285] Wed, 24 October 2007 11:57 Go to next message
neelabh_SE
Messages: 20
Registered: October 2007
Junior Member
Hello,

I have Oracle 10g DB server.
How can I calculate optimum value for temporary tablespace?
This is a Data warehouse so there are fairly heavy process (ETL) running every week.

Please let me know if I need to add any specific details.

neel
Re: Optimum value of Temporary tablespace Oracle 10g [message #276292 is a reply to message #276285] Wed, 24 October 2007 12:34 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't determine it a priori.
It is highly dependent on data size and queries.

Regards
Michel
Previous Topic: Character set
Next Topic: ORA-12801 error
Goto Forum:
  


Current Time: Fri Dec 09 01:57:44 CST 2016

Total time taken to generate the page: 0.12090 seconds