Towards Self-Tuning of Dynamic Resources for Workloads

Abstract

In self-tuning of database performance research area, the optimization of dynamic resources is important. This paper focused on the self-tuning of dynamic resources on the base of feedback mechanism, designed and achieved a simple model combined with Oracle database. This model gave an evaluating principle of system performance, and could adjust system parameters automatically to achieve the goal of system performance. And an evaluation model was designed to evaluate the performance state of the running system. The result after the self-tuning of some parameters was illustrated by simulating various workloads.