Drop Temp Tablespace Taking Long Time

If there is a session that uses the temp tablespace you are trying to drop, the drop operation starts waiting. The drop operation is completed when all sessions using temp are finished.

If you want the drop immediately, after changing the default temp tablespace of the database, either restart the database, or find and terminate the sessions that use the temp tablespace you are trying to drop.

Who is Using Temp Tablespace

You can use the following query to find sessions that use temp.

You can kill the related sessions as follows by using the session information identified by the above query.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *