Who Uses Temp Tablespace in Oracle


When you see that there is intense use of temp in a running database, it is necessary to determine who is using a temp segment for which operation. You can use the following query for this. It is possible to query globally with $g instead of v$ in the query.

It is necessary to determine the temp usage when you need to do an operation about temp tablespace. For example, you cannot drop temp tablespace if anyone is using temp. If you run the drop command while the Temp is in use, it will not execute until the end of use. You can detect and close the session with the following query.

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 *