RE: Undo Usage and Read consistency - ORA-1555
Date: Tue, 14 Jul 2009 20:05:47 -0400
And a follow-up, if it's not being used, are stats up to date on the table and all indexes?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Tuesday, July 14, 2009 7:42 PM
Cc: oracle-l_at_freelists.org; cicciuxdba_at_gmail.com Subject: Re: Undo Usage and Read consistency - ORA-1555
On Tue, Jul 14, 2009 at 3:04 PM, Nancy Iles <nancy_iles_at_hotmail.com<mailto: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?
Certifiable Oracle DBA and Part Time Perl Evangelist