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

时间:2015-02-22 23:00 来源:linux.it.net.cn 作者:IT

Oracle中查看正在运行的SQL进程脚本分享,本文使用脚本实现了类似mysql show processlist命令的功能

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;

(责任编辑：IT)