On Sat, Jun 14, 2008 at 2:08 PM, Leyne, Sean <Sean@...> wrote:

>> Playing with the monitoring tables I just noticed that the same
> statement
>> can have different ids on different snapshots. Why is that?

> You are making the assumption that the SQL text is what identifies a
> unique statement -- that has never been the case.

Not really.
I was assuming the statement id would uniquely identify it.

> From the engine perspective it is how the SQL Text is handled by the
> client which allows for the re-use of the statement handle. This is
> done by the client PREPARING the statement, and then invoking the
> command using the statement handle.

Yes, just noticed that ids can also be reused for other statements.

thanks,
Douglas Tosi