(转):学习Oracle动态性能表-(11)-V$PROCESS

上一篇 / 下一篇  2009-09-24 14:00:05 / 个人分类:oracle

Eygle大师写了一段sql脚本getsql.sql,用来获取指定pid正在执行的sql语句,在此也附注上来。

REM getsql.sql

REM author eygle

REM windows,已知进程ID,得到当前正在执行的语句

REM windows,进程ID16进制,需要转换,UNIX直接为10进制

SELECT   /*+ ORDERED */

         sql_text

    FROM v$sqltext a

   WHERE (a.hash_value, a.address) IN (

            SELECT DECODE (sql_hash_value,

                            0, prev_hash_value,

                           sql_hash_value

                          ),

                   DECODE (sql_hash_value, 0, prev_sql_addr, sql_address)

              FROM v$session b

             WHERE b.paddr = (SELECT addr

                                FROM v$process c

                               WHERE c.spid = TO_NUMBER ('&pid', 'xxxx')))

ORDER BY piece ASC

/


TAG:

 

评分:0

我来说两句

Open Toolbar