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;