Re: Interesting Information ... BUT is it correct, or not?

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Sat, 21 Aug 99 10:19:12 GMT
Message-ID: <935230752.4815snx@aleytys.pc.my>

In article <37c8fbc4.199999554_at_newshost.us.oracle.com> tkyte_at_us.oracle.com writes:

>RBO pretty much tries to generate a 'FIRST_ROWS' type of plan anyway. If you
>are using this just for FIRST_ROWS and want to use RBO for every other query,
>just use RBO -- don't go through the trouble of analyzing all of your data.

Thomas,

I am trying to pull data from an ancient 7.0 database to a 7.3.3 database both of them set to RBO and optimiser_undo_changes=true (Oracle Financials requires this) via a dblink (pl/sql cursor loop/fetch insert cycle). I was getting end of channel ORA errors until I put a FIRST_ROWS hint in my cursor. There are no statistics on either database.

The question is what is FIRST ROWS doing that allows my PL/SQL procedure to complete without erroring out?

Philip

---=====================================================================---

 Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932    Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

---
 þ 10176.06 þ Who the Dickens wrote "Oliver Twist", anyway? Received on Sat Aug 21 1999 - 05:19:12 CDT