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

作者: 哈根达威尔-史密斯
来源: 51数据库
2020-08-16

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;