Oracle的show processlist
復(fù)制代碼 代碼如下:
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
復(fù)制代碼 代碼如下:
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;
您可能感興趣的文章:- Oracle中在pl/sql developer修改表的2種方法
- PL/SQL Dev連接Oracle彈出空白提示框的解決方法分享
- Oracle實現(xiàn)分頁查詢的SQL語法匯總
- Oracle SQL Developer顯示的時間包含時分秒的設(shè)置方法
