View Single Post

   
  #2 (permalink)  
Old 05-16-2008, 02:41 PM
fitzjarrell@cox.net
 
Posts: n/a
Default Re: how is sql id set

On May 14, 2:50*pm, Ben <balve...@gmail.com> wrote:
> 10.2.0.2 EE
>
> How is the sql id of any given sql statement set? I've found that
> several of our most frequent sql statements have the same sqlid even
> after the instance is shut down and started back.


It's a hash, and you could have the same SQL_ID for a given statement
no matter when that hash is generated.


David Fitzjarrell
Reply With Quote