RE: What is the purpose of the new sql_id?
Date: Tue, 24 Feb 2009 13:41:03 -0500
Thanks. I actually saw that shortly after posting. Credit due to Tanel, sql hash/id are both derived from same MD5 hash, and therefore, it is not reused.
From: Gints Plivna <gints.plivna_at_gmail.com> Sent: Tuesday, February 24, 2009 1:25 PM To: fmhabash_at_gmail.com
Cc: Oracle-L Group <oracle-l_at_freelists.org> Subject: Re: What is the purpose of the new sql_id?
Tanel Poder wrote about that just few days ago: http://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value/
2009/2/24 FMHabash <fmhabash_at_gmail.com>:
> This new column appeared in 10g and is becoming the standard to refer to a given sql. I couldn't find a reference as to why was it introduced vs. Old way of using sql-hash?
> Also, I assume this id changes when a query gets reloaded, but it is never reused. Is this a correct statement?