Overview
gv$latch displays information about the latches on each OBServer in the cluster.
Related tables/views
oceanbase.__all_virtual_latch
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | BIGINT(20) | No | The ID of the tenant. |
| SVR_IP | varchar(32) | No | The IP address of the OBServer. |
| SVR_PORT | BIGINT(20) | No | The port number of the OBServer. |
| ADDR | varchar(256) | No | At present, the value of this field is NULL. |
| LATCH# | BIGINT(20) | No | The subscript of the class to which the latch belongs. |
| LEVEL# | BIGINT(20) | No | The subscript of the level to which the latch belongs. |
| NAME | varchar(256) | No | The name of the latch. |
| HASH | BIGINT(20) | No | At present, the value of this field is 0. |
| GETS | BIGINT(20) | No | The number of successful lockings. |
| MISSES | BIGINT(20) | No | The number of times that the latch entered the waiting state. |
| SLEEPS | BIGINT(20) | No | The total number of yields. |
| IMMEDIATE_GETS | BIGINT(20) | No | The number of times the try_lock operation succeeded. |
| IMMEDIATE_MISSES | BIGINT(20) | No | The number of times the try_lock operation failed. |
| SPIN_GETS | BIGINT(20) | No | The total number of spins. |
| WAIT_TIME | BIGINT(20) | No | The amount of time spent on waiting for the latch. |