Performance Tuning and optimization principles for Oracle online transaction processing Systems

Many organizations have an online transaction processing system. This type of system is characterized by:

There are high data update activities that are typically performed by a large number of users.

A large number of users concurrently access the database.

The data is growing continuously.

Examples of such applications are supermarket sales systems, air ticketing systems, bank deposit and withdrawal systems, online stores, and so on. The following illustration shows the basic characteristics of an OLTP system:

The OLTP system is running with some of the following requirements:

High Availability (7*24).

High response speed.

High concurrent processing capability.

Fast recovery of failures.

In order to meet the above requirements, we should consider adjusting the database application system from the following aspects.

1. In order to prevent Oracle from dynamically allocating storage space for database objects and affecting system performance, it is important to check the space usage and distribution of objects and allocate storage space manually for tables, indexes, and clusters.