Explain plan on remote tables

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 Received on Wed Feb 03 1999 - 18:48:16 CST