南阳理工学院本科毕业设计（论文）基于ERP系统的数据库性能优化分析MakesdatabaseperformanceoptimazitionanalysisbaseonERPsystem学院（系）：计算机科学与技术系专业：计算机科学与技术学生姓名：许培洪学号：64107077指导教师（职称）：王秋芬(讲师)评阅教师：完成日期：2011年5月南阳理工学院NanyangInstituteofTechnology基于ERP系统的数据库性能优化分析计算机科学与技术专业许培洪［摘要］随着信息技术的不断发展，中小型企业信息化建设越来越重要，采用先进的企业资源计划（ERP）系统已势在必行。ERP是顺应时代要求的信息技术与企业管理新思想相结合的产物。对商业套装软件进行性能优化是比较困难的,但仍有机会对它进行调优.只要对应用系统有正确的理解,提供时间和相关资源,IT团队就能够改善复杂关键应用的性能。本文在系统分析研究ERP原理的基础上，通过对系统开发与实现过程中所涉及的理论和技术的研究，分析了ERP系统的功能模块结构，对后台oracle数据库做性能优化分析，并做持续跟踪优化。[关键字]ERP;IO，负载均衡，AWR，响应时间，并发MakesdatabaseperformanceoptimazitionanalysisbaseonERPsystemComputerscience&technologymajorXuPeihongAbstract:Withthefurtherdevelopmentofinformationtechnology,theinformatizationconstructionofsmallandmiddle-sizeenterprisesbecomesmoreandmoreimportant.TheuseofadvansedERPisontherightway.ERPisthethecombinationofinformationtechnologyandnewenterprisemanagementcompliedwiththedemandofera.Itiscomprasivelydifficulttoperformanceoptimazitionofthecommercialsoftwarepackage,butaslohaschancetomakeitperformbetter.Ifonlywiththecorrectcomprehensionofapplicationsystemandprovidingtimeandrelatedresources,ITgroupscanimprovetheperfomanceofcomplexandkeyapplication.BasedonthesystematicanalysisresearchonthetheoryofERPsystem,thisarticleanalysesthefunctionmodulestructureofERPsystemthroughtheresearchontheoryandtechnologyrelatedtosystemdevelopmentandimplementationprocess.Ttalsomakesperformanceoptimazitionanalysistothebackstageoracledatabaseanddoesthecontinuoustrackingoptimization.Keyword:ERP;IO;AWR;OutboundLoadBalancing;paratera;目录1.ERP系统的现状.......................................................................................................................12.ORACLE数据库体系结构.........................................................................................................22.1物理结构......................................................................................................................22.2逻辑结构......................................................................................................................22.2.1块(block)...........................................................................................................32.2.2区(extent)..........................................................................................................32.2.3段(segment)......................................................................................................42.2.4表空间(tablespace)...........................................................................................43.主机性能调优..........................................................................................................................43.1内存分配......................................................................................................................43.2CPU响应时间...............................................................................................................53.3IO和并发..............................
