2, 2, adjust the application structure design. This part was also completed before the development of information system. Programmers need to consider what kind of architecture the application uses, whether it uses the traditional client/server two-tier architecture or the browser /Web/ database three-tier architecture. Different application architectures require different database resources.
3, 3, adjust the database SQL statements. The execution of application will ultimately come down to the execution of SQL statements in the database, so the execution efficiency of SQL statements ultimately determines the performance of ORACLE database. ORACLE recommends using ORACLE statement optimizer and row-level manager to adjust and optimize SQL statements.
4, 4, adjust the server memory allocation. Optimize the memory allocation during the operation of the information system, and the database administrator can adjust the sizes of data buffer, log buffer and * * * shared pool in the global area (SGA area) of the database system according to the operation of the database. You can also resize the program global area (PGA area). It should be noted that the larger the SGA area, the better. If the SGA area is too large, it will occupy the memory used by the operating system, cause page exchange of virtual memory, and reduce the system.
5, 5, adjust the hard disk I/O, this step is completed before the development of information systems. Database administrators can put the data files that make up the same tablespace on different hard disks to achieve I/O load balance between hard disks.
6. Adjusting operating system parameters, such as ORACLE database running on UNIX operating system, can adjust the size of UNIX data buffer pool and the memory size that each process can use.
In fact, the above database optimization measures are interrelated. The performance deterioration of ORACLE database is basically the long response time of users, which requires users to wait for a long time. However, there are various reasons for the deterioration of performance, and sometimes multiple factors lead to the deterioration of performance, which requires database administrators to have comprehensive computer knowledge and be sensitive to the main reasons that affect database performance. In addition, a good database management tool is also very important for optimizing database performance.