Re: Same SQL, different tools, different SQL_IDs?
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Fri, 22 Jul 2011 00:12:26 -0700 (PDT)
Message-ID: <1311318746.55770.YahooMailNeo_at_web65906.mail.ac4.yahoo.com>
Can you run ora_hash on sql_fulltext for those 2 sql queries which you are expecting sql_id's to be same? select ora_hash(sql_fulltext) from v$sqlstats where sql_id='&sql_id' Thanks, Sai http://sai-oracle.blogspot.com
Date: Fri, 22 Jul 2011 00:12:26 -0700 (PDT)
Message-ID: <1311318746.55770.YahooMailNeo_at_web65906.mail.ac4.yahoo.com>
Can you run ora_hash on sql_fulltext for those 2 sql queries which you are expecting sql_id's to be same? select ora_hash(sql_fulltext) from v$sqlstats where sql_id='&sql_id' Thanks, Sai http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 22 2011 - 02:12:26 CDT