select
sql_text,
sid,
c.username,
machine,
tablespace,
extents,
blocks
from
sys.v_$sort_usage a,
sys.v_$sqlarea b,
sys.v_$session c
where
a.sqladdr = b.address and
a.sqlhash = b. hash_value and
a.session_addr = c.saddr
order by sid;
We can check, SQL call current session information and details. How much temporary space SQL call is using.
No comments:
Post a Comment