Automatic performance statistical comparison between two periods

• US 7,526,409 B2
• Filed: 10/07/2005
• Issued: 04/28/2009
• Est. Priority Date: 10/07/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Green, Konstantina Dialeris, Ramacher, Mark C., Grant, Cecilia Gervasio, Green, Russell John, Wood, Graham Stephen
• Primary Examiner(s): Cosimano; Edward R
• Application Number:
  US11/245,905
• Publication Number:
  US 20070083564A1
• Time in Patent Office: 1,299 Days
• Field of Search: 340/500, 340/540, 340/635, 340/679, 702/1, 702/33, 702/34, 702/127, 702/179, 702/182, 702/183, 702/187, 702/189, 705/1, 705/7, 705/11
• US Class Current: 702/182
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations

Abstract

A technique for automatically generating a report comprising normalized differences in performance statistics between two separate periods. In one embodiment of the invention, database performance statistics are collected on a periodic basis over various time periods. In order to accurately compare database system performance between two discrete periods of time, the difference in the performance statistics of each period are normalized prior to comparing the two periods with each other. By normalizing the statistical differences in each period prior to comparing the differences, periods of different lengths of time as well as different levels of database system load may be compared. In one embodiment, a report is automatically generated which lists the performance statistics being evaluated, the difference in the statistic between each period, the value of each statistical difference as normalized by database time, and the difference between the normalized values.

Claims

1. A computer-implemented method of representing database performance characteristics, the method comprising:

collecting at least two data values representing measurements of database performance of a database system, wherein the at least two data values correspond to two different periods of time;

for each of the two periods, determining a database time that represents an amount of time the database system works on calls by users to the database system;

generating normalized values by normalizing the at least two data values based on the respective database time for the respective periods of time; and

storing the normalized data values into a persistent or non-persistent memory.

2. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.

3. The method of claim 1, wherein the at least two data values include cumulative values.

4. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 3.

5. The method of claim 1, wherein the first of the at least two data values comprises:

the difference between statistical values captured by a snapshot at the beginning of a first period and statistical values captured by a snapshot at the end of the first period, and

the second of the at least two data values comprises;

the difference between statistical values captured by a snapshot at the beginning of a second period and statistical values captured by a snapshot at the end of the second period.

6. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

7. The method of claim 1, wherein the measurements of database performance comprise buffer busy waits.

8. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 7.

9. The method of claim 1, wherein the measurements of database performance comprise log file syncs.

10. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 9.

11. The method of claim 1, wherein the measurements of database performance comprise user commits.

12. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 11.

13. The method of claim 1, wherein the measurements of database performance comprise session logical reads.

14. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 13.

15. The method of claim 1, further comprising automatically generating a report based on the normalized values.

16. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 15.

17. The method of claim 15, wherein the report is ordered by amount of difference between the normalized data values.

18. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 17.

19. The method of claim 15, wherein the report values are generated as the result of a SQL query.

20. A computer-readable volatile or non-volatile medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 19.