oracle数据库的运行状况管理系统的设计与实现软件工程专业论文.docxVIP

AbstractAbstract Abstract Abstract ’I’he number of Oracle database numerous iS numerous currently,meanwhile database administrators also face several sets，or even tens of hundreds of database maintenance requirements．A few Oracle database system have potential safety hazard and performance problems which include unreasonable parameter setting，irrational allocation database，unreasonable application design，poor performance of SQL statements and SO on．IT executives and systems admits don’t master the overall running status of system，which makes them aren’t able to propose improved tips and expansion proposal． It is vital to improve the level of database maintenance，make rational use of effective tools for database maintenance，display database performance visual status， increase customer perception and prevent potential future risks．The project is designed to build enterprise-class database system running status and optimize system． Using this system，enterprise operations center Can carry system integrated monitor on Oracle database．It includes that all database status，check the engine，the database information analysis results，Auxiliary function result analysis，event management， statement analysis based on historical performance data，parameter management， configuration management database，application design optimization analysis，etc．， providing the database operations tools to implement and performance test of SQL statements，defragmentation，table space optimization，rebuild index．At the same time， the integrated optimization system can make a complete optimization recommendation which is based on database system problems．Finally,we carry out the test and analysis of several big databases including enterprise marketing system database by configuring server client and other related experimental environment,and a series of verification afterwards．The result shows that the system Can massively improve the performance and reduce the recovery time after failure． Key Words：Orac