0 Replies Latest reply: Feb 17, 2012 11:30 AM by jose1234 RSS

    problem with dblink and latch: library cache and latch: row cache objects

    jose1234
      Good morning,

      i have a problem, i have 2 database A Y B, and a db_link, when i execute select * from view@dblink, in 30 sessiones concurrent (stress test), this session lock with "latch: library cache" and "latch: row cache objects". this consult take 80 miliseconds by dblink, and 10 miliseconds directly.

      the problem is not present if i execute 30 sessions concurrent without dblink, direct in the database owner of view.

      my shared_pool is so bit 3.7G, and this problem is only with the session of the owner of view, the other user is OK.

      how i can optimize this concurrence?

      thx, and sorry for my bad english.