查找正在运行或上一次执行的sql

SQL> set linesize 200
SQL> set pagesize 200
SQL> select * from v$mystat where rownum<2;

       SID STATISTIC#	   VALUE
---------- ---------- ----------
      1175	    0	       0
	  
	  
SQL> select * from (select * from TLYH order by owner) where rownum<20;
		 
		 
		 
正在执行SQL:

SQL> select sid,
                serial#,
                username,
                sql_hash_value,
                sql_address,
                prev_hash_value,
                sql_hash_value
           from v$session
          where sid = 1175  2    3    4    5    6    7    8    9  ;

       SID    SERIAL# USERNAME			     SQL_HASH_VALUE SQL_ADDRESS      PREV_HASH_VALUE SQL_HASH_VALUE
---------- ---------- ------------------------------ -------