Re: Verify driving_site hint

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 1 Jul 2008 23:01:59 -0700 (PDT)
Message-ID: <c5a8c1e3-2840-40fd-9306-5aa9871e2e28@w4g2000prd.googlegroups.com>


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 Received on Wed Jul 02 2008 - 01:01:59 CDT

Original text of this message