11 Replies Latest reply: May 21, 2012 7:12 PM by user8175606 RSS

    slow response when query v$lock or some data dictionary

    user8175606
      Hello,

      We have a severe problem with our database performance problem. Here is the situation:

      1. When query data dictionary such as v$lock from any Windows machine on the network, the performance is slow (about 3 minutes.)
      2. When query v$lock directly on the server where database reside, the query come back fast (normal).
      3. When query user table such as employees from any windows machine on the network, the performance is normal.
      4. When query user table directly from server where the database reside, the query come back normal.

      Looking at v$session_wait on the slow query, it is waiting on "SQL*Net message to client".

      We have people from our network group, security group and did not find anything problem.

      Thank for you help!!!