GetSQL

  SELECT                                                        

        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 = 4455))
ORDER BY   piece ASC
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16348200/viewspace-624714/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16348200/viewspace-624714/