Home » RDBMS Server » Server Administration » Query slowness
Query slowness [message #313215] Fri, 11 April 2008 01:44 Go to next message
Messages: 87
Registered: October 2007
Location: Bangalore
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: 65084
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.

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: Sat Jul 22 13:50:48 CDT 2017

Total time taken to generate the page: 0.12881 seconds