Re: Verify driving_site hint

From: Vladimir M. Zakharychev <>
Date: Tue, 1 Jul 2008 23:01:59 -0700 (PDT)
Message-ID: <>

On Jul 2, 1:48 am, 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) Received on Wed Jul 02 2008 - 01:01:59 CDT

Original text of this message