Patent ID: 9633061
Date: 2017-04-25
CPC Classifications: G06F

Claim:
1. A method for determining event counts for a database system, comprising: capturing samples for active sessions based on a pre-defined sampling frequency, the pre-defined sampling frequency defining a uniform time interval and wherein each of the captured samples identifies a type of an activity; identifying events for each identified type of activity from the captured samples that are active during a sampling time; determining wait time for each of the identified events; determining an event count for the active sessions using a harmonic mean of the wait times of the identified events for each type of activity, wherein the harmonic mean is a summation of: for events having a wait time that is greater than the pre-defined sampling frequency, one per event, and for events having a wait time that is shorter than the pre-defined sampling frequency, a ratio of the sampling frequency to the determined wait time, the harmonic mean computes the event count by estimating for events occurring in the active session with wait times shorter than the pre-defined sampling frequency, and including events with wait time greater than the sampling frequency within the active sessions; and outputting the determined event count, wherein the method is executed by a processor.