Research on Improving Oracle Query Performance in MES

De Yu Zhao

doi:10.4028/www.scientific.net/AMM.201-202.39

Paper Titles

A Study of High Intensity Focusing Ultrasonic Transducer
p.20

Improved Design of 2-DOF Micro-Positional Stage Based on Parallel Structure with Flexible Sheet
p.24

The Influence of Pillow Material on Body Distribution and Sleeping Comfort in Supine Position
p.30

The Uncertainty Analysis of Health Management Strategies for Aero-Engines
p.34

Research on Improving Oracle Query Performance in MES
p.39

Winding Modeling and Driving Method of Varying Length Rope Based on ADAMS
p.43

Representing the Reasoning Process of Shape Transformations in Sketches by Combination of Ontology and Shape Grammar
p.47

A New Type Design of Lighting Current Strength Detection Sensor
p.51

Design of Combined Cam Used in the New Jacquard Device Based on PROE and AutoCAD
p.56

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 201-202Research on Improving Oracle Query Performance in...

Research on Improving Oracle Query Performance in MES

Abstract:

The tuning for Oracle database system is vital to the normal running of the whole system, but it is a complicated work. SQL statement tuning is a very critical aspect of database performance tuning. It is an inherently complex activity requiring a high level of expertise in several domains: query optimization, to improve the execution plan selected by the query optimizer, access design to identify missing access structures and SQL design to restructure and simplify the text of a badly written SQL statement. In this paper, the author analyzes the execution procedure of oracle optimizer, and researches how to improve the oracle database query performance in MES.