Strange thing!

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Thu, 20 Jan 2005 17:03:06 -0500
Message-ID: <41F02A9A.3040406@allegientsystems.com>

I thought that hash value and address uniquely identify SQL statement? From the following SQL,
it's obviously not the case. Is there any other way of uniquely identifying them? It's 9.2.0.5 on Solaris, RAC.

1 select * from (
  2 select address,hash_value,count(*) cnt from v$sql   3 group by address,hash_value
  4 having count(*)>1
  5 order by 3 )
  6* where rownum<10
SQL> / ADDRESS HASH_VALUE CNT
-------- ---------- ----------

722070F0 1382559059          2
72213B2C 3035575473          2
7221C894 1680401187          2
722252D8 2857128568          2
72229E6C 1420320603          2
72230078  313534591          2
7233DBC0  173091138          2
72381604 2956793749          2
72386BDC 3767700815          2

9 rows selected.

--

Mladen Gogala
Oracle DBA

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 20 2005 - 17:05:46 CST