These columns identify the type of commands given to Vantage by the user. Three levels of granularity are given:
- Transactions. These columns consist of one or more requests.
- Requests. These consist of one or more statements.
- Statements. These columns are subdivided into the various statement types.
Column Name | Mode | Description | Data Type |
---|---|---|---|
CmdAlterStmts | count | Number of alter, modify, or drop statement commands. | FLOAT |
CmdArchUtilityStmts | count | Number of archival utility commands (for example, restore, archive and recovery). | FLOAT |
CmdCreateStmts | count | Number of create or replace statement commands. | FLOAT |
CmdDeleteStmts | count | Number of delete commands. | FLOAT |
CmdGrantStmts | count | Number of grant or revoke commands. | FLOAT |
CmdInsertStmts | count | Number of insert commands. | FLOAT |
CmdLoadUtilityStmts | count | Number of FastLoad and MultiLoad utility commands. (Tpump commands cannot be distinguished, and are therefore counted by the INSERT, UPDATE and DELETE statements). | FLOAT |
CmdOtherStmts | count | Number of other commands. | FLOAT |
CmdRequests | count | Number of request commands. | FLOAT |
CmdSelectStmts | count | Number of select commands. | FLOAT |
CmdTransactions | count | Number of transaction commands. | FLOAT |
CmdUpdateStmts | count | Number of update commands. | FLOAT |