2011•Computer Knowledge and TechnologyRequires access

Research on Oracle Database Performance Optimization

Guo Xia

Abstract

Oracle performance optimizer will directly affect the efficient operation of database application system.This article discusses the Oracle database performance optimization objectives,and analyzes the factors affecting performance in every other sides.And the adjustment and optimization of database,memory,I/O,and SQL statements is presented and explained in detail.And finally proved by experiments,after optimization,Oracle database performance has been improved and enhanced.

About this research paper

What this paper is about

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Computer science, Oracle, Oracle Unified Method, Database, Oracle database, SQL, Database tuning, PL/SQL