Oracle: Check which user is holding temp tablespace

Check which user holding temp tablespace

SELECT s.username, s.sid,  u.TABLESPACE, u.CONTENTS, u.extents, u.blocks
  FROM v$session s, v$sort_usage u
 WHERE s.saddr = u.session_addr;

No comments: