Invention Grant
- Patent Title: Fully automated SQL tuning
- Patent Title (中): 完全自动化的SQL调优
-
Application No.: US12188975Application Date: 2008-08-08
-
Publication No.: US08903801B2Publication Date: 2014-12-02
- Inventor: Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
- Applicant: Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Techniques are provided for a fully-automated process for tuning database query language statements that selects database query language statements for tuning, tunes the database query language statements and generates tuning recommendations, tests the tuning recommendations, and determines whether to implement the tuning recommendations based on the test results. The fully-automated tuning process may also automatically implement certain tuning recommendations and monitor the performance of the database query language statements for which tuning recommendations have been implemented.
Public/Granted literature
- US20090077016A1 FULLY AUTOMATED SQL TUNING Public/Granted day:2009-03-19
Information query