SQL tuning sets
First Claim
Patent Images
1. A computer implemented method, comprising:
- populating a plurality of database query language statements and corresponding performance information as a plurality of first persistent database objects in a database;
identifying, by using a processor, one or more database query language statements from the plurality of database query language statements and performance information for the one or more data base query language statements, whereinthe plurality of database query language statements are filtered based at least in part upon identification of the one or more high load database query language statements such that the set of the one or more high load query statements are identified by ranking and selecting the one or more database query language statements from the set of one or more high load query statements, in which at least one of the set of the one or more high load database query language statements are tuned by using at least a part of the performance information;
persistently storing the one or more database query language statements and a first performance information as one or more second persistent database objects, whereinthe first performance information is used to tune one of the one or more database query language statements as at least some of the one or more second persistent database objects,the first performance information comprises execution measurements and execution context corresponding to the one or more database query language statements, andthe execution context comprises at least one of a user schema, a name of an application issuing a query language statement, an action of an application issuing a query language statement, a list of bind variables, and system environment information.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for storing one or more database query language statements and performance information for each query language statement as a persistent database object. In one or more embodiments, the method and system stores the resource intensive statements and the performance information for each resource intensive statement as a second persistent database object.
196 Citations
21 Claims
-
1. A computer implemented method, comprising:
-
populating a plurality of database query language statements and corresponding performance information as a plurality of first persistent database objects in a database; identifying, by using a processor, one or more database query language statements from the plurality of database query language statements and performance information for the one or more data base query language statements, wherein the plurality of database query language statements are filtered based at least in part upon identification of the one or more high load database query language statements such that the set of the one or more high load query statements are identified by ranking and selecting the one or more database query language statements from the set of one or more high load query statements, in which at least one of the set of the one or more high load database query language statements are tuned by using at least a part of the performance information; persistently storing the one or more database query language statements and a first performance information as one or more second persistent database objects, wherein the first performance information is used to tune one of the one or more database query language statements as at least some of the one or more second persistent database objects, the first performance information comprises execution measurements and execution context corresponding to the one or more database query language statements, and the execution context comprises at least one of a user schema, a name of an application issuing a query language statement, an action of an application issuing a query language statement, a list of bind variables, and system environment information. - View Dependent Claims (2, 3, 4, 5, 6, 19, 20, 21)
-
-
7. An apparatus, comprising:
-
means for populating a plurality of database query language statements and corresponding performance information as a plurality of first persistent database objects in a database; a processor configured for identifying one or more database query language statements from the plurality of database query language statements and performance information for the one or more data base query language statements, wherein the plurality of database query language statements are filtered based at least in part upon identification of the one or more high load database query language statements such that the set of the one or more high load query statements are identified by ranking and selecting the one or more database query language statements from the set of one or more high load query statements, in which at least one of the set of the one or more high load database query language statements are tuned by using at least a part of the performance information; means for persistently storing the one or more database query language statements and performance information as one or more second persistent database objects, wherein the performance information is used to tune one of the one or more database query language statements as at least some of the one or more second persistent database objects, the performance information comprises execution measurements and execution context corresponding to the one or more database query language statements, and the execution context comprises at least one of a user schema, a name of an application issuing a query language statement, an action of an application issuing a query language statement, a list of bind variables, and system environment information. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A computer readable medium storing a computer program of instructions which, when executed by a processing system, cause the processing system to perform a process, the process comprising:
-
populating a plurality of database query language statements and corresponding performance information as a plurality of first persistent database objects in a database; identifying, by using a processor, one or more database query language statements from the plurality of database query language statements and performance information for the one or more data base query language statements, wherein the plurality of database query language statements are filtered based at least in part upon identification of the one or more high load database query language statements such that the set of the one or more high load query statements are identified by ranking and selecting the one or more database query language statements from the set of one or more high load query statements, in which at least one of the set of the one or more high load database query language statements are tuned by using at least a part of the performance information; persistently storing the one or more query language statements and a first performance information as one or more second persistent database objects, wherein the first performance information is used to tune one of the one or more database query language statements as at least some of the one or more second persistent database objects, the first performance information comprises execution measurements and execution context corresponding to the one or more database query language statements, and the execution context comprises at least one of a user schema, a name of an application issuing a query language statement, an action of an application issuing a query language statement, a list of bind variables, and system environment information. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification