Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ways to free the TEMP tablespace

755678May 25 2011 — edited May 25 2011

Hi,

I am running a 9.2.0.8 database hosted on HPUX RISC platform. I have a PROD database which is consuming lot of TEMP space.
The database is a 700GB database. And the TEMP tablespace is close to 130GB.

Is there a way I could free up the TEMP tablespace? I believe it should get freed up after the temporary transcations are over isnt it? Or is it that it will free up only in the next reboot?
Please help me in freeing up the TEMP tablepace.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2011

Added on May 25 2011

#general-database-discussions

4 comments

2,615 views