电脑知识与技术
電腦知識與技術
전뇌지식여기술
COMPUTER KNOWLEDGE AND TECHNOLOGY
2013年
13期
2943-2944
,共2页
ORACLE数据库%性能优化%索引%sql语句
ORACLE數據庫%性能優化%索引%sql語句
ORACLE수거고%성능우화%색인%sql어구
Oracle database%performance optimization%Index%The SQL statement
随着数据库在生活中各个领域中的广泛应用,数据库产品也层出不穷.其中,ORACLE数据库产品在整个数据库产品的应用中占据50%,并且有不断上升的趋势.可是,随着数据库数据量的增大、并发用户数量增多,系统常常出现吞吐量降低,响应时间延长等性能问题,怎样有效优化、改善数据库性能,突破系统瓶颈,是保证Oracle数据库高效运行的基础.Oracle数据库系统性能优化、调整是一项复杂的系统工程,贯穿于系统的整个生存周期中.
隨著數據庫在生活中各箇領域中的廣汎應用,數據庫產品也層齣不窮.其中,ORACLE數據庫產品在整箇數據庫產品的應用中佔據50%,併且有不斷上升的趨勢.可是,隨著數據庫數據量的增大、併髮用戶數量增多,繫統常常齣現吞吐量降低,響應時間延長等性能問題,怎樣有效優化、改善數據庫性能,突破繫統瓶頸,是保證Oracle數據庫高效運行的基礎.Oracle數據庫繫統性能優化、調整是一項複雜的繫統工程,貫穿于繫統的整箇生存週期中.
수착수거고재생활중각개영역중적엄범응용,수거고산품야층출불궁.기중,ORACLE수거고산품재정개수거고산품적응용중점거50%,병차유불단상승적추세.가시,수착수거고수거량적증대、병발용호수량증다,계통상상출현탄토량강저,향응시간연장등성능문제,즘양유효우화、개선수거고성능,돌파계통병경,시보증Oracle수거고고효운행적기출.Oracle수거고계통성능우화、조정시일항복잡적계통공정,관천우계통적정개생존주기중.
With the wide application of the database in the life of every field, database products also emerge in an endless stream. Among them, ORACLE database products occupy 50%in the whole database products, and there is a rising trend. However, with the increase of the amount of data in the database,the increase in the number of concurrent users. System often appears low throughput,extension of response time and other performance problems. How to effectively optimize, improve database perfor?mance, breakthrough the bottleneck of system, is to ensure efficient operation of the Oracle database. Oracle database performance optimization, adjustment is a complicated system engineering, runs through the whole system life cycle.