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: 123
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

Report message to a moderator

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: 10708
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: 123
Registered: June 2008
Senior Member
Thanks.

Report message to a moderator

Previous Topic: 9.2
Next Topic: How can work in windows sever 2003 through XP?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 23:17:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.