| The database’s performance in recent years, more and more concern and attention of themajority of enterprises. Causing this reason boils down to is that in the era of rich informationresources, the Internet and storage technology is more mature, and added a bit of pressurewith a sense of urgency due to the database, database technology to explore more and moredemand. Database in the era of the large amount of data, not only to complete the data, thetask of storing data, but also to be able to run smoothly no problems, but also has goodprocessing ability to withstand the pressure in emergencies. With the serious problem ofdatabase products even more perfect data collapse has been less and less frequency ofoccurrence is becoming less and less, attention focused on the system performance. Theexplosive growth of data, the database as the most direct treatment and management softwaredirectly bear the greatest responsibility. The system performance faster the higher the numberof concurrent requirements, the stronger the data dependency, database performanceoptimization has become an urgent need to solve urgent a hot research field. In this thesischoose from a number of database products, which is widely used, representative ORACLEdatabase products for in-depth study and discussion.Nowadays, databases are widely used in e-commerce sites, the two types of data analysissystem, OLTP, OLAP typical representative system, the increasingly high demand for datastorage and access, additions and changes to the database pressure surge The performancerequirements are also increasing. For each enterprise is concerned, the data is their core, howto put the peace of mind of their own data, with the assured, every enterprise is veryconcerned about important issues. Faced with the pressure of the data, so that the enterprisetechnically difficult to use and manage their own data, the enterprise itself not only the use ofdata can not be arbitrary, but the management that they become a burden. Of this thesis is tostudy how many products to choose their own enterprises own needs, how to apply theexisting database technology, the most important is how we can use it to provide convenientservices for their own scientific and rational. In this paper, in the ORACLE database using the process, a common type of resourcebottlenecks, analyze and on this basis, the parameter adjustment of the operating system fromthe server, ORACLE database parameter adjustment, the network performance tuning,application structure and the SQL statement analysis and design and other aspects wereelaborated. ideas and steps of determining the optimal first demand from the optimization tooptimize the design, and eventually to the optimization of the details. Target to be specificallyoptimized to optimize where to start, as well as how to detect where solved object. Finally, bysummarizing a large number of performance experiments to introduce common tools andmeans of detection, and to analyze the details of the code performance impact and practicaldesign case.This article is summarized from the hardware and operating system-level memorymanagement, disk I/O control, CPU usage optimization adjustment strategy of memorymanagement. Evenly balanced between the disk I/O, to minimize disk access time, andprovide a number of disk I/O optimization strategy. Introduction the ORACLE databaseparameter file system performance parameters of the function and modify describes how tominimize the access network data, network data access into a database access operations, soas to improve system performance. addition, the merits of the application design will directlyaffect the performance of the entire database system, SQL statements as key to the design ofthe application. optimal adjustment of the SQL statement. summarizes some adjustmentsprinciple of the SQL statement; summarizes some important object index as a SQL statementexecution efficiency in the process of application development or use some practical tipsindex. |
PDF Full Text Request