Methods for determining event counts based on time-sampled data

Patent metadata

Field	Value
Publication number	US-9633061-B2
Application number	US-201213627906-A
Country	US
Kind code	B2
Filing date	Sep 26, 2012
Priority date	Sep 26, 2012
Publication date	Apr 25, 2017
Grant date	Apr 25, 2017

Abstract

A method for determining event counts for a database system includes capturing samples for the active sessions based on a pre-defined sampling frequency and identifying events from the captured samples. The method further includes determining the wait time for each of the identified events and determining an event count for the active sessions using a harmonic mean. The harmonic mean is a summation of the maximum of either one or the ratio of the sampling frequency to the determined wait time for each of the identified events.

First claim

What is claimed is:

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.

2. The method of claim 1 , wherein the determining of the wait time for each of the identified events includes,
determining whether each of the identified events has been completed; and
obtaining the wait time for each completed event.

3. The method of claim 2 , wherein the wait time for each completed event is obtained by a sampler of the database system.

4. The method of claim 1 , wherein the pre-defined sampling frequency is about 1 sampling per second.

5. The method of claim 1 , wherein the determining of the event counts for the active sessions includes,
identifying a type of events from the captured samples based on the identified activity types;
defining wait time ranges for the identified type of events;
grouping the events with the identified type based on the defined wait time ranges; and
determining a group event count for each group of the identified type of events using the harmonic mean.

6. The method of claim 5 , further comprising:
creating a histogram for the identified type of events based on the defined wait time ranges and the determined group event count for each group of the identified type of events.

7. The method of claim 1 , further comprising:
identifying the active sessions in the database system.

8. The method of claim 1 , wherein the samples of the active sessions are captured during a specified time period.

9. 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;
grouping the identified events based on the determined wait time according to defined wait time ranges;
determining a group event count for each group of the identified events for the active sessions using a harmonic mean of the wait times of the identified events for each type of activity in each group, 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 in each group of the active sessions,
the harmonic mean computes the event count by estimating for events occurring in the active sessions with wait times shorter than the pre-defined sampling frequency, and including events with wait time greater than the pre-defined sampling frequency within each group; and
outputting the determined group event count for each group, wherein the method is executed by a processor.

10. The method of claim 9 , further comprising:
creating a histogram for the identified events based on the defined wait time ranges and the determined group event count for each grouped events.

11. The method of claim 9 , wherein the determining of the wait time for each of the identified events includes,
determining whether each of the identified events is completed; and
obtaining the wait time for each completed event.

12. The method of claim 11 , wherein the wait time for each completed event is obtained by a sampler of the database system.

13. The method of claim 9 , wherein the pre-defined sampling frequency is about 1 sampling per second.

14. The method of claim 9 , further comprising:
identifying the active sessions in the database system.

15. A non-transitory computer-readable storage medium storing program instructions, which when executed by one or more processors, performs the following operations:
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 pre-defined sampling frequency to the determined wait time, the harmonic mean computes the event count by estimating for events occurring in the active sessions with wait times shorter than the pre-defined sampling frequency, and including events with wait time greater than the pre-defined sampling frequency within each group; and
outputting the determined event count.

16. The computer program of claim 15 , further performing the following operations:
determining whether each of the identified events is completed; and
obtaining the wait time for each completed event.

17. The computer program of claim 15 , wherein the operation of determining the event counts for the active sessions includes the following operations,
identifying a type of events from the captured samples based on the identified type of activity;
defining wait time ranges for each of the identified type of events;
grouping the identified type of events based on the defined wait time ranges; and
determining a group event count for each group of the identified type of events using the harmonic mean.

18. A non-transitory computer-readable storage medium storing program instructions, which when executed by one or more processors performs a method, the computer-readable storage medium including:
program instructions for 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;
program instructions for identifying events for each identified type of activity from the captured samples that are active du

Assignees

• Oracle Int Corp

Inventors

• Shaft Uri
• Wood Graham Stephen
• Beresniewicz John

Classifications

• G06F17/30371 Primary

  Physics · mapped topic

• G06F17/30306

  Physics · mapped topic

• G06F16/217 Primary

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title