Re: Undo Usage and Read consistency - ORA-1555

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: nancy_iles@xxxxxxxxxxx
  • Date: Tue, 14 Jul 2009 16:42:22 -0700

On Tue, Jul 14, 2009 at 3:04 PM, Nancy Iles <nancy_iles@xxxxxxxxxxx> 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

Other related posts: