Re: Explain plan using db-link

From: <markp7832_at_my-deja.com>
Date: Thu, 23 Dec 1999 23:23:41 GMT
Message-ID: <83uara$747$1@nnrp1.deja.com>

In article <87u84.43381$n3.772956_at_news0.telusplanet.net>, "Terry Dykstra" <tdykstra_at_cfol.ab.ca> wrote:
> Is it possible to run Explain Plan and get meaningful results when the
> select statement uses db-links?
> Explain plan doesn't show any object_names for the remote objects, so
it
> makes it impossible to interpret the results.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
>

Yes, the plan output for distributed queries is meaningful. Look in the 'other' column for the sql passed to the remote instance. This will let you see if the sql is passed once or passed multiple times in a loop.

Then you can cut the passed sql and explain it on the remote instance to see what Oracle is doing there, if necessary.

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 23 1999 - 17:23:41 CST