OraFAQ Forum: Server Administration » Temporary Tablespace not shrinking automatically after restarting the DB.

Home » RDBMS Server » Server Administration » Temporary Tablespace not shrinking automatically after restarting the DB.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temporary Tablespace not shrinking automatically after restarting the DB. [message #154540]

Mon, 09 January 2006 05:55

vikas_verma
Messages: 1
Registered: January 2006
Location: India

Junior Member

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

Report message to a moderator

Re: Temporary Tablespace not shrinking automatically after restarting the DB. [message #154550 is a reply to message #154540]

Mon, 09 January 2006 06:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

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.

Report message to a moderator

Previous Topic:	Lang Java Class Not found erro - DBUA utility on unix
Next Topic:	size of schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 05:06:35 CDT 2025