What is the purpose of the new sql_id?

  • From: FMHabash <fmhabash@xxxxxxxxx>
  • To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 24 Feb 2009 12:56:45 -0500

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?

Thank you
 
--
//www.freelists.org/webpage/oracle-l


Other related posts: