SQL Performance (MOSC)

MOSC Banner

Performance between 2 instance via database link

edited Jun 16, 2016 9:49AM in SQL Performance (MOSC) 17 commentsAnswered

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  ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center