Oracle performance tuning based on Client/server

Absrtact: By discussing and studying the characteristics and principles of Oracle Server and Client/server, this paper expounds some principles and methods of improving and adjusting the performance of Oracle Application system.

Keywords: Oracle; client/server; system whole zone; network I/O; rollback segment.

Oracle database is widely used in all areas of society, especially in Client/server mode, but application developers often encounter the problem that the performance of the whole system decreases significantly with the increase of data volume, in order to solve this problem, from the following aspects: Database server, network I/O, Applications, such as the entire system to adjust to give full play to Oracle's effectiveness, improve the performance of the entire system.

1 tuning the performance of the database server

Oracle database server is the core of the whole system, its performance directly affects the performance of the entire system, in order to adjust the performance of the Oracle database server, mainly from the following considerations:

1.1 Adjusting the operating system for Oracle database server operations

The Oracle database server relies heavily on the operating system running the server, and if the operating system does not provide the best performance, the Oracle database server will not be able to perform its due performance anyway.

1.1.1 Planning system resources for Oracle database servers

According to available resources for computers, the principle of planning assigned to Oracle server resources is to maximize the use of resources by Oracle servers, especially in Client/server, so that all resources on the server are running Oracle services as much as possible.

1.1.2 Adjust the memory configuration in the computer system

Most operating systems use virtual storage to simulate larger memory on a computer, which is actually a certain amount of disk space on the hard disk. When the actual memory space does not meet the requirements of the application software, the operating system will use this part of the disk space for the information in memory to replace the page, which will cause a lot of disk I/O operations, so that the performance of the entire server down. To avoid excessive use of virtual storage, you should increase the memory of your computer.

1.1.3 set operating system process priority for Oracle database servers

Do not adjust the priority of the Oracle process in the operating system, because all background and foreground database server processes perform equally important tasks in an Oracle database system, requiring equal priority. So at installation time, all the database server processes are running with the default priority.

1.2 Adjusting Memory Allocations

The Oracle database server retains 3 basic memory caches, corresponding to 3 different types of data: the library cache, the dictionary cache, and the buffer cache. The library cache, together with the dictionary cache, forms a shared pool, and a shared pool plus buffer cache forms the whole system area (SGA). SGA is a fast access to the database of a system of the whole area, if the SGA itself needs to be frequently released and distributed, it can not achieve the purpose of fast access to data, so the SGA should be placed in main memory, do not put in virtual memory. Memory adjustment mainly refers to adjusting the size of the memory structure of the SGA to improve system performance, because the memory structure requirements of the Oracle database server are closely related to the application, so the memory structure should be adjusted before disk I/O adjustment.