grid

構文

grid <stmt>

説明

グリッド・データベースに対して指定されている文を実行します。

例

見やすくするためにSYS.GV$MONITOR表の内容を書式化します。このコマンドは、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:                      

optional_monitor_columnを指定した場合、その列のみが表示されます。

Command> grid monitor PERM_IN_USE_SIZE;  
PERM_IN_USE_SIZE: 20570 

この例は、3x1グリッド表を示しています。表の構造と行の配分は次のようになります:

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%