查询Oracle正在运行SQL的SQL命令：
select a.EVENT, a.SQL_ID, a.MACHINE, b.SQL_TEXT, b.SQL_FULLTEXT,b.FIRST_LOAD_TIME,b.LAST_LOAD_TIME,b.LAST_ACTIVE_TIME from v$session a, v$sql b where a.SQL_ID = b.SQL_ID and a.USERNAME is not null and a.STATUS = 'ACTIVE'
原文：http://blog.csdn.net/john_f_lau/article/details/41697317