Web Application Process in Oracle Databases

1
Web Application Process in Oracle Databases
There is a temptation to focus adjusting efforts
on the databases only, by looking at parameters,
SQL concerns, and PL/SQL program code.
2
Step 1 Customer Device Efficiency Problems

• The formulation of a demand in the consumer
  machine is usually the least likely source of
  program performance issues.
• This is particularly true for underpowered
  client devices with insufficient memory and
  slowly processors.

3
Step 2 Client Machine to Application Server
Transmitting Problems

• As is true for the consumer machine itself, the
  transmission between the consumer machine and the
  applying server is a less common cause of
  gradually executing web programs
• For example, uploading huge files (such as
  images) or transmitting a huge block of
  information may slowly down performance.

4
Step 3 Program Server Efficiency Problems

• The application server itself rarely causes
  important performance deterioration.
• For computationally intense programs such as
  huge matrix inversions for linear programming
  issues, some performance slowdowns can happen,
  but this is less likely to be an important aspect
  in poorly executing programs.

5
Step 5 Database Efficiency Problems

• In the databases itself, it is important to look
  for the same things that cause client/server
  programs to run gradually.
• However, additional web application features can
  cause other performance issues in the databases.

6
Step 4 Program Server to Database Transmitting
Problems

• Transmission of information from the applying
  server to the databases with 1 Gbps or better
  transmission speeds might lead you to ignore this
  help the process.
• The trend in current web design is to make
  programs database-agnostic.
• In the applying server, identifying performance
  issues involves counting the quantity of
  transmissions made.

7
Step 5 Database Efficiency Problems

• In the databases itself, it is important to look
  for the same things that cause client/server
  programs to run gradually.
• However, additional web application features can
  cause other performance issues in the databases.

8

• Thank You