RE: Sql-id value: does it chage and what evet changes it?
- From: "Tanel Poder" <tanel@xxxxxxxxxx>
- To: <fmhabash@xxxxxxxxx>, "'Oracle-L Group'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Mar 2009 19:58:23 +0200
Hi,
SQL_ID is just a 64-bit hash value of library cache object name (sql text
for cursors), represented in base-32 instead of decimal (base-10) or hex
(base-16)
In other words, SQL_ID is just a fancy form of hash_value, as I've explained
here:
http://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-
of-hash-value/
So as long as the statement text remains the same, the SQL_ID and hash_value
remain the same.
--
Regards,
Tanel Poder
http://blog.tanelpoder.com
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of FMHabash
> Sent: 06 March 2009 18:52
> To: Oracle-L Group
> Subject: Sql-id value: does it chage and what evet changes it?
>
> Hi all,
> I have done some testing and found out as long as sql-text
> does not change, sql-id remains same even if...
> 1- db reboots.
> 2- sql ages out of lib cache
> 3- sql changes exec plan.
>
> Can someone confirm/rebut these findings please.
>
> Thank you.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
