how to monitor locally managed temp sapce

[avarshney]

Just wondering how to figure out who is using temp space if it is locally managed ?Earlier with dictionary managed tablespaces it could be achieved through v$sort_usage view.

[dmitriy]

Hi avarshney,

The answer is still through v$sort_usage view. In your case it doesn’t make any difference, which type of space management the temp tablespase implements - local or dictionary.