Using TNSPING to check for network congestion/problems

[MCubitt]

Has anyone used TNSPING as a method of checking for network bottlenecks and issues?

Some consultants indicated that our network infrastructure could be responsible for some of our Oracle performance issues, where as we think it's the programs/SQLs/Database.

I wonder what tried & tested software or scripts are available.

Thanks



Applications Support
UK

 

[alexhu]

It is an indication of network performance (as is ping) but its a bit 'simple'. A proper network monitoring tool is what they should be using

Alex

 

[MCubitt]

Thanks Alex, I was rather hoping a toe in the water would give me the credibilkity to then jump in..

Can one TNSPING for a repeated number of times?



Applications Support
UK

 

[alexhu]

Can one TNSPING for a repeated number of times?

Yes - remember however that you are only getting the reaction from the listener and not the database.

Just beacause you get a quick time from tnsping does not necessarily mean that the network is fine - you must consider the time when data is be carried from the database.

Ideally you should use the database as normal and use a network monitor to determine bandwidth utilisation and network latency

Alex

 

[MCubitt]

Thanks Alex, I have asked for our technical manager to review this.

regards


Applications Support
UK