RE: What is the purpose of the new sql_id?

From: FMHabash <>
Date: Tue, 24 Feb 2009 13:41:03 -0500
Message-ID: <>

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.


-----Original Message-----
From: Gints Plivna <> Sent: Tuesday, February 24, 2009 1:25 PM To:
Cc: Oracle-L Group <> Subject: Re: What is the purpose of the new sql_id?

Tanel Poder wrote about that just few days ago:

Gints Plivna

2009/2/24 FMHabash <>:
> 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?

Received on Tue Feb 24 2009 - 12:41:03 CST

Original text of this message