RE: What is the purpose of the new sql_id?
Date: Tue, 24 Feb 2009 13:41:03 -0500
Message-ID: <49a43f39.0917400a.53f5.0006_at_mx.google.com>
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.
Thanks
-----Original Message-----
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/
Gints Plivna
http://www.gplivna.eu
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?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 24 2009 - 12:41:03 CST