Home » RDBMS Server » Server Administration » Temp growing too much (RHEL5 10g 10.2.0.1.0)
Temp growing too much [message #344422] Fri, 29 August 2008 14:47 Go to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

There is a user that execute a query with join.
This query is on view composed with join.
When he execute this SELECT the TEMP file
has beginning grow too much using whole
space on disk.
I have to create new TEMP file and
delete old TEMP.

How can I resolve this?
Is there some settings for reuse temp file?

Thanks,


Marcos Santos


Re: Temp growing too much [message #344425 is a reply to message #344422] Fri, 29 August 2008 15:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
tempfiles are reused by default and are a bad candidate for "autoextend on".
Just disable autoextend on.

[Updated on: Fri, 29 August 2008 15:19]

Report message to a moderator

Re: Temp growing too much [message #344428 is a reply to message #344422] Fri, 29 August 2008 15:34 Go to previous message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Thanks.
Previous Topic: 9.2
Next Topic: How can work in windows sever 2003 through XP?
Goto Forum:
  


Current Time: Sat Dec 03 22:21:19 CST 2016

Total time taken to generate the page: 0.09640 seconds