Re: how is sql id set
Date: Wed, 14 May 2008 13:18:48 -0700 (PDT)
On May 14, 2:50 pm, Ben <balve..._at_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 Received on Wed May 14 2008 - 15:18:48 CDT