Re: Same SQL, different tools, different SQL_IDs?

  • From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
  • To: free <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 22 Jul 2011 00:12:26 -0700 (PDT)

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

Other related posts: