Re: Index question

From: <stevedhoward_at_gmail.com>
Date: Wed, 26 Aug 2009 05:02:31 -0700 (PDT)
Message-ID: <4ee727f2-645b-47f0-a681-b4e7d8d7babd_at_r42g2000yqj.googlegroups.com>

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 Received on Wed Aug 26 2009 - 07:02:31 CDT