Re: What is the purpose of the new sql_id?
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Tue, 24 Feb 2009 20:25:09 +0200
Message-ID: <6e49b6d00902241025m30607428j8245c20130fb742b_at_mail.gmail.com>
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/
Date: Tue, 24 Feb 2009 20:25:09 +0200
Message-ID: <6e49b6d00902241025m30607428j8245c20130fb742b_at_mail.gmail.com>
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:25:09 CST