Self-tuning for SQL performance in Oracle Database 11g
P Belknap, B Dageville, K Dias… - 2009 IEEE 25th …, 2009 - ieeexplore.ieee.org
P Belknap, B Dageville, K Dias, K Yagoub
2009 IEEE 25th International Conference on Data Engineering, 2009•ieeexplore.ieee.orgCommercial 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.
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.
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.
ieeexplore.ieee.org