OraFAQ Forum: Performance Tuning » temporary tablespace growing

Home » RDBMS Server » Performance Tuning » temporary tablespace growing (Oracle 10 R1-Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

temporary tablespace growing [message #347887]

Sun, 14 September 2008 23:31

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi All,

Temporary table space is growing- exceeded 20GB.

WHat should I do?

Thank you

Report message to a moderator

Re: temporary tablespace growing [message #347889 is a reply to message #347887]

Sun, 14 September 2008 23:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

>Temporary table space is growing- exceeded 20GB.
>WHat should I do?
do you have auto-extend enabled on temporary tablespace?

Report message to a moderator

Re: temporary tablespace growing [message #347891 is a reply to message #347889]

Sun, 14 September 2008 23:38

dirish
Messages: 232
Registered: November 2006

Senior Member

yes, auto-extend is enabled.

Report message to a moderator

Re: temporary tablespace growing [message #347892 is a reply to message #347891]

Sun, 14 September 2008 23:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

dirish wrote on Sun, 14 September 2008 21:38

yes, auto-extend is enabled.

& it is doing exactly what has been enabled.

Report message to a moderator

Previous Topic:	TKPROF Fetch stats
Next Topic:	How to SQL Tuning? Explain Steps

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 09:36:23 CST 2024