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 |