Automatic database diagnostic usage models

• US 20050216490A1
• Filed: 08/11/2004
• Published: 09/29/2005
• Est. Priority Date: 03/26/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Dias, Karl, Venkataramani, Venkateshwaran, Shaft, Uri, Ramacher, Mark, Kumar, Sushil, Wood, Graham S., Tan, Leng Leng, Gupta, Shivani
• Granted Patent: US 8,024,301 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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 for analyzing performance problems in a database, the method comprising:

providing one or more usage models for a database, each usage model in the one or more usage models including a set of rules that are used to analyze database performance;

determining a usage model in the one or more usage models to use;

determining database information to analyze based on the usage model; and

analyzing the database information based on rules associated with the usage model to detect one or more performance problems based on the analysis.

2. The method of claim 1, wherein rules for each usage model in the one or more usage models are directed towards analyzing different sets of performance problems that occur for different situations in the database.

3. The method of claim 2, wherein the usage model is determined based on a situation that rules associated with the usage model are directed towards.

4. The method of claim 1, wherein the one or more usage models comprise a period analysis usage model.

5. The method of claim 4, wherein the usage model determined is the period analysis usage model, the method further comprising determining a period of time for the period analysis usage model, wherein the database information is from the period of time.

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

7. The method of claim 1, wherein the one or more usage models comprise a spot analysis usage model.

8. The method of claim 7, wherein the usage model determined is the spot analysis usage model, the method further comprising determining a period of time for the spot analysis usage model, wherein the database information is from the period of time.

9. The method of claim 8, wherein period of time is a short period of time.

10. The method of claim 1, wherein the one or more usage models comprise a period comparison usage model.

11. The method of claim 10, wherein the usage model determined is the spot analysis usage model, the method further comprising:

determining a first period of time; and

determining a second period of time,

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

12. The method of claim 1, wherein determining the usage model to run comprises determining when to run the usage model automatically.

13. The method of claim 1, wherein determining the usage model to run comprising receiving an input from a user indicating the usage model.

14. A method for analyzing performance problems in a database, the method comprising:

providing a plurality of usage models for a database, each usage model in the plurality of usage models including a set of rules that are used to analyze different areas of database performance;

determining an area of database performance to analyze;

determining a usage model in the plurality usage models to use based on an the area of database performance determined and the area of database performance associated with the set of rules for the usage model;

determining database information to analyze based on the usage model and the area of database performance associated with the usage model; and

analyzing the database information based on rules associated with the usage model to detect one or more performance problems based on the analysis.

15. The method of claim 14, wherein the rules associated with different areas of database performance are directed towards different situations, wherein the usage model is determined based on the situation.

16. The method of claim 14, wherein the plurality of usage models comprise a period analysis usage model.

17. The method of claim 16, wherein the usage model determined is the period analysis usage model, the method further comprising determining a period of time for the period analysis usage model, wherein the database information is from the period of time.

18. The method of claim 17, wherein the database information comprises information found in one or more snapshots of information.

19. The method of claim 14, wherein the plurality of usage models comprise a spot analysis usage model.

20. The method of claim 19, wherein the usage model determined is the spot analysis usage model, the method further comprising determining a period of time for the spot analysis usage model, wherein the database information is from the period of time.

21. The method of claim 20, wherein period of time is a short period of time.

22. The method of claim 14, wherein the plurality of usage models comprise a period comparison usage model.

23. The method of claim 22, wherein the usage model determined is the spot analysis usage model, the method further comprising:

determining a first period of time; and

determining a second period of time,

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

24. The method of claim 14, wherein determining the usage model to use comprises determining when to use the usage model automatically.

25. The method of claim 14, wherein determining the usage model to use comprising receiving an input from a user indicating the usage model.

26. A computer program product stored on a computer-readable medium for analyzing performance problems in a database, the computer program product comprising:

code for providing one or more usage models for a database, each usage model in the one or more usage models including a set of rules that are used to analyze database performance;

code for determining a usage model in the one or more usage models to use;

code for determining database information to analyze based on the usage model; and

code for analyzing the database information based on rules associated with the usage model to detect one or more performance problems based on the analysis.

27. The computer program product of claim 26, wherein rules for each usage model in the one or more usage models are directed towards analyzing different sets of performance problems that occur for different situations in the database.

28. The computer program product of claim 27, wherein the usage model is determined based on a situation that rules associated with the usage model are directed towards.

29. The computer program product of claim 26, wherein the one or more usage models comprise a period analysis usage model.

30. The computer program product of claim 29, wherein the usage model determined is the period analysis usage model, the method further comprising code for determining a period of time for the period analysis usage model, wherein the database information is from the period of time.

31. The computer program product of claim 30, wherein the database information comprises information found in one or more snapshots of information.

32. The computer program product of claim 26, wherein the one or more usage models comprise a spot analysis usage model.

33. The computer program product of claim 32, wherein the usage model determined is the spot analysis usage model, the computer program product further comprising code for determining a period of time for the spot analysis usage model, wherein the database information is from the period of time.

34. The computer program product of claim 33, wherein period of time is a short period of time.

35. The computer program product of claim 26, wherein the one or more usage models comprise a period comparison usage model.

36. The computer program product of claim 35, wherein the usage model determined is the spot analysis usage model, the computer program product further comprising:

code for determining a first period of time; and

code for determining a second period of time,

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

37. The computer program product of claim 26, wherein code for determining the usage model to run comprises determining when to run the usage model automatically.

38. The computer program product of claim 26, wherein code for determining the usage model to run comprising receiving an input from a user indicating the usage model.

39. A computer program product stored on a computer-readable medium for analyzing performance problems in a database, the computer program product comprising:

code for providing a plurality of usage models for a database, each usage model in the plurality of usage models including a set of rules that are used to analyze different areas of database performance;

code for determining an area of database performance to analyze;

code for determining a usage model in the plurality usage models to use based on an the area of database performance determined and the area of database performance associated with the set of rules for the usage model;

code for determining database information to analyze based on the usage model and the area of database performance associated with the usage model; and

code for analyzing the database information based on rules associated with the usage model to detect one or more performance problems based on the analysis.

40. The computer program product of claim 39, wherein the rules associated with different areas of database performance are directed towards different situations, wherein the usage model is determined based on the situation.

41. The computer program product of claim 39, wherein the plurality of usage models comprise a period analysis usage model.

42. The computer program product of claim 41, wherein the usage model determined is the period analysis usage model, the computer program product further comprising code for determining a period of time for the period analysis usage model, wherein the database information is from the period of time.

43. The computer program product of claim 42, wherein the database information comprises information found in one or more snapshots of information.

44. The computer program product of claim 39, wherein the plurality of usage models comprise a spot analysis usage model.

45. The computer program product of claim 44, wherein the usage model determined is the spot analysis usage model, the computer program product further comprising code for determining a period of time for the spot analysis usage model, wherein the database information is from the period of time.

46. The computer program product of claim 45, wherein period of time is a short period of time.

47. The computer program product of claim 39, wherein the plurality of usage models comprise a period comparison usage model.

48. The computer program product of claim 47, wherein the usage model determined is the spot analysis usage model, the computer program product further comprising:

code for determining a first period of time; and

code for determining a second period of time,

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

49. The computer program product of claim 39, wherein code for determining the usage model to use comprises determining when to use the usage model automatically.

50. The computer program product of claim 39, wherein code for determining the usage model to use comprising receiving an input from a user indicating the usage model.