Re: how is sql id set

From: <>
Date: Wed, 14 May 2008 13:18:48 -0700 (PDT)
Message-ID: <>

On May 14, 2:50 pm, Ben <> wrote:
> 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