Siebel Performance Tuning Guide > Analyzing Siebel ARM Data > Analyzing Siebel ARM Files Using the Siebel ARM Query Tool >

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 can return too many values if you do not use the histogram.

For example, the following query:

> sarmquery -aggregate resptime

This example might retrieve millions of rows: the first row returns the number of requests that completed in one millisecond, and the second row returns the number of requests that completed in two milliseconds.

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

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

This example 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 this example, the values 100, 200, 300, and so on, are known as bin endpoints.

Table 23 describes the flags that you can use with the histogram parameter. All the listed options are preceded by the option -histogram.