Self-Tuning for SQL Performance in Oracle Database 11g

@article{Belknap2009SelfTuningFS,
  title={Self-Tuning for SQL Performance in Oracle Database 11g},
  author={Peter Belknap and Beno{\^i}t Dageville and Karl Dias and Khaled Yagoub},
  journal={2009 IEEE 25th International Conference on Data Engineering},
  year={2009},
  pages={1694-1700}
}
Commercial database customers across the board list SQL performance tuning as one of the most time-consuming tasks for database administrators (DBAs). The 10g Oracle Database provides a feature called the SQL Tuning Advisor to simplify the task. The 11g release adds a new database feature, called Automatic SQL Tuning, that closes the feedback loop for the first time, fully automating the SQL tuning workflow and solving some SQL performance problems without any DBA intervention. 

Figures, Tables, and Topics from this paper.

Explore Further: Topics Discussed in This Paper

Citations

Publications citing this paper.
SHOWING 1-10 OF 33 CITATIONS

Automatic Tuning of Data-Intensive Analytical Workloads

VIEW 13 EXCERPTS
CITES METHODS & BACKGROUND
HIGHLY INFLUENCED

Xplus: A SQL-Tuning-Aware Query Optimizer

VIEW 12 EXCERPTS
CITES METHODS & BACKGROUND
HIGHLY INFLUENCED

An evolutionary approach to the index selection problem

  • 2011 Third World Congress on Nature and Biologically Inspired Computing
  • 2011
VIEW 7 EXCERPTS
CITES BACKGROUND & METHODS
HIGHLY INFLUENCED

An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning

Ji Zhang, Yu Liu, +9 authors Zekang Li
  • SIGMOD Conference
  • 2019
VIEW 2 EXCERPTS
CITES METHODS & BACKGROUND

References

Publications referenced by this paper.