Re: Index question

From: joel garry <joel-garry_at_home.com>
Date: Tue, 25 Aug 2009 10:22:11 -0700 (PDT)
Message-ID: <e7b4bf46-9928-41bf-b072-60b140c47362_at_a37g2000prf.googlegroups.com>

On Aug 25, 9:12 am, Steve Howard <stevedhow..._at_gmail.com> wrote:
> 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

Wild speculation: Have you tried disabling parallel query for the objects?

jg

--
_at_home.com is bogus.
Note to self:  Do not google "getting away with murder"
http://www3.signonsandiego.com/stories/2009/aug/20/bn20potts132630/

Received on Tue Aug 25 2009 - 12:22:11 CDT