Re: Verify driving_site hint
Date: Wed, 2 Jul 2008 07:46:08 -0700 (PDT)
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.)
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
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