Performance between 2 instance via database link
Hello,
I try to improve my performance query between 2 instance, in version 11.2.0.3. My time cpu is very slow. 110s
and if i have not database link the response is very good.
i did a tkprof but in my tkprof report i can not see the time i lose during the connection to the database link. 5 I join you the trc file and the prf file.
in my tkprof file i may not see the time elapsed. "
0 REMOTE OF 'WTPART' (REMOTE) [WTINTLK.INTRANET.CNIM.NET]
SELECT "IDA2A2" FROM "WTPART" "A1" WHERE "IDA2A2"=:1
who may help me, to improve this query with a database link ?