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

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

For example, the following query:

> sarmquery -aggregate resptime

might retrieve millions of rows as the first row returns the requests that completed in one millisecond, the second row 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

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

Table 19 describes the flag options that you can use with the histogram parameter. All options described in Table 19 are preceded by the option -histogram.

Table 19. Flag Options for the Histogram Parameter

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.


Creates a histogram of self time (exclusive) times where <val1>...<valN> specify the endpoints. The values are expressed in milliseconds.


Creates a histogram of the percentage of CPU time consumed. The arguments are expressed as integers between 0 and 100.


Creates a histogram of width of the execution trees.


Creates a histogram of the depth of the execution trees.

Siebel Performance Tuning Guide Copyright © 2006, Oracle. All rights reserved.