RE: N/w Bottleneck Check using tnsping under Tran. Load ... Basic Qs

  • From: Tanel Poder <tanel.poder.003@xxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 30 May 2008 22:57:29 +0800

Hi,
 
The listener process needs to get onto CPU in order to answer to your
tnsping request, so if your CPU runqueues are long during peak load test, it
will take a while before listener can reply to your request.
 
For testing purposes you could set the listener onto real time priority
class and see if the results change. 
 
But your network guys should be able to say whether your network is
saturated, as they have access to various link level stats etc.

--
Regards,
Tanel Poder
http://blog.tanelpoder.com <http://blog.tanelpoder.com/> 


 



  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of VIVEK_SHARMA
Sent: Friday, May 30, 2008 19:15
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: N/w Bottleneck Check using tnsping under Tran. Load ... Basic
Qs



Folks

 

Banking Java Application uses Oracle thin driver to connect to the Database.
This Oracle client (I assume) goes thru the Listener on DB Server.

Benchmark doing OLTP Nature of Transactions

 

Is following an appropriate pointer to check for Network Choking under
(Benchmark) Transaction Load?

Other related posts: