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.
Printable View
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.
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.