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;
FROM v$session s, v$sort_usage u
WHERE s.saddr = u.session_addr;
No comments:
Post a Comment