| Oracle Database is increasingly widely used for various applications in the background data storage tool. Typically, with the system operation, the upper application increases, the amount of data grows, the consumption of the hardware and software resources, the application system will appear a certain performance problem. Ultimately vary depending on the system performance under the conditions of limited hardware resources, a system availability. Performance analysis and optimization is essential and necessary. Oracle optimization theory and technology are relatively mature, but for a particular type of system, but the lack of "tailored" system optimization solutions. In this paper, I participated in Guizhou provincial data center deployment and more of the background of project practice based on the the core land tax collection and management system of data mining and use of decision-support systems, summarized and summed up the design and implementation of performance analysis and optimization techniques, provide reference and experience for similar large-scale industry applications.This article discusses the following process:First of all, the Oracle optimization of technologies, including SQL optimization, indexes, partition table, materialized view, Oracle memory parameters adjustment and RAC with DataGuard. The main principle is described, as a follow-up optimization theory pave the way for practical work;Secondly, combined with the author’s project practice, summed up the RAC cluster building programs in the case of real needs, the hardware environment configuration and the specific method. Summarizes the specific method based on the project background and application needs of large amounts of data tables Optimization Strategies and partition table. As well as a combination of experiments and actual project experience, summarized the design and implementation of the materialized view and multi-level materialized view... |
PDF Full Text Request