Home » RDBMS Server » Server Administration » Deallocation of Temp Extents
Deallocation of Temp Extents [message #61677] Sun, 16 May 2004 23:49 Go to next message
shyam
Messages: 25
Registered: January 2001
Junior Member
Hi,

We use locally managed temporary tablespaces using tempfile option. The temporary tablespace grows considerable for user sort requests. We know that temp extents created in such tempfiles are reused and not deallocated by SMON during normal database operations.

But are such temp extents deallocated at time of shutdown or not? Please advise.

Thanks and Regards,

Shyam

 

Report message to a moderator

Re: Deallocation of Temp Extents [message #61679 is a reply to message #61677] Sun, 16 May 2004 23:56 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

At the time of clean shutdown oracle deallocate the temp segment in temporary tablespace.

Daljit Singh.

Report message to a moderator

Previous Topic: full index scan
Next Topic: oracle on another port
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 08 16:10:35 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.