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

About the Siebel ARM Query Tool


The Siebel ARM Query Tool is a performance analysis command line tool that processes the binary Siebel ARM data produced by the Siebel Server. It differs from the Siebel ARM Analyzer Tool in the following ways:

  • Usability

    The Siebel ARM Query offers more command line options that allow you to create more complex queries.

  • Performance

    The Siebel ARM Query tool processes data faster than the Siebel ARM Analyzer tool.

  • Memory management

    You can increase the amount of memory that the Siebel ARM Query Tool uses in order to increase the statistical accuracy of results. By default, the Siebel ARM Query Tool uses approximately 20 MB of memory. This corresponds to a statistical error of approximately 1%. If you increase the amount of memory that the Siebel ARM Query Tool uses to 500 MB, you can reduce the statistical error to 0.2%.

    The amount of memory that you allocate does not affect the performance of the Siebel ARM Query Tool; any additional memory that you allocate is applied to the buffer that the Siebel ARM Query Tool uses for statistical calculation.

    NOTE:  It is impossible to completely eliminate statistical error.

    For information on the parameters to modify the amount of memory that the Siebel ARM Query Tool uses for statistical accuracy, see Configuring the Siebel ARM Query Tool.

  • Source data specification

    You can specify individual Siebel ARM files or directories as input for the Siebel ARM Query Tool. For more information about the parameters that allow you to specify input data, see Configuring Input for the Siebel ARM Query Tool.

  • Data filtering capability

    You can specify filters that include or exclude data from analysis by the Siebel ARM Query Tool.

  • Aggregating data

    You can specify the order of aggregation. This includes rollup calculations. For more information about aggregation, see Aggregating Siebel ARM Data with the Siebel ARM Query Tool.

  • Multiple output formats

    You can specify that multiple types of output be produced simultaneously. Supported output formats include .TXT, .XML and .CSV. For more information on how to specify the output format, see Configuring Output from the Siebel ARM Query Tool.

  • Macro language

    The Siebel ARM Query Tool supports the use of macros. For more information, see Using Macros with the Siebel ARM Query Tool.

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