EXPLAIN FOR DB LINK QUERY FAILS

@&lt

Hi Team,

We are running two oracle 11.2.0.2 database on same host.

and have the db link in each other, but when we take explain plan from local to remote it is failing kindly suggest is there any way to find the cost on local

db for remote queries.

In Database A the query cost is 10K but the same query if i use in remote its cost is going high so plaining to take the plan on remote but it is not working.

SQL> explain plan for

  2  SELECT * FROM <table>@&lt;linkname> WHERE <colname> = '011097859124';

explain plan for

*

ERROR at line 1: