Re: how is sql id set

From: <fitzjarrell_at_cox.net>
Date: Wed, 14 May 2008 13:18:48 -0700 (PDT)
Message-ID: <e1e8442b-8c0d-4ea6-ac43-57eebe7e21a2@m3g2000hsc.googlegroups.com>


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

Original text of this message