Re: Explain plan on remote tables

From: <mark.powell_at_eds.com>
Date: Fri, 05 Feb 1999 15:40:37 GMT
Message-ID: <79f3dj$u4d$1@nnrp1.dejanews.com>

In article <36B8EE50.3847_at_pathcom.com>,   hpatel_at_pathcom.com wrote:
> We are performing insert into local tables, source data is selected
> from the remote tables (synonyms pointing to remote tables via database
> links). The select statement is passing a rule hint in the
> sql statements and still it takes longer. The remote tables are analyzed
> and it is required for processes on that instance. How we can make sure
> that it is using rule hint when going via database link.
>
> Local oracle version is 7.3.4
>
> remote oracle version is 7.2.3
>
> When we try to run explain from 7.3.4, it hangs and query never
> returns.
>
> Any ideas???
>
> Thanks in advance.
>
> Hitesh Patel
>

May sure your SQL in the explain does not end in a ';' and have a slash to execute it or some other error since it does not return.

When it does return look in the OTHER column of the plan_table to see the SQL

that is passed to the remote database.	I doubt that the hint is being passed
unless maybe the remote query is a sub-select.	You should be able to explain

the remote portion of the query on the remote database to see how Oracle accesses the data.

Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 05 1999 - 09:40:37 CST