RE: Undo Usage and Read consistency - ORA-1555
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "jkstill@xxxxxxxxx" <jkstill@xxxxxxxxx>, "nancy_iles@xxxxxxxxxxx" <nancy_iles@xxxxxxxxxxx>
- 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jared Still
Sent: Tuesday, July 14, 2009 7:42 PM
To: nancy_iles@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; cicciuxdba@xxxxxxxxx
Subject: Re: Undo Usage and Read consistency - ORA-1555
On Tue, Jul 14, 2009 at 3:04 PM, Nancy Iles
<nancy_iles@xxxxxxxxxxx<mailto: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:
