存储域-SYS_STO_ZONES【未启用】

📄字数 1.2K

👁️阅读量 加载中...

功能描述

SYS_STO_ZONES用于存储当前集群内的存储域信息。

字段说明

序号	字段名	类型	说明	V11	V12
0	DB_ID	INTEGER	库ID	x	√
1	USER_ID	INTEGER	用户ID	x	√
2	ZONE_ID	INTEGER	存储域ID	x	√
3	ZONE_NAME	VARCHAR	存储域名	x	√
4	SRV_NUM	INTEGER	域内存储节点数	x	√
5	STO_NODES	BINARY	域内存储节点	x	√
6	CREATE_TIME	DATETIME	创建时间	x	√
7	ENABLE	BOOLEAN	是否启用	x	√
8	IS_SYS	BOOLEAN	是否是系统级	x	√
9	IS_LOCAL	BOOLEAN	是否是本地分配，local是指分区存储完全分配在域内某个节点上	x	√
10	COMMENTS	VARCHAR	注释信息	x	√
11	RESERVED1	VARCHAR	保留字段	x	√
12	RESERVED2	VARCHAR	保留字段	x	√
13	RESERVED3	VARCHAR	保留字段	x	√
14	RESERVED4	VARCHAR	保留字段	x	√
15	RESERVED5	VARCHAR	保留字段	x	√

提示

STO_NODES 字段是Binary类型，可以使用FORMAT_BINARY_TO_NUMBER(STO_NODES,2,4)进行可读格式化

应用举例

• 查看空闲域状态

SQL> select DB_ID, USER_ID, ZONE_ID, ZONE_NAME, SRV_NUM, format_binary_to_number(STO_NODES,2,4) STO_NODES, CREATE_TIME, ENABLE, IS_SYS, IS_LOCAL, COMMENTS from SYS_STO_ZONES;
+-------+---------+---------+-----------+---------+-----------+--------------------------+--------+--------+----------+--------------------+
| DB_ID | USER_ID | ZONE_ID | ZONE_NAME | SRV_NUM | STO_NODES |       CREATE_TIME        | ENABLE | IS_SYS | IS_LOCAL |      COMMENTS      |
+-------+---------+---------+-----------+---------+-----------+--------------------------+--------+--------+----------+--------------------+
| 1     | 1       | 0       | FREE_ZONE | 3       | 1,2,3     | 2025-07-04 09:33:53.492  | T      | F      | F        | free database node |
+-------+---------+---------+-----------+---------+-----------+--------------------------+--------+--------+----------+--------------------+

• 创建存储域(具体使用方法详见《存储域》章节)

SQL> ALTER ZONE FREE_ZONE DISABLE NODE 1;

SQL> ALTER ZONE FREE_ZONE DISABLE NODE 2;

SQL> EXEC DBMS_STORAGE.MIGRATE_STORAGE('FREE_ZONE',1);

SQL> EXEC DBMS_STORAGE.MIGRATE_STORAGE('FREE_ZONE',2);

SQL> CREATE ZONE ZONE_TEST1 NODE '1,2';

SQL> select DB_ID, USER_ID, ZONE_ID, ZONE_NAME, SRV_NUM, format_binary_to_number(STO_NODES,2,4) STO_NODES, CREATE_TIME, ENABLE, IS_SYS, IS_LOCAL, COMMENTS from SYS_STO_ZONES;
+-------+---------+---------+------------+---------+-----------+--------------------------+--------+--------+----------+--------------------+
| DB_ID | USER_ID | ZONE_ID | ZONE_NAME  | SRV_NUM | STO_NODES |       CREATE_TIME        | ENABLE | IS_SYS | IS_LOCAL |      COMMENTS      |
+-------+---------+---------+------------+---------+-----------+--------------------------+--------+--------+----------+--------------------+
| 1     | 1       | 0       | FREE_ZONE  | 1       | 3         | 2025-07-04 09:33:53.492  | T      | F      | F        | free database node |
| 1     | 1       | 16      | ZONE_TEST1 | 2       | 1,2       | 2025-07-04 09:37:00.683  | T      | F      | F        | <NULL>             |
+-------+---------+---------+------------+---------+-----------+--------------------------+--------+--------+----------+--------------------+