Title :
Research on Performance Optimization and Implementation of Oracle Database
Author :
Li, Qun ; Xu Honglin ; Yan, Guo
Author_Institution :
Sch. of Comput. Sci. & Technol., Nan Jing Univ. of Sci. & Technol., Nanjing, China
Abstract :
Oracle is the most widely used large-scale database in business society at present, and its performance influences the efficiency of application directly. This paper starts with basic principles of performance optimization of database, then presents some optimize technologies in two phases of database running. Experimental results show that: the database optimization can improve the disposing performance of the database and also decrease the client response time.
Keywords :
relational databases; very large databases; Oracle database; client response time reduction; database performance optimization; disposing performance improvement; large-scale database; Application software; Business; Deductive databases; Delay; Design optimization; Hardware; Indexes; Information technology; Optimized production technology; Statistics; SQL; optimize; oracle database; performance;
Conference_Titel :
Intelligent Information Technology Application, 2009. IITA 2009. Third International Symposium on
Conference_Location :
Nanchang
Print_ISBN :
978-0-7695-3859-4
DOI :
10.1109/IITA.2009.7