OraFAQ Forum: Performance Tuning » What situation should I add more termporary tablespace?

Home » RDBMS Server » Performance Tuning » What situation should I add more termporary tablespace? (Solaris 9 + oracle10gR2 RAC)

Fri, 23 May 2008 03:07

wxfjordan
Messages: 92
Registered: December 2006

Member

What situation should I add more termporary tablespace?

Or increase termporary tablespace size?

Fri, 23 May 2008 03:22

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Clarify your question.

Regards
Michel

Fri, 23 May 2008 04:22

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?

Fri, 23 May 2008 04:24

Michel Cadot
Messages: 68664
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: Sat Jun 22 22:41:50 CDT 2024