Generating Histograms with the Siebel ARM Query Tool

This topic is part of Analyzing Siebel ARM Files Using the Siebel ARM Query Tool.

Histograms are a special type of aggregation. You can use a histogram to aggregate the results that the Siebel ARM Query Tool retrieves when you submit a query on Siebel ARM data that might return too many values if you do not use the histogram.

For example, note the following query:

> sarmquery -aggregate resptime 

This query might retrieve millions of rows as the first row returns the requests that completed in one millisecond, the second row returns the number of requests that completed in two milliseconds, and so on.

A more effective query generates a histogram as in the following example:

> sarmquery –histogram resptime=100,200,300,400,500 

This query returns six rows. The first row aggregates the number of requests that complete in less than 100 milliseconds, the second row aggregates the number of requests that completed between 100 and 200 milliseconds, and so on.

In the preceding example, the values 100, 200, 300 and so on are known as bin endpoints.

The following table describes the flag options that you can use with the histogram parameter. All of the listed options must be preceded by the option -histogram.

Flag	Description
resptime=val1,val2 … valN	Creates a histogram of response (inclusive) times, where the arguments val1 and val2 specify the bin endpoints. val1 and val2 are expressed in milliseconds.
selftime=val1,val2 … valN	Creates a histogram of self time (exclusive) times, where val1 and valN specify the endpoints. The values are expressed in milliseconds.
pctcpu=val1,val2 … valN	Creates a histogram of the percentage of CPU time consumed. The arguments are expressed as integers between 0 and 100.
children=val1,val2 … valN	Creates a histogram of the width of the execution trees.
depth=val1,val2 … valN	Creates a histogram of the depth of the execution trees.