节点自由全局存储-SYS_FREE_GSTORES
📄字数 382
👁️阅读量 加载中...
功能描述
SYS_FREE_GSTORES系统表用于管理当前节点的空闲全局存储信息。
字段说明
- 详见SYS_GSTORES。
应用举例
- 查询系统表
sql
SQL> SELECT * FROM SYS_FREE_GSTORES LIMIT 5;
+---------+---------+---------+---------+-----------+-----------+-----------+----------+----------+----------+-----------+-----------+-----------+-------+--------+--------+----------+---------+--------+
| GSTO_NO | HEAD_NO | TAIL_NO | NEXT_NO | SPLIT_NUM | STORE_STA | STORE_NUM | NODE_ID1 | NODE_ID2 | NODE_ID3 | STORE_NO1 | STORE_NO2 | STORE_NO3 | LSN | DB_ID | OBJ_ID | ENCRY_ID | ZONE_ID | NODEID |
+---------+---------+---------+---------+-----------+-----------+-----------+----------+----------+----------+-----------+-----------+-----------+-------+--------+--------+----------+---------+--------+
| 1 | 0 | 0 | 1232 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15238 | <NULL> | <NULL> | <NULL> | <NULL> | 1 |
| 1232 | 0 | 0 | 1231 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | <NULL> | <NULL> | <NULL> | <NULL> | 1 |
| 1231 | 0 | 0 | 1230 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | <NULL> | <NULL> | <NULL> | <NULL> | 1 |
| 1230 | 0 | 0 | 1229 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | <NULL> | <NULL> | <NULL> | <NULL> | 1 |
| 1229 | 0 | 0 | 1228 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | <NULL> | <NULL> | <NULL> | <NULL> | 1 |
+---------+---------+---------+---------+-----------+-----------+-----------+----------+----------+----------+-----------+-----------+-----------+-------+--------+--------+----------+---------+--------+