temp表空间上Oracle进程查询

原创

wx62e28ac222a20 2022-08-05 11:37:41 ©著作权

文章标签 sql oracle anaconda linux safari 文章分类 数据库

©著作权归作者所有：来自51CTO博客作者wx62e28ac222a20的原创作品，请联系作者获取转载授权，否则将追究法律责任

1.具体SQL语句

select a.tablespace, b.sid, b.serial#, a.blocks,c.sql_text
  from v$sort_usage a,v$session b,v$sqltext c
 where a.session_addr = b.saddr
   and b.sql_address = c.address
 order by a.tablespace,b.sid,b.serial#,c.address, c.piece;

2.执行结果

TABLESPACE                            SID    SERIAL#     BLOCKS SQL_TEXT
------------------------------ ---------- ---------- ---------- ----------------------------------------------------------------
TEMP                                  267      26882        128 select a.tablespace, b.sid, b.serial#, a.blocks,c.sql_text   fro
TEMP                                  267      26882        128 select a.tablespace, b.sid, b.serial#, a.blocks,c.sql_text   fro
TEMP                                  267      26882        128 m v$sort_usage a,v$session b,v$sqltext c  where a.session_addr =
TEMP                                  267      26882        128 m v$sort_usage a,v$session b,v$sqltext c  where a.session_addr =
TEMP                                  267      26882        128  b.saddr    and b.sql_address = c.address  order by a.tablespace
TEMP                                  267      26882        128  b.saddr    and b.sql_address = c.address  order by a.tablespace
TEMP                                  267      26882        128 ,b.sid,b.serial#,c.address, c.piece
TEMP                                  267      26882        128 ,b.sid,b.serial#,c.address, c.piece

8 rows selected.

oracle