Automatic database diagnostic usage models

• US 8,024,301 B2
• Filed: 08/11/2004
• Issued: 09/20/2011
• Est. Priority Date: 03/26/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Venkataramani, Venkateshwaran, Kumar, Sushil, Wood, Graham S., Tan, Leng Leng, Gupta, Shivani, Dias, Karl, Shaft, Uri, Ramacher, Mark
• Primary Examiner(s): Pulliam; Christyann R
• Application Number:
  US10/916,695
• Publication Number:
  US 20050216490A1
• Time in Patent Office: 2,596 Days
• Field of Search: 707/200
• US Class Current: 707/688
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.

Claims

1. A method comprising:

providing a plurality of usage models for analyzing a database system, the plurality of usage models specifying a plurality of rules, each usage model specifying a subset of rules from the plurality of rules, the subset of rules for a usage model specifying a set of one or more performance problems that are analyzed by that usage model;

selecting, by the database system, a first usage model from the plurality of usage models for analyzing the database system, the first usage model specifying a first subset of rules from the plurality of rules to be used for analyzing the database system, wherein the selecting comprises;

detecting, by the database system, performance information for the database system;

determining, by the database system, a type of analysis to be performed based upon the detected performance information; and

determining, by the database system, a usage model to be used corresponding to the type of analysis to be performed;

determining, by the database system, database information corresponding to the first subset of rules;

analyzing the determined database information based upon the first subset of rules;

determining one or more performance problems based upon the analyzing; and

outputting information indicative of the determined one or more performance problems.

2. The method of claim 1, wherein the selecting the first usage model comprises:

receiving information indicating that the first usage model is to be used.

3. The method of claim 1, wherein the outputting comprises:

storing information indicative of the determined one or more performance problems for future use.

4. The method of claim 1, wherein:

the plurality of usage models comprises a second usage model configured for analyzing a second set of one or more performance problems that occur in the database system; and

the second set of performance problems is different from a set of performance problems analyzed by the first usage model.

5. The method of claim 1, wherein the first usage model is selected for analyzing a particular set of one or more performance problems.

6. The method of claim 1, wherein the first usage model is a period analysis usage model.

7. The method of claim 6 further comprising determining a period of time for the period analysis usage model and wherein determining the database information comprises determining the database information from the period of time.

8. The method of claim 6, wherein the determined database information comprises information found in one or more snapshots of information.

9. The method of claim 1, wherein the first usage a model is a spot analysis usage model.

10. The method of claim 9 further comprising determining a period of time for the spot analysis usage model and wherein determining the database information comprises determining the database information from the period of time.

11. The method of claim 1, wherein the first usage model is a period comparison usage model.

12. The method of claim 11 further comprising:

determining a first period of time;

determining a second period of time; and

comparing database information in the second period of time with database information in the first period of time.

13. The method of claim 1, wherein selecting the first usage model comprises:

determining when to run the first usage model automatically.

14. A non-transitory computer-readable storage medium storing code for execution by a processor of a computer system, the code comprising:

code for providing a plurality of usage models for analyzing a database system, the plurality of usage models specifying a plurality of rules, each usage model specifying a subset of rules from the plurality of rules, the subset of rules for a usage model specifying a set of one or more performance problems that are analyzed by that usage model;

code for selecting, by the database system, a first usage model from the plurality of usage models for analyzing the database system, the first usage model specifying a first subset of rules from the plurality of rules to be used for analyzing the database system, wherein the code for selecting comprises;

code for detecting, by the database system, performance information for the database system;

code for determining, by the database system, a type of analysis to be performed based upon the detected performance information; and

code for determining, by the database system, a usage model to be used corresponding to the type of analysis to be performed;

code for determining, by the database system, database information corresponding to the first subset of rules;

code for analyzing the determined database information based upon the first subset of rules;

code for determining one or more performance problems based upon the analyzing; and

code for outputting information indicative of the determined one or more performance problems.

15. The computer-readable storage medium of claim 14, wherein:

the plurality of usage models comprises a second usage model for analyzing a second set of performance problems that occur in the database system; and

the second set of performance problems is different from a set of performance problems analyzed by the first usage model.

16. The computer-readable storage medium of claim 14, wherein the first usage model is selected for analyzing a particular set of one or more performance problems.

17. The computer-readable storage medium of claim 14, wherein the first usage model is a period analysis usage model.

18. The computer-readable storage medium of claim 17, wherein the code further comprises code for determining a period of time for the period analysis usage model and wherein the code for determining the database information comprises code for determining the database information from the period of time.

19. The computer-readable storage medium of claim 18, wherein the determined database information comprises information found in one or more snapshots of information.

20. The computer-readable storage medium of claim 14, wherein the first usage model is a spot analysis usage model.

21. The computer-readable storage medium of claim 20, wherein the code further comprises code for determining a period of time for the spot analysis usage model and wherein the code for determining the database information comprises code for determining the database information from the period of time.

22. The computer-readable storage medium of claim 14, wherein the first usage model is a period comparison usage model.

23. The computer-readable storage medium of claim 22, wherein the code further comprises:

code for determining a first period of time;

code for determining a second period of time; and

code for comparing database information in the second period of time with database information in the first period of time.

24. The computer-readable storage medium of claim 14, wherein the code for selecting the first usage model comprises:

code for determining when to run the first usage model automatically.

25. The computer-readable storage medium of claim 14, wherein the code for selecting the first usage model comprises:

code for receiving information indicating the first usage model is to be used.