Database Performance Issue VS Network Performance Issue [message #228687] |
Tue, 03 April 2007 13:47 |
rfilion
Messages: 8 Registered: April 2007 Location: Ottawa
|
Junior Member |
|
|
Hi all.
We have a production server running on Oracle 9i. Many users are complaining about the application being slow. Often, the problem is not with the Oracle database, but rather their network. We are using Forms 6i (I know, we still live in dinosaur land).
One of the step we have done as a work around until we find a solution, is:
From the launchpad of our application, we put a shortcut for the users that currently launches a TNSPING against the listener.
The problem that we have is that the TNSPING's results are inconclusive. A long reply (>80 msec) will signify to the user that at the time they performed the TNSPING, there is a problem, but that's it. TNSPING cannot tell you whether the slow response is due to the Network, or high activity on the server.
Does anybody know if there is a utility that can be called from the client side (the forms 6i application) that would tell the user if the problem is network related or db server related? We do not need to give the users detailed information on the actual issue. All that we need to tell them is: Network related or Database related.
Hope I am clear enough. Please ask if you need clarification.
|
|
|
|
Re: Database Performance Issue VS Network Performance Issue [message #228694 is a reply to message #228690] |
Tue, 03 April 2007 14:15 |
rfilion
Messages: 8 Registered: April 2007 Location: Ottawa
|
Junior Member |
|
|
Thanks for the quick reply.
Maybe I should of mentioned that the reason for doing this is:
If the problem is network related, the users are sent to their own IT/Networking department. (We don't maintain)
If the problem is DB server related or problems with the database itself then we maintain.
Regardless, by the look of your response, there doesn't seem to be anyway for us to simply determine through forms 6i (or by calling a similar utility to tnsping from a dos prompt) if it's network or server/db related.
Right?
Just trying to make sure I understand properly you answer as we currently were not intending to use an SQL query to check if the problem was on the db side. (Although if it's something that could be done, we would definately consider it.)
Thanks again
|
|
|
|