sunny

• Jul 17th, 2015

 

We will remove the temp file or we can resize the temp tablespace.

ketan

• Feb 3rd, 2016

 

Update temp table also using alter keyword

Ajin

• Feb 24th, 2016

 

In production environment,there are different scenarios where temp tablespace is occupied on a particular point of time. One of them is if space in temp tablespace is occupied unusually then it might be due to the active sessions occupying the space. Run the query to get the session id,username, sql id and sql text details which is occupying the temp space on that point of time and notify the application team about the details. Application team will come back on what action needs to be taken on that particular session. Another scenario is if temp space is occupied to a greater extent on daily basis then we should increase the temp tablespace space as it might be due to the more number of sessions or any recent changes from application end.

amjath

• Mar 11th, 2016

 

Check the temp tablespace usage and kill inactive sessions or contact high space usage users to kill their sessions.

Suresh Borse

• Apr 8th, 2016

 

Add the tempfile to temp tablespace.