×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Oracle
Posted by: Maykel Vink
Added: Sep 28, 2012 10:02 AM
Views: 42
Tags: no tags
  1. SELECT b.sid,
  2.   b.username,
  3.   hash_value,
  4.   piece,
  5.   sql_text
  6. FROM v$sqltext a,
  7.   (SELECT sid,username,sql_address FROM v$session
  8.   ) b
  9. WHERE (address, hash_value) IN
  10.   (SELECT sql_address, sql_hash_value FROM v$session
  11.   )
  12. AND a.address = b.sql_address
  13. ORDER BY HASH_VALUE,
  14.   piece;