Yes. I started with a database trigger to do this which works fine, but in
fact we have just set cursor_sharing back to exact at least until we get to
do the upgrade as this issue would affect schemas responsible for about 40%
of the workload on the server anyway.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3FFBEAB9.64A7_at_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 - 06:35:02 CST
