Title :
Self-Tuning for SQL Performance in Oracle Database 11g
Author :
Belknap, Pete ; Dageville, Benoit ; Dias, Karl ; Yagoub, Khaled
Author_Institution :
Oracle USA, Redwood Shores, CA
fDate :
March 29 2009-April 2 2009
Abstract :
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.
Keywords :
SQL; Oracle database 11g; SQL performance tuning; SQL tuning advisor; automatic SQL tuning; commercial database customers; database administrators; Concurrent computing; Histograms; Indexes; Performance analysis; Sampling methods; Spatial databases; Statistical analysis; Statistics; System testing; Tuning; SQL tuning; self-managing; self-tuning;
Conference_Titel :
Data Engineering, 2009. ICDE '09. IEEE 25th International Conference on
Conference_Location :
Shanghai
Print_ISBN :
978-1-4244-3422-0
Electronic_ISBN :
1084-4627
DOI :
10.1109/ICDE.2009.165