V$ENCRYPTED_TABLESPACES - OceanBase 数据库 V4.3.5 | OceanBase 文档中心

文档反馈

分布式版-V4.3.5LTS

V4.3.5 文档更新记录
What's New
简介
快速上手
应用开发
部署
升级
数据迁移
管理数据库
AP
向量搜索
生态集成
实践教程
参考指南
- 系统原理
- 系统管理
- 数据库对象管理
- 数据库设计规范和约束
- SQL 参考
- PL 参考
- 系统视图
  - 系统视图概述
  - 系统视图总览
  - V3.x 与 V4.x 视图变更
  - SYS 租户系统视图
    - 字典视图
    - 性能视图
      - GV$ACTIVE_SESSION_HISTORY
      - GV$DML_STATS
      - GV$LATCH
      - GV$OB_ACTIVE_SESSION_HISTORY
      - GV$OB_COMPACTION_DIAGNOSE_INFO
      - GV$OB_COMPACTION_PROGRESS
      - GV$OB_COMPACTION_SUGGESTIONS
      - GV$OB_CGROUP_CONFIG
      - GV$OB_DTL_INTERM_RESULT_MONITOR
      - GV$OB_FLT_TRACE_CONFIG
      - GV$OB_FUNCTION_IO_STAT
      - GV$OB_GROUP_IO_STAT
      - GV$OB_IO_BENCHMARK
      - GV$OB_IO_CALIBRATION_STATUS
      - GV$OB_KVCACHE
      - GV$OB_KV_GROUP_COMMIT_STATUS
      - GV$OB_LOG_STAT
      - GV$OB_LOG_TRANSPORT_DEST_STAT
      - GV$OB_LS_SNAPSHOTS
      - GV$OB_MEMORY
      - GV$OB_MEMSTORE
      - GV$OB_MEMSTORE_INFO
      - GV$OB_MERGE_INFO
      - GV$OB_NIC_INFO
      - GV$OB_RPC_INCOMING
      - GV$OB_RPC_OUTGOING
      - GV$OB_PARAMETERS
      - GV$OB_PLAN_CACHE_PLAN_EXPLAIN
      - GV$OB_PLAN_CACHE_PLAN_STAT
      - GV$OB_PLAN_CACHE_STAT
      - GV$OB_PROCESSLIST
      - GV$OB_PS_ITEM_INFO
      - GV$OB_PS_STAT
      - GV$OB_PX_P2P_DATAHUB
      - GV$OB_PX_TARGET_MONITOR
      - GV$OB_PX_WORKER_STAT
      - GV$OB_RES_MGR_SYSSTAT
      - GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
      - GV$OB_SERVER_SCHEMA_INFO
      - GV$OB_SERVERS
      - GV$OB_SESS_TIME_MODEL
      - GV$OB_SESSION
      - GV$OB_SHARED_STORAGE_QUOTA
      - GV$OB_SQL_AUDIT
      - GV$OB_SQL_CCL_STATUS
      - GV$SQL_JOIN_FILTER
      - GV$OB_SQL_PLAN
      - GV$SQL_PLAN_MONITOR
      - GV$OB_SQL_WORKAREA_MEMORY_INFO
      - GV$OB_SQLSTAT
      - GV$OB_SSTABLES
      - GV$OB_SYS_TIME_MODEL
      - GV$OB_TABLET_COMPACTION_HISTORY
      - GV$OB_TABLET_COMPACTION_PROGRESS
      - GV$OB_TENANT_MEMORY
      - GV$OB_TENANT_RESOURCE_LIMIT
      - GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
      - GV$OB_TENANT_RUNTIME_INFO
      - GV$OB_TRANSACTION_PARTICIPANTS
      - GV$OB_TRANSACTION_SCHEDULERS
      - GV$OB_UNITS
      - GV$OB_VECTOR_MEMORY
      - GV$SESSION_EVENT
      - GV$SESSION_LONGOPS
      - GV$SESSION_WAIT
      - GV$SESSION_WAIT_HISTORY
      - GV$SESSTAT
      - GV$SQL_WORKAREA
      - GV$SQL_WORKAREA_ACTIVE
      - GV$SQL_WORKAREA_HISTOGRAM
      - GV$SYSSTAT
      - GV$SYSTEM_EVENT
      - gv$tenant
      - gv$tenant_memstore_allocator_info
      - GV$OB_ARBITRATION_MEMBER_INFO
      - GV$OB_ARBITRATION_SERVICE_STATUS
      - GV$OB_KV_CLIENT_INFO
      - GV$OB_LOCKS
      - GV$OB_OPT_STAT_GATHER_MONITOR
      - GV$OB_THREAD
      - GV$OB_PL_CACHE_OBJECT
      - GV$UNIT
      - V$OB_PL_CACHE_OBJECT
      - V$ACTIVE_SESSION_HISTORY
      - V$DML_STATS
      - V$ENCRYPTED_TABLESPACES
      - V$EVENT_NAME
      - V$LATCH
      - V$OB_ACTIVE_SESSION_HISTORY
      - V$OB_ARCHIVE_DEST_STATUS
      - V$OB_COMPACTION_DIAGNOSE_INFO
      - V$OB_COMPACTION_PROGRESS
      - V$OB_COMPACTION_SUGGESTIONS
      - V$OB_COMPATIBILITY_CONTROL
      - V$OB_CGROUP_CONFIG
      - V$OB_DTL_INTERM_RESULT_MONITOR
      - V$OB_DYNAMIC_PARTITION_TABLES
      - V$OB_ENCRYPTED_TABLES
      - V$OB_FUNCTION_IO_STAT
      - V$OB_GROUP_IO_STAT
      - V$OB_IO_BENCHMARK
      - V$OB_IO_CALIBRATION_STATUS
      - V$OB_KVCACHE
      - V$OB_KV_CLIENT_INFO
      - V$OB_KV_GROUP_COMMIT_STATUS
      - V$OB_LOG_STAT
      - V$OB_LOG_TRANSPORT_DEST_STAT
      - V$OB_LS_LOG_RESTORE_STATUS
      - V$OB_LS_REPLICA_TASK_PLAN
      - V$OB_LS_SNAPSHOTS
      - V$OB_MEMORY
      - V$OB_MEMSTORE
      - V$OB_MEMSTORE_INFO
      - V$OB_MERGE_INFO
      - V$OB_NIC_INFO
      - V$OB_RPC_INCOMING
      - V$OB_RPC_OUTGOING
      - V$OB_PARAMETERS
      - V$OB_PLAN_CACHE_PLAN_EXPLAIN
      - V$OB_PLAN_CACHE_PLAN_STAT
      - V$OB_PLAN_CACHE_STAT
      - V$OB_PROCESSLIST
      - V$OB_PS_ITEM_INFO
      - V$OB_PS_STAT
      - V$OB_PX_P2P_DATAHUB
      - V$OB_PX_TARGET_MONITOR
      - V$OB_PX_WORKER_STAT
      - V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
      - V$OB_RES_MGR_SYSSTAT
      - V$OB_SERVER_SCHEMA_INFO
      - V$OB_SERVERS
      - V$OB_SESS_TIME_MODEL
      - V$OB_SESSION
      - V$SESSION_EVENT
      - V$OB_SHARED_STORAGE_QUOTA
      - V$OB_SQL_AUDIT
      - V$OB_SQL_CCL_STATUS
      - V$SQL_JOIN_FILTER
      - V$OB_SQL_PLAN
      - V$OB_SQL_WORKAREA_MEMORY_INFO
      - V$OB_SQLSTAT
      - V$OB_SSTABLES
      - V$OB_SYS_TIME_MODEL
      - V$OB_TABLET_COMPACTION_HISTORY
      - V$OB_TABLET_COMPACTION_PROGRESS
      - V$OB_TENANT_MEMORY
      - V$OB_TENANT_RESOURCE_LIMIT
      - V$OB_TENANT_RESOURCE_LIMIT_DETAIL
      - V$OB_TENANT_RUNTIME_INFO
      - V$OB_TIMESTAMP_SERVICE
      - V$OB_TRANSACTION_PARTICIPANTS
      - V$OB_TRANSACTION_SCHEDULERS
      - V$OB_UNITS
      - V$RESTORE_POINT
      - V$RSRC_PLAN
      - V$SESSION_LONGOPS
      - V$SESSION_WAIT
      - V$SESSION_WAIT_HISTORY
      - V$SESSTAT
      - V$SQL_MONITOR_STATNAME
      - V$SQL_PLAN_MONITOR
      - V$SQL_WORKAREA
      - V$SQL_WORKAREA_ACTIVE
      - V$SQL_WORKAREA_HISTOGRAM
      - V$STATNAME
      - V$SYSSTAT
      - V$SYSTEM_EVENT
      - V$OB_ARBITRATION_MEMBER_INFO
      - V$OB_ARBITRATION_SERVICE_STATUS
      - V$OB_LOCKS
      - V$OB_OPT_STAT_GATHER_MONITOR
      - V$OB_THREAD
      - V$OB_VECTOR_MEMORY
      - v$tenant_memstore_allocator_info
      - V$UNIT
  - MySQL 租户系统视图
  - Oracle 租户系统视图
  - 常见统计事件说明
  - 常见等待事件说明
- 配置项和系统变量
- 错误码
- 性能调优
- 性能测试
- 数据库代理
- 驱动
- 平台产品
- 组件 & 工具
- 数据库插件
常见问题
版本发布记录
术语

V$ENCRYPTED_TABLESPACES

更新时间：2026-04-14 14:16:47

分享

说明

该视图从 V2.2.77 版本开始引入。

功能描述

展示当前租户下开启加密功能的表空间的加密状态。系统租户不能开启加密。

字段说明

字段名称	类型	是否可以为空	描述
TABLESPACE_ID	bigint(20)	NO	表空间 ID
ENCRYPTIONALG	varchar(30)	NO	加密算法名： AES-128 AES-192 AES-256 SM4
ENCRYPTED	varchar(3)	NO	是否完成加密： YES NO
ENCRYPTEDKEY	varchar(33)	NO	经过主密钥加密后的加密密钥
MASTERKEYID	bigint(20) unsigned	NO	主密钥版本
BLOCKS_ENCRYPTED	decimal(20,0)	NO	加密宏块的数量
BLOCKS_DECRYPTED	decimal(21,0)	NO	未加密宏块的数量
STATUS	varchar(10)	NO	加密状态： NORMAL：正常状态 ENCRYPTING：加密中 DECRYPTING：解密中
CON_ID	bigint(20)	NO	租户 ID

相关视图或文档

有关数据透明加密的详细介绍及操作，参见数据透明加密章节。

有帮助

无帮助