摘要
Oracle数据库的性能优化问题一直是决策者及技术人员共同关注的焦点,影响数据库性能的一个重要因素就是SQL查询语句的低效率。阐述了几种常见的Oracle数据库的性能优化技术,如数据库设计的优化、I/O优化、数据库各种动态参数的调整,并着重讨论了SQL语句的查询优化。从查询优化的测试结果来看,系统的响应时间明显降低,系统运行效率得到提升。
The problem of Oracle database's performance optimization has been the focal point which the decision-maker and the technician show solicitude for commonly,and a key factor affecting the database's performance is that low efficiency of the SQL query sentence.Several kinds of common Oracle database's performance optimization techniques were elaborated,such as database design's optimization,I/O optimization,the adjustment of various dynamic parameters of database,and the SQL sentence query optimization was discussed emphatically.Judging from the results of query optimization test,the system's response time reduces obviously and the system's operation efficiency obtains the promotion.
出处
《计算机与数字工程》
2010年第11期173-178,共6页
Computer & Digital Engineering
基金
江苏省科技厅"青蓝工程"优秀青年骨干教师计划项目资助