Temporary Tablespace not shrinking automatically after restarting the DB.
I had a Database with 2GB tempfile. It gave me an error that it’s unable to extend the temporary segment. I added a new tempfile of 500MB. Within a few min the new file was filled. In process of shrinking the temporary files, I shutdown the DB, and restarted it. But the Tempfiles were still filled to the max. I still don’t understand why? Then I attached a new tempfile of 1GB to the Temp Tablespace, but it didn’t use the new tempfile. I repeated the restart process again but still the output was same.
1. Both datafiles were filled to the max
2. It didn’t use the new (3rd) attached tempfile.
Finally I’ve created a new tablespace with new Tempfiles, and it’s working now. But I’m still confused. Please suggest me with the possibilities. How can i shrink the Temporary Tablespace/Tempfiles.
Thanks & Regards
Vikas Verma
Manager (IT) / Sr. DBA
Hero Cycle Group,
India
Answer:For us to understand what you did, post a snapshot of what you did along with oracle versions etc.
>> How can i shrink the Temporary Tablespace/Tempfiles.
In most cases, you don’t need to.
It is not unusual to see a 99% full temp tablespace. It is the way it works.
Related posts:
- How to reduce size of Temporary TableSpace Hello, There are 2 table spaces Order and Order_Temp...
- Temporary tablespace Hi, Is it possible to create a database without...
- Shrinking a database after a cut-down Hi all, This is the situation - we are...
- temp file hi all one of my disk has low space...
- ASM and tablespace management hi all, Can anyone point me in the right...