Re: Trace file Anomolies

From: Matt <mccmx_at_hotmail.com>
Date: 12 Nov 2004 00:06:55 -0800
Message-ID: <cfee5bcf.0411120006.12dc2b75@posting.google.com>

> Do you have a session cursor cache defined ?
> It shouldn't have this effect, but maybe there's
> a side effect from some recent tweaking.
>

No - none defined.

> I notice, also, that your trace file shows you
> are parsing statements twice. This is probably
> a hidden feature of your development environment -
> but possibly it is hitting a code error in Oracle that
> 'gets confused' about whether the cursor has closed
> or not.

This is a good heads up - I have not noticed this before. I will investigate this further.

>
> You could check to see if there is any correlation
> between double-parses and failing to dump STAT
> lines.
>

Thanks for your feedback. Received on Fri Nov 12 2004 - 02:06:55 CST