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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't determine it a priori.
It is highly dependent on data size and queries.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 04:42:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.