Re: Verify driving_site hint
Date: Wed, 2 Jul 2008 07:46:08 -0700 (PDT)
Message-ID: <2f6811b9-313e-4289-8e20-92d668708587@m36g2000hse.googlegroups.com>
On Jul 2, 2:01 am, "Vladimir M. Zakharychev"
<vladimir.zakharyc..._at_gmail.com> wrote:
> On Jul 2, 1:48 am, flaw..._at_netspend.com wrote:
>
> > Is there some easy way to verify if the driving_site hint in a SQL
> > query is obeyed and executed at the specified location?
>
> > Maybe by adding something to query like
>
> > select /*+driving_site(remote_table) */ $execution_site_name, ...
>
> > Thanks
>
> It will be in the query execution plan. Check V$SQL_PLAN for actual
> plan used when the query was executed (you can also use
> DBMS_XPLAN.DISPLAY_CURSOR() for this.)
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
In the traditional plan_table you can SQL passed to a remote instance in the OTHER column so if have not ran the SQL you should be able to see the change this way.
HTH -- Mark D Powell -- Received on Wed Jul 02 2008 - 09:46:08 CDT