面向HIS应用的ORACLE数据库性能优化的研究与实现-软件工程专业毕业论文.docxVIP

摘囊摘要 摘囊 摘要 目前国内医院采用ORACLE作为医院信息系统数据库的比例达到40％以 上，但是很多医院的ORAcLE数据库运行并不顺畅，主要原因是ORACLE数 据库运行性能没有调整好。本文作者在宁波市第一医院的ORACLE数据库性能 调优实践中进行了系统的研究和探索。 数据库系统的优化凋整是医院数据库管理中 项重要的任务，使数据库系 统的运行效率不断提高，一直是医院数据库系统管理员不断追求的目标。本文 对0raele 9i的优化调整技术进行了探讨，并提供了进行系统优化、充分发挥 0ratl e数据库性能、使Oracl e数据库应用系统达到最优的一些方法和策略。 首先介绍Oracle数据库的体系结构，然后从数据库优化的原因，影响 Oracle性能的因素，优化过程和目标，CPU调整，操作系统参数调整，内存调 整，磁盘I／0调整，应用程序的调整这几个方面来具体讨论，最后给出了优化 解决方案和宁波市第一医院ORACLE数据库优化后的性能状况。 关键词：Oracle数据库，性能，优化 AbstractAbstract Abstract Abstract In our country,40 percent of the hospitals select The Oracle as the database platform of hospital information system(HIS)application．But in many hospitals，the Oracle database is not running very well，because the Oracle instance is not optimized．During the optimizing and tuning a database system of HIS application in Ningbo No．1 hospital，the author of this paper has done systemic research on optimizing and tuning Oracle database system Optimizing and tuning a database system is a very important task of database management in hospital．Raising the operational efficiency of the database system constantly is what the database system manager is pursuing all the time．This paper discusses the optimizing and tuning technology in Oracle 9i and provides a number of methods and strategy to optimize the system．exen the Oracle’s software function to make the oracle database application system perform best． This paper firmly discusses the system structure of oracle database．Next，it discusses the reasons for tuning database performance，the factors that affect oracle performance，the process and the goal of tuning and how to tune CPU，operating system，memory parameter,disk YO and application program．Lastly,this paper offers a solution to optimizing and tuning Oracle database of HIS application，and also gives some statistic data which show the behavior of HIS Oracle in Ningbo No，1 hospital after the realization ofoptimization． Keyword： Oracle database，Performance，Optimization V1I 学位论文版权使用授权书本人完全了解同济大学关于收集、保存