文档反馈

分布式版-V4.0.0企业版

文档概览
介绍
快速上手
应用开发
部署数据库
数据迁移
管理数据库
参考指南
- 系统架构
- 数据库设计规范
- SQL 语法
- PL 参考
- SQL 实践和建议
- 系统参考
  - 系统配置项
  - 系统变量（MySQL 模式）
  - 系统变量（Oracle 模式）
  - 系统视图（MySQL 模式）
    - 概述
    - 字典视图
      - 字典视图总览
      - information_schema.CHARACTER_SETS
      - information_schema.CHECK_CONSTRAINTS
      - information_schema.COLLATIONS
      - information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
      - information_schema.COLUMNS
      - information_schema.COLUMN_PRIVILEGES
      - information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
      - information_schema.ENGINES
      - information_schema.GLOBAL_STATUS
      - information_schema.GLOBAL_VARIABLES
      - information_schema.KEY_COLUMN_USAGE
      - information_schema.PARAMETERS
      - information_schema.PARTITIONS
      - information_schema.PROCESSLIST
      - information_schema.REFERENTIAL_CONSTRAINTS
      - information_schema.ROUTINES
      - information_schema.SCHEMA_PRIVILEGES
      - information_schema.SCHEMATA
      - information_schema.SESSION_STATUS
      - information_schema.SESSION_VARIABLES
      - information_schema.STATISTICS
      - information_schema.TABLES
      - information_schema.TABLE_CONSTRAINTS
      - information_schema.TABLE_PRIVILEGES
      - information_schema.USER_PRIVILEGES
      - information_schema.VIEW_TABLE_USAGE
      - information_schema.VIEWS
      - mysql.db
      - mysql.help_category
      - mysql.help_keyword
      - mysql.help_relation
      - mysql.help_topic
      - mysql.proc
      - mysql.time_zone
      - mysql.time_zone_name
      - mysql.time_zone_transition
      - mysql.time_zone_transition_type
      - mysql.user
      - oceanbase.DBA_IND_PARTITIONS
      - oceanbase.DBA_IND_SUBPARTITIONS
      - oceanbase.DBA_OB_DATABASES
      - oceanbase.DBA_OB_LS_LOCATIONS
      - oceanbase.DBA_OB_MAJOR_COMPACTION
      - oceanbase.DBA_OB_RESOURCE_POOLS
      - oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
      - oceanbase.DBA_OB_SERVER_JOBS
      - oceanbase.DBA_OB_SERVERS
      - oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
      - oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
      - oceanbase.DBA_OB_TABLEGROUP_TABLES
      - oceanbase.DBA_OB_TABLEGROUPS
      - oceanbase.DBA_OB_TABLET_REPLICAS
      - oceanbase.DBA_OB_TABLET_TO_LS
      - oceanbase.DBA_OB_TENANT_JOBS
      - oceanbase.DBA_OB_TENANTS
      - oceanbase.DBA_OB_UNIT_JOBS
      - oceanbase.DBA_OB_UNIT_CONFIGS
      - oceanbase.DBA_OB_UNITS
      - oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
      - oceanbase.DBA_OB_ZONES
      - oceanbase.DBA_OBJECTS
      - oceanbase.DBA_PART_INDEXES
      - oceanbase.DBA_PART_KEY_COLUMNS
      - oceanbase.DBA_PART_TABLES
      - oceanbase.DBA_OB_SEQUENCE_OBJECTS
      - oceanbase.DBA_SUBPART_KEY_COLUMNS
      - oceanbase.DBA_SUBPARTITION_TEMPLATES
      - oceanbase.DBA_TAB_PARTITIONS
      - oceanbase.DBA_TAB_SUBPARTITIONS
      - oceanbase.CDB_IND_COLUMNS
      - oceanbase.CDB_IND_PARTITIONS
      - oceanbase.CDB_IND_SUBPARTITIONS
      - oceanbase.CDB_INDEXES
      - oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
      - oceanbase.CDB_OB_DATABASES
      - oceanbase.CDB_OB_LS_LOCATIONS
      - oceanbase.CDB_OB_MAJOR_COMPACTION
      - oceanbase.CDB_OB_RESTORE_HISTORY
      - oceanbase.CDB_OB_RESTORE_PROGRESS
      - oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
      - oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
      - oceanbase.CDB_OB_TABLEGROUP_TABLES
      - oceanbase.CDB_OB_TABLEGROUPS
      - oceanbase.CDB_OB_TABLET_REPLICAS
      - oceanbase.CDB_OB_TABLET_TO_LS
      - oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
      - oceanbase.CDB_OBJECTS
      - oceanbase.CDB_PART_INDEXES
      - oceanbase.CDB_PART_KEY_COLUMNS
      - oceanbase.CDB_PART_TABLES
      - oceanbase.CDB_SUBPART_KEY_COLUMNS
      - oceanbase.CDB_SUBPARTITION_TEMPLATES
      - oceanbase.CDB_TAB_COL_STATISTICS
      - oceanbase.CDB_TAB_COLS
      - oceanbase.CDB_TAB_COLS_V$
      - oceanbase.CDB_TAB_PARTITIONS
      - oceanbase.CDB_TAB_SUBPARTITIONS
      - oceanbase.CDB_TABLES
      - oceanbase.CDB_OB_BACKUP_SET_FILES
      - oceanbase.DBA_OB_BACKUP_SET_FILES
      - oceanbase.CDB_OB_BACKUP_JOBS
      - oceanbase.DBA_OB_BACKUP_JOBS
      - oceanbase.CDB_OB_BACKUP_JOB_HISTORY
      - oceanbase.DBA_OB_BACKUP_JOB_HISTORY
      - oceanbase.CDB_OB_BACKUP_TASKS
      - oceanbase.DBA_OB_BACKUP_TASKS
      - oceanbase.CDB_OB_BACKUP_TASK_HISTORY
      - oceanbase.DBA_OB_BACKUP_TASK_HISTORY
      - oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
      - oceanbase.DBA_OB_RESTORE_PROGRESS
      - oceanbase.DBA_OB_RESTORE_HISTORY
      - oceanbase.CDB_OB_ARCHIVE_DEST
      - oceanbase.DBA_OB_ARCHIVE_DEST
      - oceanbase.CDB_OB_ARCHIVELOG
      - oceanbase.DBA_OB_ARCHIVELOG
      - oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
      - oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
      - oceanbase.CDB_OB_BACKUP_PARAMETER
      - oceanbase.DBA_OB_BACKUP_PARAMETER
      - oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
      - oceanbase.DBA_OB_OUTLINES
      - oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
      - oceanbase.CDB_OB_SYS_VARIABLES
      - oceanbase.CDB_OB_BACKUP_DELETE_JOBS
      - oceanbase.DBA_OB_BACKUP_DELETE_JOBS
      - oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
      - oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
      - oceanbase.CDB_OB_BACKUP_DELETE_TASKS
      - oceanbase.DBA_OB_BACKUP_DELETE_TASKS
      - oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
      - oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
      - oceanbase.CDB_OB_BACKUP_STORAGE_INFO
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO
      - oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
      - oceanbase.CDB_OB_BACKUP_DELETE_POLICY
      - oceanbase.DBA_OB_BACKUP_DELETE_POLICY
      - oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
      - oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
      - oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
      - oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
      - oceanbase.DBA_TAB_STATISTICS
      - oceanbase.DBA_TAB_COL_STATISTICS
      - oceanbase.DBA_PART_COL_STATISTICS
      - oceanbase.DBA_SUBPART_COL_STATISTICS
      - oceanbase.DBA_TAB_HISTOGRAMS
      - oceanbase.DBA_PART_HISTOGRAMS
      - oceanbase.DBA_SUBPART_HISTOGRAMS
      - oceanbase.DBA_TAB_STATS_HISTORY
      - oceanbase.DBA_SCHEDULER_JOBS
      - oceanbase.DBA_IND_STATISTICS
      - oceanbase.DBA_TAB_MODIFICATIONS
      - oceanbase.DBA_SQL_PLAN_BASELINES
      - oceanbase.DBA_SQL_MANAGEMENT_CONFIG
      - information_schema.QUERY_RESPONSE_TIME
      - oceanbase.CDB_OB_LS
      - oceanbase.DBA_OB_LS
      - oceanbase.CDB_OB_TABLE_LOCATIONS
      - oceanbase.DBA_OB_TABLE_LOCATIONS
      - oceanbase.DBA_OB_SERVER_EVENT_HISTORY
      - oceanbase.CDB_OB_FREEZE_INFO
      - oceanbase.DBA_OB_FREEZE_INFO
      - oceanbase.DBA_OB_LS_REPLICA_TASKS
      - oceanbase.CDB_OB_LS_REPLICA_TASKS
      - oceanbase.DBA_OB_AUTO_INCREMENT
      - oceanbase.CDB_OB_AUTO_INCREMENT
      - oceanbase.DBA_SEQUENCES
      - oceanbase.DBA_SCHEDULER_WINDOWS
      - oceanbase.DBA_OB_USERS
      - oceanbase.CDB_OB_USERS
      - oceanbase.DBA_OB_DATABASE_PRIVILEGE
      - oceanbase.CDB_OB_DATABASE_PRIVILEGE
    - 性能视图
  - 系统视图（Oracle 模式）
  - 错误码（MySQL 模式）
  - 错误码（Oracle 模式）
  - 预留关键字
  - 预留关键字
快速入门系列课程
版本发布记录

oceanbase.DBA_OB_TENANTS

更新时间：2026-05-20 12:38:46

分享

功能

展示所有租户的基本信息。包括系统租户、用户创建的租户（用户租户），以及 Meta 租户。用户可以根据 TENANT_TYPE 列来区分租户类型。

字段说明

字段名称	类型	是否可以为 NULL	描述
TENANT_ID	bigint(20)	NO	租户ID 1：系统租户 ID 其他值：用户租户或者 Meta 租户 ID
TENANT_NAME	varchar(128)	NO	租户名
TENANT_TYPE	varchar(4)	NO	租户类型 `SYS`：系统租户 `USER`：用户租户 `META`：Meta 租户
CREATE_TIME	timestamp(6)	YES	租户创建时间
MODIFY_TIME	timestamp(6)	YES	租户修改时间
PRIMARY_ZONE	varchar(128)	YES	租户 Primary Zone
LOCALITY	varchar(4096)	NO	租户副本分布信息
PREVIOUS_LOCALITY	varchar(4096)	NO	变更前的 Locality 信息如果该值有效，则说明 Locality 变更没有完成 `NULL`：表示没有进行 Locality 变更
COMPATIBILITY_MODE	varchar(6)	NO	兼容模式 `MYSQL`：MySQL 兼容模式 `ORACLE`：Oracle 兼容模式
STATUS	varchar(64)	NO	当前租户状态 `TENANT_STATUS_NORMAL`：正常状态租户 `TENANT_STATUS_RESTORE`：物理恢复中的租户 `TENANT_STATUS_CREATING`：正在创建的租户 `TENANT_STATUS_DROPPING`：正在删除的租户
IN_RECYCLEBIN	varchar(3)	NO	是否在回收站中 `YES`：在回收站中 `NO`：不在回收站中
LOCKED	varchar(3)	NO	是否锁定

有帮助

无帮助

oceanbase.DBA_OB_TENANTS | OceanBase 文档中心