Showing posts with label Apps Performance Issue. Show all posts
Showing posts with label Apps Performance Issue. Show all posts

Wednesday, July 14, 2010

Network Test and Analyze Client System for Oracle E-Business Suit

Performance issue is the most frustrating thing for DBA. Performance issue may be on Database Site / Middle Tier site or Network site. Oracle provide us tool for network test and analyze client system for Oracle EBS.

Oracle provide us tool to diagnose network performance and Analyze Client System at remote location in Oracle EBS:

  • The Network test Form
  • The Client Analyzer

How to Run Network Test Form:

1. Login to Applications as the Sysadmin Responsibility.
2. Navigate to Application > Network Test
3. Click the ‘Clear Old Test Data’ button to purge previous test results from the database.4. Specify the number of Trials (5 Default Value) and the Iterations for each trial for both the latency and bandwidth blocks.
4. Click on “Run Test” button to perform the test.

Latency and Bandwidth result will be appear on Network Test form:

What is Latency
In a network, latency, a synonym for delay, Latency is an expression of how much time it takes for a packet of data to get from one designated point to another. In some usages, latency is measured by sending a packet that is returned to the sender and the round-trip time is considered the latency.
There are a number of factors that contribute to network latency. These include transmission, propagation, routers and computer hardware delays. All of these play an important role in the overall determination of network latency. In some cases, there may not be a delay the user can notice. Fortunately, if network latency does become a problem, there are things that can be done to improve the situation.
What id Bandwidth
Bandwidth is a term used to describe how much information can be transmitted over a connection. Bandwidth is usually given as bits per second, or as some larger denomination of bits, such as Megabits per second, expressed as kbit/s or Mbit/s. Bandwidth is a gross measurement, taking the total amount of data transferred in a given period of time as a rate, without taking into consideration the quality of the signal itself.

Analyze the Result:
Oracle Recommends Network latency should be low and bandwidth should be high.
How to Run Analyze Client System

1. Login to Applications as the Sysadmin Responsibility.
2. Navigate to Application > Network Test
3. Click the ‘Help -----Diagnostics--------Client System Analyzer
4. Click on “View Result” button.
Viewing Data Collected by the Client System Analyzer . The Client System Analyzer collects information about a computer’s configuration, such as:

Hard drive size
CPU speed
Memory
Installed software
It also performs some network performance measurements.