广场 › 数据库 › Oracle中查看正在运行的SQL进程脚本分享

湛蓝之海 发表于 2022-1-27 14:52:15

Oracle中查看正在运行的SQL进程脚本分享

Oracle的show processlist


set linesize 400;

set pagesize 400;

col sql_text format a100;

col machine format a25;

col username format a15;

SELECT a.username,a.machine, b.sql_id, b.SQL_TEXT

FROM v$session a, v$sqlarea b

WHERE a.sql_address = b.address

    AND a.SQL_HASH_VALUE = b.HASH_VALUE;

Oracle show full processlist


set linesize 400;

set pagesize 400;

set long 4000;

col SQL_FULLTEXT format a100;

col machine format a25;

col username format a15;

SELECT a.username,a.machine, b.sql_id, b.SQL_FULLTEXT

FROM v$session a, v$sqlarea b

WHERE a.sql_address = b.address

    AND a.SQL_HASH_VALUE = b.HASH_VALUE;


https://www.uoften.com/dbs/oracle/20180415/73289.html

查看完整版本: Oracle中查看正在运行的SQL进程脚本分享