Query slowness [message #313215] |
Fri, 11 April 2008 01:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ap_karthi
Messages: 87 Registered: October 2007 Location: Bangalore
|
Member |
|
|
One Scenario :
1. Database in Remote place.
2. Five machines connected thro' router to DB.
3. Another 3 machines connected thro' router to DB.
4. Total 8 machines located in same place and connected to same DB.
5. Its taking more time to Query (3 machines) and another 5 machines are quite fine.
What could be the reason? Network guys are telling the network is fine.
|
|
|
Re: Query slowness [message #313232 is a reply to message #313215] |
Fri, 11 April 2008 02:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Don't trust network guy and activate trace in each session execute the same thing and see the network waits in the trace files.
Regards
Michel
|
|
|