LOCK_USAGE¶
Provides aggregate information about lock requests, releases, and attempts, such as wait time/count and hold time/count. 提供锁请求、释放和尝试的聚合信息,如等待时间/次数和持有时间/次数。
图例
- ✅ = 字段存在于该版本
- ❌ = 字段不存在于该版本
- 备注列标注首次出现或类型变更的版本
| 字段名 | Data Type | 11.0.x | 11.1.x | 12.0.x | 23.3.x | 23.4.x | 24.1.x | 24.2.x | 24.3.x | 24.4.x | 25.1.x | 25.2.x | 25.3.x | 25.4.x | 26.1.x | 26.2.x | 备注 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AVG_HOLD_TIME | INTERVAL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| AVG_WAIT_TIME | INTERVAL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| HOLD_COUNT | INTEGER | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| MAX_HOLD_TIME | INTERVAL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| MAX_WAIT_TIME | INTERVAL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| MODE | VARCHAR | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| NODE_NAME | VARCHAR | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| OBJECT_NAME | VARCHAR | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| SESSION_ID | VARCHAR | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| WAIT_COUNT | INTEGER | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |