Re: cursor_sharing=similar

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 07 Jan 2004 19:17:14 +0800
Message-ID: <3FFBEAB9.64A7@yahoo.com>

Niall Litchfield wrote:
>
> A few days ago I stated that we hadn't been burned with
> cursor_sharing=similar on 9.2. I spoke too soon. Almost the next day
> (doesn't that always happen)we hit unpublished bug 2474192 which in our case
> prevents us maintaining intermedia indexes with cursor_sharing=similar. This
> bug is apparently fixed in 9203 - the server concerned is currently on 9202
> (that always happens as well).
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

Can the process(es) that do the sync and/or optimize simply set their own session cursor_sharing to exact, or is it more problematic than that ?

Cheers
Connor Received on Wed Jan 07 2004 - 05:17:14 CST