grid

Syntax

grid <stmt>

Description

Performs that specified statement on a grid database.

Examples

Formats the contents of the SYS.GV$MONITOR table for easy viewing. This command is not supported in TimesTen Classic.

Command> grid monitor;

HOSTNAME:                  myhost
INSTANCENAME:              mydb_0
ELEMENT:                   1
TIME_OF_1ST_CONNECT:       Tue Sep 24 19:08:57 2024
DS_CONNECTS:               22
DS_DISCONNECTS:            3
DS_CHECKPOINTS:            6
DS_CHECKPOINTS_FUZZY:      2
DS_COMPACTS:               0
PERM_ALLOCATED_SIZE:       262144
PERM_IN_USE_SIZE:          20366
PERM_IN_USE_HIGH_WATER:    20366
TEMP_ALLOCATED_SIZE:       262144
TEMP_IN_USE_SIZE:          34136
TEMP_IN_USE_HIGH_WATER:    34137
SYS18:                     0
TPL_FETCHES:               0
TPL_EXECS:                 0
CACHE_HITS:                0
PASSTHROUGH_COUNT:         0
XACT_BEGINS:               473
XACT_COMMITS:              471
XACT_D_COMMITS:            124
XACT_ROLLBACKS:            1
LOG_FORCES:                272
DEADLOCKS:                 0
LOCK_TIMEOUTS:             0
LOCK_GRANTS_IMMED:         135704
LOCK_GRANTS_WAIT:          0
SYS19:                     0
CMD_PREPARES:              119
CMD_REPREPARES:            1
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:   20505784
LOG_FS_READS:              5
LOG_FS_WRITES:             380
LOG_BUFFER_WAITS:          0
CHECKPOINT_BYTES_WRITTEN:  13048504
CURSOR_OPENS:              749
CURSOR_CLOSES:             749
SYS3:                      0
SYS4:                      0
SYS5:                      0
SYS6:                      0
CHECKPOINT_BLOCKS_WRITTEN: 2423
CHECKPOINT_WRITES:         644
REQUIRED_RECOVERY:         0
SYS11:                     0
SYS12:                     1
TYPE_MODE:                 0
SYS13:                     0
SYS14:                     0
SYS15:                     0
SYS16:                     0
SYS17:                     0
SYS9:                      

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

Command> grid monitor PERM_IN_USE_SIZE;  
PERM_IN_USE_SIZE: 20570 

This example shows a 3x1 grid table. The table structure and row distribution looks like:

create table MYUSER.T1 (
        A NUMBER(38) NOT NULL,
    primary key (A))
    distribute by hash (A); 

Command> grid showdistribution T1;
Row Distribution for table MYUSER.T1:

  HOSTNAME:              MYHOST
  INSTANCENAME:          inst_0
  ELEMENT:               1
  REPLICASET:            1
  DATASPACEGROUP:        1
  ROWCOUNT:              42
  PERCENT OF TOTAL:      34.14634%
  DEVIATION FROM MEAN:   2.43902%


  HOSTNAME:              MYHOST
  INSTANCENAME:          inst_1
  ELEMENT:               2
  REPLICASET:            2
  DATASPACEGROUP:        1
  ROWCOUNT:              41
  PERCENT OF TOTAL:      33.33333%
  DEVIATION FROM MEAN:   0%


  HOSTNAME:              MYHOST
  INSTANCENAME:          inst_2
  ELEMENT:               3
  REPLICASET:            3
  DATASPACEGROUP:        1
  ROWCOUNT:              40
  PERCENT OF TOTAL:      32.52033%
  DEVIATION FROM MEAN:   -2.43902%