SQL tuning base

• US 20050097091A1
• Filed: 09/07/2004
• Published: 05/05/2005
• Est. Priority Date: 09/06/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Bodagala, Sreenath, Vivian, Stephen J., Tsukerman, Alex, Ramacher, Mark, Dageville, Benoit, Ziauddin, Mohamed
• Granted Patent: US 8,983,934 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/24549 Run-time optimisation
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A computer readable medium storing a database query language statement tuning base in a tuning base memory location is disclosed. The tuning base includes tuning information for one or more query language statements. The tuning information for each statement includes one or more tuning actions for the statement, and a signature to allow an optimizer to identify the one or more tuning actions for the statement.

Claims

1. An article of manufacture comprising a computer readable medium storing a tuning base in a tuning base memory location, the tuning base comprising:

tuning information for one or more database query language statements, the tuning information for each statement comprising

one or more tuning actions for the statement; and

a signature to allow an optimizer to identify the one or more tuning actions for the statement.

2. The article of claim 1, the one or more tuning actions for the statement comprising:

tracing information collected during one or more previous executions of the statement.

3. The article of claim 1, the one or more tuning actions for the statement comprising:

an outline to persistently represent an execution plan of the statement.

4. The article of claim 1, the one or more tuning actions for the statement comprising:

a profile to persistently represent tuning hints to influence a generation of an execution plan of the statement.

5. The article of claim 1, the computer readable medium further comprising:

one or more SQL statements stored in a second memory location that is independent of the tuning base memory location.

6. The article of claim 1, wherein the signature for each statement is based on a normalized text of the statement.

7. The article of claim 1, wherein the database query language statements are SQL statements.