Home » RDBMS Server » Performance Tuning » What situation should I add more termporary tablespace? (Solaris 9 + oracle10gR2 RAC)
What situation should I add more termporary tablespace? [message #322339] Fri, 23 May 2008 03:07 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

What situation should I add more termporary tablespace?

Or increase termporary tablespace size?
Re: What situation should I add more termporary tablespace? [message #322344 is a reply to message #322339] Fri, 23 May 2008 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Clarify your question.

Regards
Michel
Re: What situation should I add more termporary tablespace? [message #322360 is a reply to message #322339] Fri, 23 May 2008 04:22 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

My Database have 1 temporary tablespace and total has 80M Size.

I want to know what situation I should increase this temporary tablespace size?





Re: What situation should I add more termporary tablespace? [message #322362 is a reply to message #322360] Fri, 23 May 2008 04:24 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you need more temporary space.

Regards
Michel
Previous Topic: deletion taking longer time
Next Topic: batch job that run long
Goto Forum:
  


Current Time: Sun Dec 04 18:41:14 CST 2016

Total time taken to generate the page: 0.05454 seconds