Based On ORACLE Database Performance Tuning Technology Research

With the expansion of the size of the database, the increase in the number of users, databases, application systems in response to the rate of decline in performance problems become increasingly acute. In order to improve the performance of the system, in general from a number of aspects, such as raising the computer hardware and network equipment level, increase the network bandwidth to improve its response time. But this is only the stage, and the high cost, difficult to increase the overall system efficiency and performance of the purpose of the database system performance tuning and optimization for the normal operation of the entire system plays a vital role. Database performance tuning and optimization involves a number of levels, through unified planning and analysis to make corresponding adjustments to improve the stability and availability of databases, security systems and efficient operation of the system to address bottlenecks in the system to save costs, has a good application Value, but also for theoretical research to provide some guidance method.This paper describes the database to optimize performance of the relevant research background, the significance of paper topics, as well as optimize the performance of the database structure, optimize performance related to the concept of performance evaluation as well as the optimization of the main database, according to the Guangzhou-Shenzhen railway booking system to optimize the practice of combining Oracle 9i database using the experience of SQL statements, Oracle memory allocation, as well as disk I/O in areas such as performance optimization as a major study, carried out an in-depth analysis and discussion, given normal circumstances, Oracle database applications Performance Optimization.