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

来源：互联网发布：淘宝seo冷门词编辑：程序博客网时间：2024/06/05 03:41
SQL> set linesize 200SQL> set pagesize 200SQL> 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---------- ---------- ------------------------------ -------------- ---------------- --------------- --------------      117531583 VXSPACE 2226292732 000000007E67DF50  3237839783 2226292732    执行完后；SQL>   select sid,                serial#,                username,                sql_hash_value,                sql_address,                prev_hash_value,                prev_sql_addr           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 PREV_SQL_ADDR---------- ---------- ------------------------------ -------------- ---------------- --------------- ----------------      117531583 VXSPACE  0 00  2226292732 000000007E67DF50    SQL> select sql_text  from v$sqlarea where (address, hash_value) in       (select /*+unnest*/         DECODE(sql_hash_value, 0, prev_sql_addr, sql_address),         DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value)          from v$session         where sid = 1175)  2    3    4    5    6    7    8  ;SQL_TEXT--------------------------------------------------------------------------------select * from (select * from TLYH order by owner) where rownum<20再次运行SQLSQL> /SQL_TEXT--------------------------------------------------------------------------------select 'aaa' from dual
阅读全文
0 0