Study On Performance Optimization Of Oracle Database Base On 12530 Website

China mobile musical website (website: www.12530.com, referred to as "12530 website") is a wireless musical comprehensive website which contains downloading coloring ring back tone, mp3 audition, and so on. At the beginning of the website built, the database servers were established in Chengdu high-tech development west zone, and the network architecture only owned one node in Chengdu. With the increasing number of customer in recent years, the website's visiting speed becomes slow, so that, the 12530 website is obliged to be rebuilt and optimized, and the focus on two aspects is to reform and optimize the database and network architecture.The main research is based on the 12530 website Oracle database of this dissertation optimization, containing physical optimize and logical optimize to website. First of all, the structure of original database based on 12530 website should be optimized, the method is to construct Beijing, Shanghai and Guangzhou database system to achieve distributed database system architecture in four nodes, realize optimization of the 12530 website Oracle database in physical aspects through the method that sharing in user visit data. Secondly, optimization of Oracle database in logical aspects contains adjusting SQL statement, adjusting disk allocation, creation index and adjusting memory allocation. The principle and the goal of each optimization technique are analyzed respectively, furthermore, based on 12530 websit Oracle database system, the four technologies which contain adjusting SQL statement structure, creation table partition, creation index and adjusting memory allocation base on 12530 websit Oracle database system is instance optimization on different query statement application. The data can be got through the trace of the statement's execution plan. Finally, the conclusion can be summed up through comparison and analysis which is based on the statements's execution plan and statistical information between before execute of optimization and execute of optimization. Through these methods above, the 12530 website Oracle database in logical aspects can realize optimization.Through the two aspects of physical and logical optimization research, the 12530 website Oracle database capacity can be promoted, moreover, the exclusive capacity will play a great important role in the following website Oracle database system optimization through the optimized methods which are put into use.