Home » RDBMS Server » Performance Tuning » temporary tablespace growing (Oracle 10 R1-Linux)
temporary tablespace growing [message #347887] Sun, 14 September 2008 23:31 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi All,

Temporary table space is growing- exceeded 20GB.

WHat should I do?


Thank you
Re: temporary tablespace growing [message #347889 is a reply to message #347887] Sun, 14 September 2008 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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?
Re: temporary tablespace growing [message #347891 is a reply to message #347889] Sun, 14 September 2008 23:38 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
yes, auto-extend is enabled.
Re: temporary tablespace growing [message #347892 is a reply to message #347891] Sun, 14 September 2008 23:42 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: TKPROF Fetch stats
Next Topic: How to SQL Tuning? Explain Steps
Goto Forum:
  


Current Time: Sat Dec 10 06:52:07 CST 2016

Total time taken to generate the page: 0.08495 seconds