Re: Index question

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 26 Aug 2009 12:24:12 +0200
Message-ID: <4a950d4a$0$185$e4fe514c_at_news.xs4all.nl>

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 Received on Wed Aug 26 2009 - 05:24:12 CDT