Re: Index question
Date: Tue, 25 Aug 2009 18:48:47 +0200
Message-ID: <4a9415f0$0$424$426a74cc_at_news.free.fr>
"Steve Howard" <stevedhoward_at_gmail.com> a écrit dans le message de news:
5534f3df-6650-4583-99d2-e3a4fbcf23ea_at_g31g2000yqc.googlegroups.com...
| Hi All,
|
| 10.2.0.4 EE three node RAC on SLES 10
|
| I'm fairly sure I am missing something, but can someone please explain
| what is below?
|
| SQL> select min(jrn_seq) from xwc.xwc_change_history where jrn_seq
| between 1019514060 and 1019514080;
|
| MIN(JRN_SEQ)
| ------------
| 1019514075
|
| SQL> select jrn_seq from xwc.xwc_change_history where jrn_seq between
| 1019514060 and 1019514080 order by 1;
|
| JRN_SEQ
| ----------
| 1019514072
| 1019514073
| 1019514074
| 1019514075
| 1019514076
| 1019514077
| 1019514078
| 1019514079
| 1019514080
|
| 9 rows selected.
|
| SQL>
|
| Thanks,
|
| Steve
Trace them and post execution plans.
Maybe an index corruption.
Regards
Michel
Received on Tue Aug 25 2009 - 11:48:47 CDT