Table 17. Siebel ARM Query Tool Flags for Record Selection
|
|
clickid=<ID>
|
The Web server Siebel ARM files (-select sourcetype=web) contain a user click ID (also known as operation ID). This filter retrieves all records where clickid equals <ID>. |
foreign
|
Use this flag to retrieve records whose parent records are from a different process. This is frequently the case for Siebel ARM data generated from batch mode components. |
orphan
|
Select records that are not root records and whose parent record was not found in the input Siebel ARM file(s). |
level=<level>
Or: level=<min>,<max>
|
Specify one argument to retrieve records whose Application Program Interface (API) level is at least equal to <level>. Specify two arguments to retrieve a range of values between the minimum and maximum level specified. The API level indicates the importance of a Siebel ARM record as follows:
- <level> = 1
Equal to SARMLevel=1. This indicates high level information.
- <level> = 2
Equal to SARMLevel=2. This indicates. detailed performance information
- <level> = 3
Equal to SARMLevel=3 This indicates debug or internal performance information.
|
parentid=<ID>
|
Select Siebel ARM records whose parent ID is <ID> |
rootid=<ID>
|
Selects Siebel ARM records whose root ID (also known as 'request ID' in interactive mode components) is <ID> |
sarmid=<sarmid>
Or: sarmid=<procid>.<sarmid>
Or: sarmid=<segid>.<procid>.<sarmid >
|
Retrieves Siebel ARM records primary ID where:
- <sarmid> is a number uniquely identifying this performance record within a process/component,
- <procid> is the process id (same as '-select procid=<procid>'), and
- <segid> is the segment id (same as '-select segid=<segid>,<segid>)
|
sessionid=<sessid>
|
All session based component performance data contain an attribute known as the session id. All performance data from all processes that have the same session id are assumed to belong to a single session of a single user. The Siebel ARM Query Tool does a case blind search using <sessid>. Wild cards are acceptable. |
taskid=<taskid>
|
Select all records that associated with task <taskid>. |
threadid=<threadid>
|
Select all records that were created by the thread whose OS thread id is <threadid> . |
user=<username>
|
Select all records that were created by user named <username>. <username> is typically the login name. search is case blind and wild cards are acceptable. |
area=<area>
area=<areacode>
subarea=<sub>
subarea=<subcode>
pararea=<parea>
pararea=<pareacode>
parsubarea=<psarea>
parsubarea=<pscode>
|
Two filters, area and subarea, identify each Siebel ARM record. Area and Subarea are logical sections of the Siebel Server. For example, the Siebel Web Engine (SWE) area creates Web pages. Siebel ARM records associated with the SWE describe Web page creation performance. Similarly, the database connector (DBC) area represents the connection to the enterprise database. Siebel ARM records associated with DBC indicate the performance of database queries. For example, the following command: > sarmquery -select area=DBC
retrieves all Siebel ARM records associated with database queries. You can retrieve a complete list of areas, subareas and descriptions from the Siebel ARM Query Tool. The following command saves the complete list to the file map.csv: > sarmquery -output map=map.csv
If you know the numeric area or subarea codes, you can use them directly in this command. Otherwise, you can use the string form of the symbol. When using the string form, you don't need to use the entire text - you may use a partial text provided it uniquely identifies the area or subarea. The filters pararea and parsubarea are similar to area and subarea except that they select Siebel ARM records whose parent area and subarea (respectively) are <parea> and <psarea>. For example: > sarmquery -select pararea=swe
retrieves all Siebel ARM records whose parent area is SWE. |
children=0
|
Use this flag to retrieve Siebel ARM records that have no child records. |
children=<count>
Or: children=<min>,<max>
|
Specify one argument to retrieve Siebel ARM records that have child records equal to at least <count>. Specify two arguments to retrieve the records that have child records between <min> and <max>. |
cputime=<ms>
Or: cputime=<min>,<max>
|
Specify one argument to retrieve Siebel ARM records that spent at least <ms> milliseconds on the CPU. Specify two arguments to retrieve the Siebel ARM records that spent between <min> and <max> milliseconds on the CPU. |
depth=<depth>
Or: depth=<min>,<max>
|
Specify one integer argument to retrieve Siebel ARM records that are no more than <depth> from the root node. Specify two integer arguments to retrieve a range of records. |
descendants=<count>
Or: descendants=<min>,<max>
|
Specify one integer argument to retrieve Siebel ARM records that have at least <count> descendants. Specify two arguments to retrieve a range of values. |
instance=<string>
detail=<string>
int1=<int>
|
Use these filters to retrieve Siebel ARM records where the filter is as follows:
- instance
This filter retrieves Siebel ARM records where instance metadata equals <string>. Instance metadata typically contains the names of things, such as the view names, screen names, user name, workflow name and script name.
- detail
This filter retrieves Siebel ARM records where the detail metadata equals <string>. Detail metadata typically contains identification information. For example, it may contain a database row ID or the name of a business component method.
- int1
This filter retrieves Siebel ARM records where int1 filter equals <int>. The int1 metadata typically contains counter values, task IDs or other unspecified information.
NOTE: The values that the preceding metadata fields reference depends on the associated area or subarea.
|
memusage=<excl>
Or: memusage=<min>,<max>
|
Specify one argument to retrieve all Siebel ARM records where memory allocated or deallocated was larger than <excl> bytes. Specify two arguments to retrieve a range of Siebel ARM records that record the memory allocation or deallocation events within the specified range. For example: > sarmquery -select memusage=1000000
retrieves all Siebel ARM records where the associated event recorded a memory allocation of 1 MB (or larger) or a deallocation of 1 MB or larger. |
pctcpu=<pct>
Or: pctcpu=<min>,<max>
|
Specify a single argument to retrieve Siebel ARM records that indicate a CPU consumption of <pct> percent. Specify two arguments to retrieve a range between <min> and <max> percent. |
resptime=<ms>
Or: resptime=<min>,<max>
|
Specify one argument to retrieve Siebel ARM records where the inclusive wall clock time consumed is <ms> milliseconds. Specify two arguments to retrieve a range between <min> and <max>. An inclusive wall clock time is the time spent in a specific part of the architecture and includes the time spent in all of its descendants. For example, the response time of a SWE area would be the time spent in constructing a Web page including the time to evaluate business component events and database access. |
selftime=<ms>
Or: selftime=<min>,<max>
|
With one argument, select Siebel ARM records where the exclusive time consumed is <ms> milliseconds. With two arguments, <min> and <max> specify a range. An exclusive time is time spent in an area, and only in that area, excluding the time spent in its descendants. Hence, the self time of a SCRIPT area would be the time spent in the scripting engine, and not including time spent in the database, object manager, workflow etc. |
starttime=<start>
Or: endtime=<end>
|
The semantics and syntax are similar to the time filters described for headers, except the filters select Siebel ARM records based on the timestamps. |
tree=all
tree=descendant
tree=ancestor
tree=parent
|
These are a specialized set of selection filters that don't just operate on a single record basis but on record sets. In most cases, they serve to replace a performance record with an entire set. In order to understand these operators, it is important to realize that Siebel ARM records form a tree of an execution thread with parent and children nodes:
- -select tree=all
Replaces a selected record by all records in its tree.
- -select tree=parent
Replaces a selected record by its parent. The record itself is discarded.
- -select tree=ancestor
Replaces a selected record by all Siebel ARM records leading from the selected record to the root of the tree. The selected record is also included in the set.
- -select tree=children
Replaces a selected record by its immediate children. The selected record is not included.
|