EXPLAIN FOR DB LINK QUERY FAILS

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 remot 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> SELECT ac_no  FROM acvws_all_ac_entries@FCATFCCLINK WHERE AC_NO = '011097859124' and rownum <2;