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

Configuring the Siebel ARM Query Tool


This section describes how you can configure the Siebel ARM Query Tool. An examples of how you can configure the Siebel ARM Query Tool is modifying the amount of memory that the Siebel ARM query uses to improve statistical accuracy. Table 13 describes the flags that you can use to configure the Siebel ARM Query Tool. All the options described Table 13 are preceded by the option -config.

Table 13. Configuration Options for the Siebel ARM Query Tool
Flag
Description

file=<macro_file_name>

Specifies the file that contains a macro.

macro=macro_name(str)

Executes the macro and passes the string str as the first argument to the macro. Before you can use this flag, you must specify the file that contains the macro using the flag:

-config file=<macro_file_name>

gmt=0

Parse all time stamps (on the command line) and displays all time in Greenwich Mean Time (GMT) to the command window. If you do not specify this flag, the Siebel ARM Query Tool uses local time.

gmt=[+-]HHMM

Parse and report all times as an offset from GMT. Offsets are specified in the HHMM notation where 'HH' is the hours (0023) and 'MM' is the minutes (00-59).

For example to report Pacific Time (PST), use the following flag:

> sarmquery -config gmt=-0800

datalimit=<limit>

Use this flag to specify a maximum number of records to return where <limit> is the maximum number. When the maximum number is exceeded, an error message (data limit exceeded) appears and the Siebel ARM Query Tool terminates.

timelimit=<seconds>

Use this flag to specify the maximum number of seconds that the Siebel ARM Query Tool can execute. When the maximum number of seconds elapses, the Siebel ARM Query Tool exits.

The Siebel ARM Query Tool processes in two phases:

  • File collection phase

    The tool identifies all required files. The value that you specify for the timelimit flag does not affect this phase; the time that the Siebel ARM Query Tool takes cannot be constrained.

  • Data processing phase

    The value that you specify for the timelimit flag affects the length of this phase.

memlimit=<MB>

Use this flag to specify the amount of memory that the Siebel ARM Query Tool can allocate to an internal buffer which the Siebel ARM Query Tool uses to compute aggregated statistics.

The more memory that the internal buffer can use, the more accurate the statistics returned.

The default value for this flag is twenty megabytes (MB). You can allocate a value between five MB and five hundred MB.

The value that you specify does not affect performance; it only applies to the buffer that the Siebel ARM query uses for statistical calculation.

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