Regulation And Optimization Of The Performances In The Oracle Database

Nowadays, database is widely used, and because the data volume is much bigger and data process is much more complex than before, the requirement of the database performance is getting higher. How to take full advantage of the hardware and software resource to improve the database performance becomes a hot topic.Since 2001,this management of information system has been used smoothly in a certain power supply company, but along with the increase of time, information and users, this system becomes slowly and spends a lot of time to query, whose history data can't be backup and delete. Aim at these two problems, optimization technology is used on the aspect of tuning index, adjusting memory and partition.On the aspect of index tuning, aim at the system table and data table in which there are a lot of indexes that are out of use, the paper adopt the means that drop those indexes to reduce the cost of maintenance.On the aspect of memory allocation, aim at the problem brought from the wrong setting in SGA that makes physical reads in disk frequently, the paper gives a solution to enlarge the shared pool and tune the parameter to reduce the users' waiting time by querying and analyzing the data from the view V$SYSSTAT.On the aspect of partition, in order to reduce respond time and the load of backup and delete some history data and avoid the whole table scan, this paper puts forward a solution to split the big table up into a few of partitions and scan them based on requirement.Based on the system, the paper adopts corresponding performance optimization technologies to optimize concrete instances. Through a large amount of experiments, it compares and analyzes performance evaluation index before and after using every optimization technology, and in the meantime, proposes some concrete performance tuning approaches and strategies.