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

  • From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 30 May 2008 13:15:45 +0530

Folks

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

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

Is Running tnsping periodically during Peak Benchmark Transaction Load hitting 
the SAME IP Address / Port Num as the Application. tnsping under concurrent 
Benchmark Tran load is giving a Timing of 118 milli seconds. This seems to 
indicate a Network choke.

Any Other HP-UX Command(s) that give % of Network Usage (of 100 MBPS LAN) 
between APP & DB Server?

HP-UX
Oracle 10.2

Cheers & Thanks indeed

Vivek




**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not 
to copy, disclose, or distribute this e-mail or its contents to any other 
person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys has 
taken 
every reasonable precaution to minimize this risk, but is not liable for any 
damage 
you may sustain as a result of any virus in this e-mail. You should carry out 
your 
own virus checks before opening the e-mail or attachment. Infosys reserves the 
right to monitor and review the content of all messages sent to or from this 
e-mail 
address. Messages sent to or from this e-mail address may be stored on the 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts: