Study And Implementation On Performance Optimization Of Hospital Information System Based On Oracle Database

Oracle is the most widely used large-scale database at present. It can support almost all kinds of business forms and all kinds of complex transactions. It is regarded as one of the most adaptable relational database management systems and its performance influences the efficiency of application directly. With the trends of more scale, more complex and more concurrent connections, there are more and more performance questions such as the decrease of output, the increase of response time in the database system. Such systems’quality of service is so poor that they can not meet the customers’satisfaction degree.Hospital information system is the basis of hospital’s core business and it is crucial to the development of the whole hospital. It also faces severe performance questions after a few years development. In order to guarantee the quality of database system, we must tune and optimize the performance of database system and try our best to avoid the bottleneck of server performance.At first, the hospital information system is analyzed in detail to know which components and levels have bottleneck and the objective of the optimization to database. And then the techniques of database optimization are adopted to settle these problems. The main work of this paper is as follws:(1) Memory optimization is the key of performance optimization. The memory of Oracle database is reallocated. The hit ratios of library cache, dictionary buffers and data buffers are guaranteed and it can also support more concurrent connections at the same time.(2) There are big pressures in I/O sub-system at peak hours. In order to balance the I/O pressure and increase the system’s performance, the techniques of hierarchical-storages and time-sharing are adopted.(3) Monitor the database system’s dynamic views of performance to trace the bad SQLs which consumed plenty of resources such as CPU and memory. Rewrite these SQLs according to Oracle optimizer and technique of index.Database optimization is a durable process and it should run through the period of system running which can significantly increase the probability of success in resolving the problem. The situation of the hospital information system after tuning shows that: the optimization mean is effective and has achieved the expected result, it improved the disposing performance of the database to a large extent and also decrease the client response time.