Home » RDBMS Server » Networking and Gateways » TNSPING Result Analysis
TNSPING Result Analysis [message #331885] Sun, 06 July 2008 07:48 Go to next message
samyoung1960
Messages: 5
Registered: April 2007
Junior Member
HI Embarassed
sometimes our application give a slow respons to the user
when i use TNSPING it give the following result OK (270 msec) in the normal case it give the following result OK (10 msec) or OK (0 msec) can this give any indication that
there is a network problem's Mad
Regard's
sam

Report message to a moderator

Re: TNSPING Result Analysis [message #331888 is a reply to message #331885] Sun, 06 July 2008 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In this case, also try a "ping" command.

Regards
Michel

Report message to a moderator

Re: TNSPING Result Analysis [message #331893 is a reply to message #331885] Sun, 06 July 2008 08:44 Go to previous messageGo to next message
samyoung1960
Messages: 5
Registered: April 2007
Junior Member
Hi
Thank's Michel for reply
I Tried ping and tracrert the result alwayes identical ( when the application is slow or normal ) only small diffrence Shocked
1 - ping alwayes gives the same result 1 ms
2- tracert gives 1ms - 22 ms
only the big diffrence appears in tnsping
Regards

SAM

[Updated on: Sun, 06 July 2008 08:53]

Report message to a moderator

Re: TNSPING Result Analysis [message #331895 is a reply to message #331893] Sun, 06 July 2008 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And server workload?

Regards
Michel

Report message to a moderator

Re: TNSPING Result Analysis [message #331899 is a reply to message #331885] Sun, 06 July 2008 09:17 Go to previous messageGo to next message
samyoung1960
Messages: 5
Registered: April 2007
Junior Member
Hi
Michel do you believe it's a database issues
Regards
SAM

Report message to a moderator

Re: TNSPING Result Analysis [message #331901 is a reply to message #331885] Sun, 06 July 2008 09:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
samyoung1960 wrote on Sun, 06 July 2008 05:48
HI Embarassed
sometimes our application give a slow respons to the user
when i use TNSPING it give the following result OK (270 msec) in the normal case it give the following result OK (10 msec) or OK (0 msec) can this give any indication that
there is a network problem's Mad
Regard's
sam


TNSPING only interacts with Oracle listener & NEVER involves the database.

Oracle listener is NEVER involved with an established Oracle session.

Slow application response times have NOTHING to do with Oracle listener.

Report message to a moderator

Re: TNSPING Result Analysis [message #331905 is a reply to message #331885] Sun, 06 July 2008 09:26 Go to previous message
samyoung1960
Messages: 5
Registered: April 2007
Junior Member
HI
o.k Michel , the result from ping and tracert is enough
to say that there is no network problem
Regards
SAM

Report message to a moderator

Previous Topic: why is PLSExtProc used in listener file
Next Topic: HOW TO RUN APPLICATIONS ON THE WEB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 14:33:35 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.