This discussion is archived
11 Replies Latest reply: May 21, 2012 5:12 PM by user8175606 RSS

slow response when query v$lock or some data dictionary

user8175606 Newbie
Currently Being Moderated
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!!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points