Research And Application Of Tuninmg And Optimizing Database Performance In Management And Maintenance

Being a excellent tool of managing large database,Oracle is widely used invarious fields of modern society.The performance of processing vast array of data inOracle is paid more and more attention in the process of realizinginformatization.Along with accumulation of data and the increase of userssimutneously accessing the same data,its performance is immediately concerns theefficiency of DBMS.However,many users of Oracle are faced with problems of largedata storage,retrieval,and processing.Therefore improving the performance ofdatabase system is becoming the main problem to be solved to ensure the speed of thesystem.Performance optimization of database is a complicated work,database system ischanging frequently.In response to a variety of problems that occurred,DBAshouldanalyze various possible influence factors to performance according to his workingexperience，and choose appropriate measures to achieve the best conditions ofperformance under the actual conditions.The optimization of the performance ofDBMS includes:optimization of query,optimization of disk,optimization of hardwaresystem,optimization of network configuration and optimization of databasesystem.Among them,optimization of database system takes a key role in optimizingthe performance of DBMS.The thesis opens the discussion with common main influence factors to Oracledatabase system,such as server of DBMS,database configuration,network andstatistical information.It is based on techniques of performance optimization of actualwork,and it also summarizes the experience of DBA in daily management andmaintenance work.By analyzing in detail and contrasting before and after statisticaldata of optimization of database system,we can understand the vital role of theseoptimization techniques play in optimizing database system.Finally,it concludes thetechniques and rules about optimization of Oracle database system.It provides OracleDBA with relevant experience and reference,and therefore it has good practical value.