Re: Verify driving_site hint
Date: Tue, 1 Jul 2008 23:01:59 -0700 (PDT)
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, ...
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) http://www.dynamicpsp.com Received on Wed Jul 02 2008 - 01:01:59 CDT