Prev: Error Compiling Java in Oracle 10g
Next: sqlldr question
From: flawlor on 1 Jul 2008 17:48
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
From: Vladimir M. Zakharychev on 2 Jul 2008 02:01
On Jul 2, 1:48 am, flaw...(a)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
From: Mark D Powell on 2 Jul 2008 10:46
On Jul 2, 2:01 am, "Vladimir M. Zakharychev"
<vladimir.zakharyc...(a)gmail.com> wrote:
> On Jul 2, 1:48 am, flaw...(a)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 --
 | 
Pages: 1
Prev: Error Compiling Java in Oracle 10g
Next: sqlldr question