2010•Mechanical Engineering & AutomationRequires access

Research on Oracle Database Performance Optimization

Xiao-Hong Han

Abstract

Database performance tuning will directly affect the efficient operation of database application system.This article discusses the Oracle database performance optimization strategy,objectives and methods,and introduces the configuration and use of Oracle database tuning tools for diagnosis in detail.And the adjustment and optimization of database memory,I/O,SQL statements and dynamic parameters of the database is presented and explained.Reasonable use of Oracle database tools and dynamic parameters can effectively improve the overall performance of database.

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: Oracle, Computer science, Database tuning, Database, Oracle Unified Method, Oracle database, PL/SQL, Database design