Re: Undo Usage and Read consistency - ORA-1555

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 14 Jul 2009 16:42:22 -0700
Message-ID: <bf46380907141642v73513838wa102c76694b4d90e_at_mail.gmail.com>

On Tue, Jul 14, 2009 at 3:04 PM, Nancy Iles <nancy_iles_at_hotmail.com> wrote:

>
> Yes, the there is an index on CONFIRMATION_NO and I have found that
> _OPTIM_PEEK_USER_BINDS=FALSE on all 6 RAC nodes. So, now on to research the
> other suggestions! Thanks to everyone for your input.
>

My question was actually slightly different.

The index exists, but is it being used?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 14 2009 - 18:42:22 CDT