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