Showing posts with label temp tablespace. Show all posts
Showing posts with label temp tablespace. Show all posts

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;