The Study of Adjustment and Optimization of Oracle Database in Information System

Author

Zheng Ling ; Li Qi ; Zhang Qianyuan ; Chen Wei

Author_Institution

Sch. of Control & Comput. Eng., North China Electr. Power Univ., Beijing, China

fYear

2013

fDate

21-23 June 2013

Firstpage

442

Lastpage

445

Abstract

With the increasing amount of data of information system, it is necessary to adjust the performance of oracle database and optimization, in order to meet the demand of long-term use of the information system´s data. In this article, based on oracle database performance evaluation and influence factors analysis, we choose a method for better improvement and study of oracle memory structure, and find a way to adjust and optimize the memory allocation, after that apply it to the existing information system. Finally, through the comparison of the oracle database performance change, we come up with the idea that adjust memory allocation can improve database performance of information systems.

Keywords

database management systems; information systems; influence factors analysis; information system; memory allocation; oracle database performance evaluation; oracle memory structure; Database systems; Memory management; Operating systems; Optimization; Servers; database adjustment and optimization; information system; oracle database; oracle memory structure adjustment;

fLanguage

English

Publisher

ieee

Conference_Titel

Computational and Information Sciences (ICCIS), 2013 Fifth International Conference on

Conference_Location

Shiyang

Type

conf

DOI

10.1109/ICCIS.2013.123

Filename

6643038