Research And Development Of Memory Failure Automatic Diagnostic System For Oracle Database

Oracle database is the most widely used database in large-scale commercial environments all over the world.The database stability is a core content to ensure the normal daily operations of enterprise business,and the operation of database in memory is the core of the stable operation of database.In the process of database maintenance,it is of great significance to understand the source of database memory failure and solve the memory failure in time.An expert system,which can automatically analyze the log file,automatically judge the cause of the failure and provide solution,would be helpful to reduce the human judgment error and improve the efficiency of solving problems.This paper first describes the key technologies needed in system development.Including the relevant theories of expert system,this paper introduces the concept and development of the expert system,discusses the structure of expert system,knowledge base and inference engine in expert system,and the general function of the other modules.This paper introduces the concept and characteristics of C# language,and the relationship between the C# and the.Net framework.Then discuss the memory organization structure of Oracle database.Studies the basic composition of Oracle memory,the mechanism of memory allocation and release,and the working mode of memory on heap and block level,the role and function of the sub pool in memory,the role of the reserved area.Based on the above theory,and combined with the cases encountered in actual production,discuss the possible causes that trigger failure and possible solutions.Finally,using c#.net as the development language and Oracle database as background database,Develop an expert system for automatically analyzing logs and providing recommendations.Introduce the function design of each module in this system,as well as workflow,logical rules and the design of database tables.This system includes knowledge base and database management module,information acquisition module,diagnosing and reasoning module and man-machine interface module.Among them,the knowledge base summarizes the cause of dozens of real cases in recent years in whole China and their final solution,diagnosing and reasoning module design more than 20 logic rules,it analyze the info acquired by diagnosis information acquisition module to find solutions.This part also demonstrate operating interface of the system.Verify this system by actual cases,and summarize the verification results.