|
With the development of information, people pay more attention to Database performance, especially it need high-efficiency response or large database. Oracle Company alleged cost-based optimization and used it for years. For the reason of business, they don’t put foword to the inner theory about cost-base tool.It can be used rightly, but it owns the limitation that it don’t get inner course. Database tuninng is a complex and laborious job, it need to impenete the whole lifetime for system, where it was started.Oracle tunning included application programme tuning, databse circulation initial value, system circulate value and so on.This topic discussed the theory of Oracle cost-base optimization, function mechanism,cost speculation, embodied application,test and result analysis. At first,it introduced domestic and international database perfmance tunning methods,got knowledge of factor about Oracle perfmance effect Where we adjusted database,these tools can be needed.The second, we concentrated the emphases on Oracle index, query export result,then calculated cost formula in order to get inner run information. The third,we combined the item that named hunan pronvince tax administration and ratepaying evaluating system performancing.At last, we introduced a load testing tool Loadrunner, builded the testing scheme and aim.We tested the system before and after in order to prove system that whole performance exchanged or not.This topic put forward to new cost perfmance tunning of synthesization evaluation,it has some general use.They have the base that penetrate to more reasrach for Oracle or other relational databases.Where it get to upper work, this topic advanced new idea of index and query cost, such as standard index scatter instance, selectivity standard,can combine TPC-C tool test to get general evaluation standard.
|