Home » RDBMS Server » Server Administration » Query slowness
Query slowness [message #313215] Fri, 11 April 2008 01:44 Go to next message
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
Michel Cadot
Messages: 64139
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
Previous Topic: oracle up gradation of 8i to oracle 9i
Next Topic: Reason of Error ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not
Goto Forum:
  


Current Time: Thu Dec 08 20:28:23 CST 2016

Total time taken to generate the page: 0.26052 seconds