Research Of The Telecom Enterprise Database Platform Performance Tuning Base On Oracle

With the advent of the era of mobile Internet, mobile business is becoming the focus of scientific and technological development has brought tremendous opportunities and challenges for telecom enterprises, with this background, the performance of the telecommunications enterprise computer applications become more demandingdatabase system performance largely affects the performance of the entire computer application system, with the continuous development and status of mobile services, telecommunications enterprise database system has encountered a performance bottleneck, optical rely on additional hardware investment has been unable to meet the growingthe growth in the amount of data, such as add a large server cluster or to Additions server with more memory and disk array, but this will be very costly, can not fundamentally resolve performance bottlenecks.First, database performance tuning research background papers significance of the topic, including the tuning concept home and abroad Oracle database tuning status quo.Secondly, the evaluation index of the database system performance, pointed out that the main aspects of the evaluation of a database system performance include system throughput request response time, database hit rate, the percentage of the soft parse the synchronization time of the log file, disk I/O performance other aspects, these indicators reflect very intuitive to reflect the performance of a database system. Provide a theoretical basis for the subsequent tuning.Then, from a broader perspective, explained the main aspects of tuning needed for a database system, including the configuration of the operating level, adjust the memory allocation, adjust the disk I/O, adjust the rollback segments of the database system, roughly from these aspects to improve the performance of the database system as a whole.Then, by explaining from the database system configuration instance, SQL statement tuning method, these methods for operating basis and theoretical basis for follow-up based on Oracle’s the telecommunications enterprise database system tuning, such as database systems ranging from hardware configuration optimization aspects of the OS side, install Oracle initial value, the configuration of components, adjust these aspects of database objects to configure the database tuning purposes. Configuration is complete, in the process of running in the database, but also the need to tune the database instance. Finally, the SQL statement tuning specification developers writing SQL statements, and to improve the efficiency of the query. These aspects together in order to enhance the overall performance of the database.Finally, the actual tuning the billing database systems for telecommunication enterprises in the previous chapter, the theory and operation on the basis of further billing database tuning, including adding an index using the partition, partition indexes, etc., as the previous Chapter supplement for further implementation of the telecommunications enterprise billing database performance tuning.Database system performance tuning for the normal operation of the system as a whole plays a vital role. Database performance tuning involves multiple aspects, includes not only the configuration parameters of the database system itself, to combine the specific operating system platform, the corresponding configuration, the perfect combination of the database system and operating system platforms, such as system resources allocation, memory allocation, virtual memory size, data files in the disk array distribution disk the I/O, etc., will be multi-faceted parties combined in one, in order to effectively solve the database system’s performance bottleneck, saving the overhead of a good application value theoretical research also provides a certain methodological guidance.The entire database tuning process has a very strong corporate background, requires a combination of the actual situation of the the telecommunications enterprise database system, rather than according to the existing tuning manual operation, with respect to the common tuning manual has many personalized tuning this is a difficulty in the whole tuning process. How to analyze the actual situation to make corresponding adjustments, such as the allocation of the SGA size should be adjusted according to the system load for each period, which requires the operator has a very deep background of the telecommunications enterprises.Based on this background, the paper will be based telecommunications enterprise database system tuning process, combined with the use of the Oracle database experience, will be the operating system configuration database system configuration parameters instance to optimize performance tuning and optimization problems as the main content, launched a detailed exposition.