Re: Index question

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 26 Aug 2009 19:37:51 +0200
Message-ID: <4a9572f4$0$183$e4fe514c_at_news.xs4all.nl>

stevedhoward_at_gmail.com schreef:

> On Aug 26, 6:24 am, Shakespeare <what..._at_xs4all.nl> wrote:

>> Steve Howard schreef:
>>
>>
>>
>>> 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
>> What's your cursor_sharing parameter?
>>
>> Shakespeare

> 
> Hi Shakespeare,
> 
> It is set to exact.
> 
> Thanks,
> 
> Steve

That rules out one problem ;-)

Shakespeare Received on Wed Aug 26 2009 - 12:37:51 CDT