Temp tablespace monitoring: how to find which query is take more space in temp tablespace than other
Hello,
I am trying to find out which query is taking more temp space, I have following query which is returning no results,
select u.username, s.sql_fulltext, u.segtype, u.extents, u.blocks from v$tempseg_usage u, v$sql s where s.sql_id = u.sql_id;
I found this on web, was expecting result, but v$tempseg_usage is empty. Is there any setting by which we can have data in v$tempseg_usage.
My oracle version is 19c and x64 win server2019 is h/w configuration.