基于ERP系统的数据库性能优化分析(许培洪))

基于ERP系统的数据库性能优化分析南阳理工学院本科毕业设计（论文）基于ERP系统的数据库性能优化分析MakesdatabaseperformanceoptimazitionanalysisbaseonERPsystem学院（系）：计算机科学与技术系专业：计算机科学与技术学生姓名：许培洪学号：64107077指导教师（职称）：王秋芬(讲师)评阅教师：完成日期：2011年5月南阳理工学院NanyangInstituteofTechnology基于ERP系统的数据库性能优化分析基于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;基于ERP系统的数据库性能优化分析目录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和并发......................................................................................................................53.4其他磁盘优化...............................................................................................................64.参数调优...................................................................................................................................65.SQL调优...................................................................................................................................75.1通过HINT来强制执行计划.........................................................................................75.2变量绑定.......................................................................................................................95.3使用索引.....................................................................................................................105.3.1管理组织索引.................................................................................................105.3.2聚簇的使用.....................................................................................................115.4使用分析函数.............................................................................................................115.5利用or代替unionall...............................................................................................126.总结和建议.............................................................................................................................146.1要有ORACLE优化意识...........................................................................................156.2优化有步骤可遵循.....................................................................................................156.3要做大基准测试.........................................................................................................166.4避免重复发明轮子.....................................................................................................166.5力求使用简单方法.....................................................................................................166.6设计非常重要.............