Re: Remote query puzzle
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Sep 2005 13:09:00 -0500
Thanks Jared, Mark, Mladen, Ben
So far it seems that EXPLAIN PLAN is giving me the information that I
need, if I use the DRIVING_SITE hint. Haven't had to pull out the
heavy artillery (10053).
I have found the text of the remote view. It involves joining three tables.
So I have rewritten my query as a 4-table join with a small local
table joined with three large remote tables. My idea is that Oracle
should first take the local table, then use it to extract the rows it
needs from each of the three remote tables in turn. My first try was
to use the ORDERED hint to force the join in a specific order. Oracle
didn't agree and joined to my table last.
Any thoughts on the best way to induce Oracle to join tables in a
specific order would be appreciated. This is 8.1.7, rule-based.
Dennis Williams
On 9/8/05, Jared Still <jkstill@xxxxxxxxx> wrote:
> I haven't tried 10053 with RBO, but oraus.msg does indicate
> that is traces the CBO.
>
> (The end of Dennis' post indicates RBO)
>
> On 9/8/05, Mladen Gogala <gogala@xxxxxxxxxxxxx> wrote:
> > Can you enable the event 10053 for the whole remote database and see what
> > happens?
> > The other solution would be to select it several times and, in the
> > meantime, enable
> > 10053 on the remote database. There will be a session facilitating your
> > query on
> > the remote database.
> > --
> > Mladen Gogala
> > http://www.mgogala.com
> >
> >
> > --
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
