monitor

Syntax

monitor [optional_monitor_column]

Description

Formats the contents of the SYS.MONITOR table for easy viewing.

If the optional_monitor_column is specified, only that column is displayed.

For details, see monitor Command.

Example

Command> monitor;
  TIME_OF_1ST_CONNECT:      Thu Sep  5 00:48:03 2024
  DS_CONNECTS:                 14
  DS_DISCONNECTS:              1
  DS_CHECKPOINTS:              4
  DS_CHECKPOINTS_FUZZY:        0
  DS_COMPACTS:                 0
  PERM_ALLOCATED_SIZE:         32768
  PERM_IN_USE_SIZE:            19567
  PERM_IN_USE_HIGH_WATER:      19646
  TEMP_ALLOCATED_SIZE:         40960
  TEMP_IN_USE_SIZE:            17665
  TEMP_IN_USE_HIGH_WATER:      21946
  SYS18:                       0
  TPL_FETCHES:                 0
  TPL_EXECS:                   0
  CACHE_HITS:                  0
  PASSTHROUGH_COUNT:           0
  XACT_BEGINS:                 435
  XACT_COMMITS:                434
  XACT_D_COMMITS:              124
  XACT_ROLLBACKS:              0
  LOG_FORCES:                  127
  DEADLOCKS:                   0
  LOCK_TIMEOUTS:               0
  LOCK_GRANTS_IMMED:           134549
  LOCK_GRANTS_WAIT:            0
  SYS19:                       0
  CMD_PREPARES:                396
  CMD_REPREPARES:              0
  CMD_TEMP_INDEXES:            0
  LAST_LOG_FILE:               0
  REPHOLD_LOG_FILE:            -1
  REPHOLD_LOG_OFF:             -1
  REP_XACT_COUNT:              0
  REP_CONFLICT_COUNT:          0
  REP_PEER_CONNECTIONS:        0
  REP_PEER_RETRIES:            0
  FIRST_LOG_FILE:              0
  LOG_BYTES_TO_LOG_BUFFER:     18984608
  LOG_FS_READS:                2
  LOG_FS_WRITES:               229
  LOG_BUFFER_WAITS:            0
  CHECKPOINT_BYTES_WRITTEN:    40875376
  CURSOR_OPENS:                1326
  CURSOR_CLOSES:               1326
  SYS3:                        0
  SYS4:                        0
  SYS5:                        0
  SYS6:                        0
  CHECKPOINT_BLOCKS_WRITTEN:   2182
  CHECKPOINT_WRITES:           535
  REQUIRED_RECOVERY:           0
  SYS11:                       0
  SYS12:                       1
  TYPE_MODE:                   0
  SYS13:                       0
  SYS14:                       0
  SYS15:                       0
  SYS16:                       0
  SYS17:                       0
  SYS9: