DocumentCode :
3125608
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
fYear :
2009
fDate :
March 29 2009-April 2 2009
Firstpage :
1694
Lastpage :
1700
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;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Data Engineering, 2009. ICDE '09. IEEE 25th International Conference on
Conference_Location :
Shanghai
ISSN :
1084-4627
Print_ISBN :
978-1-4244-3422-0
Electronic_ISBN :
1084-4627
Type :
conf
DOI :
10.1109/ICDE.2009.165
Filename :
4812594
Link To Document :
بازگشت