JZTXT

oracle 查看哪些sql在使用临时表空间

发布时间 2023-11-19 03:22:17作者: AQ_0321
  1. 查看哪些sql在使用临时表空间
  SELECT a.username,
         a.sid,
         a.serial#,
         a.osuser,
         b.tablespace,
         b.blocks,
         c.sql_text
    FROM v$session a, v$tempseg_usage b, v$sqlarea c
   WHERE     a.saddr = b.session_addr
         AND c.address = a.sql_address
         AND c.hash_value = a.sql_hash_value
ORDER BY b.tablespace, b.blocks;