Researching & Practice On Performance Oriented ORACLE Database SQL Tuning

With the rapid development of informatization progress,the connection between a growing number of users and a wider range of industries has caused the amount of data generated by worldwide companies to grow at a rate that doubles every two years.Database is the most important storage and management platform for carrying all kinds of data,and its performance problems have become increasingly prominent.Data is becoming an increasingly important new type of asset.ORACLE database is a relational database system launched by Oracle Corporation.So far it still has nearly 50% market share.As the NO.1 relational database,to explore the optimization principle and to verify the effectiveness of optimization methods would have a practical significance and practical value.Firstly,this topic introduces the development status of database optimization technology domestic and overseas,and conducts detailed research on the knowledge points involved in the optimization of SQL statements in Oracle database.Including the processing mechanism of the query statement,the components of the optimizer,the method of the table scan,the classification meaning and the viewing method of the statistical information,the interpretation of the execution plan and the introduction of the upgrade algorithm.Secondly through the combination with optimization principle and theoretical support as well as specific project practice,I have designed the overall process of SQL optimization including optimization ideas and optimization methods targeted for performance improvement.The SQL optimization process designed by this topic has a certain degree of versatility,which provides a basis for further research and exploration of optimization mechanisms for different Oracle versions and even different types of databases.Finally,this essay takes the Sony mobile actual project—Sony product order and logistics information database as the research background.This system was delivered and used since 2005,with the growth oDf data,users have experienced problems such as slower query speeds and bottleneck speeds in file storage.We need to give detailed analysis and diagnosis of the company's business applications in the SQL statement,check out the impact of the performance of the SQL statement and gives an instructive optimization solution.Then,by comparing the CPU?IO and memory consumption before and after the implementation of the optimized solution to judge the effectiveness of the optimization method,improve the SQL statement with short execution time and low resource consumption.