Based On Oracle Database Perform Ance Tuning And Optimization Tech-Nology

Database technology is the fastest growing Computer Science and Technology, it is one of the areas most widely used, as the increasing degree of automation, Database technology has become the foundation and core of modern computer information systems and applications. with the growing amount of information, making the optimial and adjustment of the database has become an important issue, Because in most cases, there will be some performance issues when the database system in the running for some time, Mainly related to database system parameters, applications, database server hardware, database memory, operating systems etc, If the database system not in a timely optimize, it will seriously affect the performance of overall system. In this paper, the project of our laboratory about prototype of tax control system as the application background, from the database system parameters, applications, database system memory usage, the database application system during operation of the various performance issues that may arise to make the analysis, to address these issues the corresponding technical solutions were given, and detailed analyzing the process of currently database optimial used SQL statement optimial technology, adjusting database memory parameters technology, database backuping and recoverying technology. and the SQL statement adjustment algorithm based on mathematical in detail. Analysis of the characteristics of these technologies, and adjusting the algorithm for improved SQL. finally, for the general database in the process of database optimize used methods and steps was summarized, and in conjunction with my actual project experience and for Oracle database as an example, for reducing the system response time, improving the system throughput and fault tolerance relevant solutions were given. Then through a unified planning, systems analysis and make appropriate adjustments to improve the stability and availability of the database to resolve system bottlenecks, saving overhead, making it a good value.