RE: Undo Usage and Read consistency - ORA-1555

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 14 Jul 2009 20:05:47 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F1AE2AF3C_at_AAPQMAILBX02V.proque.st>

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
To: nancy_iles_at_hotmail.com
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?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Tue Jul 14 2009 - 19:05:47 CDT