Patent ID: 7774312
Filing Date: 2010-08-10
Classification: G06F

Abstract:
1. A method for managing performance statistics data in a database system, the method comprising: determining, with a workload repository module of the database system executed by one or more processors associated with one or more computer systems as an internal system background process of the database system, a set of one or more database performance statistics to be used in optimizing performance of operations in a database provided by the database system; determining, with the workload repository module, a plurality of capture times; at each of said capture times, capturing a snapshot for the database by capturing a current value for each database performance statistic in the set of database performance statistics with the workload repository module from a shared memory of the database system, determining a cumulative value for each database performance statistic in the set of database performance statistics with the workload repository module based on the current value for each database performance statistic in the set of database performance statistics, and storing the cumulative values for each database performance statistic in the set of database performance statistics in association with the respective capture time to the database; determining, with the workload repository module, a delta representing an amount of activity to a most recent snapshot from a previous snapshot taken prior to the most recent snapshot for each database performance statistic in the set of database performance statistics using a plurality of corresponding cumulative values and storing each delta in association with the most recent snapshot to the database, each delta including information regarding a change in value data for the respective database performance statistic between the most recent snapshot and the previous snapshot taken just prior to the most recent snapshot; determining, with one or more database tuning advisory modules executed by the one or more processors associated with the one or more computer systems as internal system background processes of the database system, a rate of change for each database performance statistic in the set of database performance statistics by dividing each delta by a time interval, the time interval being between the most recent snapshot and the previous snapshot; and adjusting, with the one or more database tuning advisory modules, performance of one or more operations in the database based on the rate of change determined by dividing the delta by the time interval for each database performance statistic in the set of database performance statistics.