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?

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Clarify your question.

Regards
Michel

Report message to a moderator

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?





Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
When you need more temporary space.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 00:45:37 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.