Proceedings - International Conference on Data Engineering · 2009 · 51 citations · 2 references
ComputingComputer ScienceInformation TechnologyDatabasesDesign AutomationPerformance MeasurementDatabase AdministrationDatabase ManagementPerformance EvaluationPerformance OptimizationPerformance TuningStructured Query LanguageApplication Performance TuningAuto-tuningDatabase BenchmarkingDatabase Bottleneck AnalysisQuery Performance MonitoringQuery Performance TuningSystem Tuning
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.
2
Automatic Performance Diagnosis and Tuning in Oracle
Karl Dias, Mark Ramacher, Uri Shaft et al. · Conference on Innovative Data Systems Research · 2005 · 102 citations
Oracle's Self-Tuning Architecture and Solutions.
Benoît Dageville, Karl Dias · 2006 · 33 citations