OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase AI Database

V4.6.3
  • Introduction
    • Overview
    • Core features
    • System architecture
  • Get Started
    • Get started with OceanBase AI Database
  • Deploy
    • Choose an appropriate deployment plan
    • Deployment process
    • Before deployment
      • Prepare servers
      • Configure Servers
      • Prepare object storage
      • Prepare installation packages
      • Deploy OAT
    • Add a server
    • Deploy OCP
      • OCP deployment overview
      • Upload installation packages
      • Create MetaDB
      • Deploy OCP
    • Deploy OceanBase AI Database
      • Create an object storage configuration
      • Deploy a LogService cluster by using OCP
      • Deploy an OceanBase AI Database cluster using OCP
    • (Optional) Deploy OBProxy
    • Deploy Java SDK
    • Recommended configurations
  • Connect
    • Overview of connection methods
    • Clients
      • MySQL client
      • OBClient
      • ODC
    • GUI tools
      • DBeaver
      • Navicat
    • Drivers and ORMs
      • Connect via driver or ORM framework
      • Examples
        • C#
          • MySQL Connector/C
        • Go
          • Go-SQL-Driver/MySQL
          • GORM
        • Java
          • Connector/J
          • Spring JDBC
          • SpringBoot
          • SpringBatch
          • SpringDataJPA
          • Hibernate
          • MyBatis
          • TestContainers
        • PHP
          • EXT
          • MySQLi
          • PDO
        • Python
          • PyMySQL
          • mysqlclient
          • MySQL-connector-python
          • SQLAlchemy
          • Django
          • peewee
    • Connection pool
      • Database connection pool configuration
      • Tomcat
      • C3P0
      • Proxool
      • HikariCP
      • DBCP
      • Commons Pool
      • Druid
      • JDBC
    • Connect to OceanBase AI Database by using SDK
  • Design Database Schema
    • Overview of database schema design
    • Table design
    • Data distribution
    • Indexes
    • Data types
    • Logical table
      • Logical table overview
      • Agent hybrid search scenario
        • Overview
        • Quick start
        • Collection and namespace management
        • Write data
        • Search data
        • Indexes and embedding functions
        • Monitoring and maintenance
        • API reference
      • Flash application scenario
        • Overview
        • Limitations and constraints
        • Connect
        • Quick start
        • Collection and app management
        • Data operations
  • Data Pipeline
    • Data ingestion
      • Data migration
        • Data migration overview
        • Use mydumper and myloader to migrate data from a MySQL database
        • Use DBCAT to migrate table structures from a MySQL database
        • Use DataX to migrate table data from a MySQL database
        • Use DBCAT to migrate table structures from an Oracle database
        • Use DataX to migrate table data from an Oracle database
        • Use DBCAT to migrate table structures from a DB2 LUW database
        • Migrate from CSV files
          • Use DataX
          • Use LOAD DATA
        • Migrate by using SQL statements
          • Migrate data between tables
          • Migrate resource units
          • Export data using the OUTFILE statement
      • Data import
        • Data import overview
        • Import data by using the LOAD DATA statement
        • INSERT INTO SELECT
          • Use the INSERT INTO SELECT FROM FILES statement for direct load
          • Import data from external tables using INSERT INTO SELECT
        • Import data via direct load using the CREATE TABLE AS SELECT statement
        • Import data by using obloader
    • Data delivery
      • Export data
      • Data lake
        • Data lake overview
        • Data lake integration
          • Access Hive tables through HMS Catalog
          • Load an Iceberg table through Catalog
          • Read Paimon tables by using plugins
          • ODPS Catalog and external tables
          • Catalogs and external tables
          • File external tables
        • External tables via URL
    • Data sharing
      • Automatic catalog data synchronization
      • Manual catalog data synchronization
  • Data Processing
    • Structured data processing
      • In-database processing
      • Materialized views
      • Data processing tools
    • Unstructured data processing
      • Vector embedding
        • Overview of Vector Embedding Technology
        • Use the AI_EMBED function
        • Use external embedding models
  • Data Branching
    • Overview of Fork
    • Fork Table
    • Fork Database
  • AI Search
    • Vector search
      • Vector search overview
      • Perform vector search using SQL
      • Vector data types overview
      • Store vector data
      • Vector index
        • Overview of vector indexes
        • Vector index memory management
        • Dense index
          • Overview of dense indexes
          • Index type selection
          • HNSW series indexes
          • IVF series indexes
        • Sparse index
          • In-memory sparse vector index
        • Monitor and maintain indexes
        • Index performance optimization
      • Search index
      • Use SQL functions
      • Vector nearest neighbor search
      • FAQ on AI scenarios
    • Semantic search
    • Full-text search
    • Hybrid search
    • Rerank search
  • Query Acceleration
    • Statistics
    • Choose the query parallelism
    • Accelerate queries with materialized views
  • Manage
    • Log in to an user tenant
    • Manage clusters
      • Cluster overview
      • Compute service management
        • Cluster parameters
        • Common cluster operations
          • View a zone
          • View a node
          • Restart a node
          • Add a node
          • Delete a node
          • Isolate a node
          • Replace a node
          • Start a zone
          • Add a zone
          • Delete a zone
          • Modify a zone
          • Isolate a zone
          • View cluster parameters
          • Modify cluster parameters
          • Reset cluster parameters
          • Update object storage access credentials
        • Data load balancing
          • Data load balancing overview
          • Transfer a partition
          • Cancel a partition transfer task
          • Cancel a balance job
          • Stop and resume a balance job
          • Table group weight management
            • Aggregation of user tables under a database
            • Set table group weights
            • Clear a table group's weight
            • Application scenarios of table group weight balancing
          • Partition weight management
            • Set partition weights
            • Clear partition weights
          • Partition balance management
            • Configure a scheduled partition balancing task
            • Manually trigger partition balancing
            • View the configurations of a scheduled partition balancing task
            • View the trigger history of scheduled partition balancing tasks
            • View background partition balancing tasks
            • View the history of background partition balancing tasks
          • GTS exclusive application case
      • Object storage management
        • Object storage overview
        • Update object storage information
        • Object storage-related views and parameters
        • FAQ on object storage
      • LogService management
        • LogService parameters
        • LogService operations
          • View a LogService node
          • Add a LogService node
          • Delete a LogService node
          • Replace a LogService node
          • Rotate LogService access credentials
          • View LogService parameters
          • Modify LogService parameters
        • LogService load balancing
          • LogService load balancing overview
          • View the load balancing status
          • Configure the load balancing strategy
    • Manage tenants
      • Tenant introduction
      • Tenant capacity
      • Tenant types
      • User tenant introduction
      • Tenant system variables
      • Common tenant operations
        • Create a tenant
        • Resource isolation
          • Resource isolation overview
          • Configure cgroup
          • Configure global CPU resource isolation for foreground and background tasks
          • Calibrate disk performance
          • Configure resource isolation within a tenant
          • Update a plan directive
          • Delete a plan directive
          • Delete a resource management plan
          • Delete a resource group
          • Clear cgroup configurations
          • Resource isolation configuration examples for background tasks
        • View tenant and resource information
        • View and set the tenant allowlist
        • View tenant system variables
        • Modify tenant system variables
        • Scale in/out
          • Introduction to tenant scaling
          • Resource planning for tenant scaling
          • Tenant pre-scaling
          • Scale tenants by adjusting resource specifications
          • Scale tenants by adjusting the unit number
          • Scale tenants by adjusting the primary zone
          • Smooth scaling application scenarios
        • Modify attributes of a resource pool
        • Modify tenant attributes
        • Lock and unlock a tenant
        • Drop a tenant
        • Restore a tenant
        • Rename a tenant
        • Manage resource pools
          • View resource pools
          • Allocate a resource pool to a tenant
          • Remove resource pools from a tenant
          • Merge and split a resource pool
          • Drop a resource pool
        • Manage resource specifications
          • View resource specifications
          • Modify a unit config
          • Drop a unit config
    • Manage log streams
      • Create a log stream
      • Modify a log stream
    • Manage replicas
      • Replicas
      • Replica distribution
        • Locality
        • Common locality operations
          • View locality
          • Modify locality
          • Add a replica
          • Reduce replicas
          • Adjust the distribution of replicas
          • View the locality change history
          • Replica migration
          • Modify the quorum size of a log stream
          • Cancel a replica task
      • Traffic distribution
      • Data distribution
    • High availability
      • High availability overview
      • Multi-replica disaster recovery
        • Data link introduction
        • High availability at the proxy layer
        • High availability at the database layer
        • Disaster recovery deployment solutions
      • Manage recycle bin
        • Overview of the recycle bin
        • Enable or disable the recycle bin
        • View recycle bin objects
        • Restore objects from the recycle bin
        • Clean up the recycle bin
      • Flashback query
    • Security and permissions
      • Overview of security permissions
      • Identification and authentication
        • Identity authentication
          • Identity authentication
          • Password complexity
          • Handle login failures
      • Access control
        • Overview of access control
        • Users and permissions
          • User and permission overview
          • Permissions
            • Permission classification
            • Create a user
            • Grant privileges directly
            • Privilege delegation
            • Role management
              • Role management overview
              • Create a role
              • Add privileges to a role
              • Grant roles to users or other roles
              • Activate a role
              • View roles
              • Revoke privileges from a role
              • Revoke roles from a user or role
              • Drop a role
            • Indirect authorization
            • View user privileges
            • Revoke privileges
            • Lock or unlock a user
            • Drop a user
        • Row-level security
          • Row-level security
        • Network security access control
        • RPC connection authentication
      • Data encryption
        • Data encryption overview
        • Data transmission encryption
          • Overview of data transmission encryption
          • Transport encryption for OBServer
          • ODP transmission encryption
        • Tenant master key management
          • Overview of tenant master keys
          • Generate tenant master key
        • Data storage encryption
          • Overview of database transparent encryption
          • Set up transparent data encryption for a newly created table
          • Enable transparent data encryption for an existing table
          • Decrypt a table
        • Column encryption
          • Column encryption overview
          • Create a column encryption rule
          • Column encryption privilege management
          • FAQ on column encryption
      • Security audit
        • Security audit overview
        • Security audit
          • Enable security auditing
          • Set an auditing rule
          • View auditing records
          • Disable security auditing
    • Backup and restore
      • Overview of physical backup and restore
      • Physical backup and restore with a minimal experience
      • Log archive
        • Overview of log archiving
        • Prepare for log archiving
        • Enable archiving mode
        • Suspend archiving
        • Disable archiving mode
        • View piece information
        • View archiving progress
        • View the archiving history
        • View archive parameters
        • Change the archive destination
        • Clear the archive path configuration
        • Introduction to log archiving views
      • Data backup
        • Data backup overview
        • Prepare for backup
        • Initiate a full data backup
        • Back up parameters
        • Stop a backup
        • View the data backup progress
        • View data backup results
        • View data backup parameters
        • Change the backup destination
        • Introduction to data backup-related views
      • Update object storage key information
      • Clear backup data
        • Automatic backup cleanup
          • Automatically clean up expired backups
          • Delete a cleanup policy
        • Manual backup cleanup
          • Manually trigger expired backup cleanup
          • Manually clean up specified backup or archive data
          • Manually clear a backup or archive path
        • Cancel a cleanup task
        • View backup cleanup progress
        • View backup cleanup results
        • Introduction to backup cleanup parameters
        • Introduction to cleanup-related views
      • Restore data
        • Preparations before restore
        • Perform physical restore
        • Restore from a specified path
        • Cancel physical restore
        • View the physical restore progress
        • View the result of physical restore
        • Segment-based log replay for a standby tenant
        • Convert a standby tenant into a primary tenant
        • Upgrade a tenant after restore is complete
        • Introduction to physical restore parameters
        • Introduction to views related to physical restore
      • Backup and restore performance tuning
      • Appendix: S3 path format
    • Monitor
      • Monitoring overview
      • Metrics
        • System monitoring
          • Overview of system monitoring metrics
          • SYSSTAT metrics
          • Wait events
          • Lock events
        • SQL monitoring
          • Overview of SQL monitoring
          • SQL audit
          • Execution plans
      • Root service events
      • Cases
    • Logs
      • Log overview
      • Log levels
      • Log interpretation
      • Log stability
      • Log control methods
      • Log compression and decompression
      • Log monitoring metrics
      • Alert logs
      • View logs
        • Search for the logs of a specific SQL request
        • Query the log of a previous SQL request by using the SQL Trace feature
  • Performance Test
    • TPC-DS
      • OceanBase AI Database TPC-DS test
      • OceanBase AI Database TPC-DS test report
    • TPC-H
      • OceanBase AI Database TPC-H test
      • OceanBase AI Database TPC-H test report
  • Reference
    • System management
      • Configuration management
        • Introduction to Configuration Management
        • Set parameters
        • Set variables
      • Storage management
        • Minor compaction management
          • Overview of minor compaction
          • Automatic minor compaction
          • Manually trigger a minor compaction
          • View minor compaction information
          • Modify minor compaction settings
        • Major compaction management
          • Overview of major compaction management
          • Automatically trigger a major compaction
          • Schedule daily tenant major compactions
          • Window compaction
          • Adaptive compaction
          • Manually trigger a major compaction
          • View major compaction information
          • Manually control a major compaction
          • Modify major compaction configuration
        • Data compression
          • Data compression overview
          • Use data encoding and compression
        • Use the TTL feature
        • Custom hot and cold data storage policies
          • Overview of custom hot/cold storage policies
          • Create a table-level hot/cold storage policy
          • Create a partition-level hot/cold storage policy
          • Modify a table-level hot/cold storage policy
          • Modify a partition-level hot/cold storage policy
          • O&M guide for custom hot/cold storage policies
      • Memory management
        • Memory management overview
        • Memory structure
        • Set the maximum memory for a database
        • Internal system memory management
        • Memory management within a tenant
        • Plan cache memory management
        • Memleak-based regular memory leak diagnostics mechanism
        • View memory usage information
        • Common memory issues
      • Process management
        • Overview of OceanBase AI Database threads
        • Multi-tenant threads
        • View thread status
        • Background threads of OceanBase AI Database
        • FAQ about multi-tenant threads
      • Disk management
        • Configure dynamic expansion of disk data files
        • View disk space usage of a tenant or table
    • Database object management
      • Overview of database object management
      • Create and manage databases
        • Create a database
        • View databases
        • Modify a database
        • Drop a database
      • Create and manage tables
        • About tables
        • Create a table
        • Column Skip Index attribute
        • Define an auto-increment column
        • Define column constraints
        • View tables
        • Modify a table
        • Change the attribute of a replicated table
        • Truncate a table
        • Drop a table
        • Lock a table
        • Create and manage external tables
          • External tables and external files
          • Create and query external tables
          • Create a partitioned external table
          • Manage external files
          • Data type mappings
      • Create and manage partitions
        • Partitioning overview
        • Create a partitioned table
        • Partition splitting
          • Overview of partition splitting
          • Manually split a partition
          • Automatic partition splitting
          • Recommended configurations for automatic partitioning
        • Dynamic partitioning
          • Overview of dynamic partitioning
          • Create a dynamic partitioned table
          • View a dynamic partitioned table
          • Modify a dynamic partitioned table
          • Dynamic partition management tasks
        • Modify partitioning rules
        • Add a partition
        • Drop a partition
        • Truncate partitions
        • Partition pruning
        • Query data from a specified partition
        • Create indexes on partitioned tables
          • Index overview
          • Local index
          • Global index
        • Partition exchange
      • Create and manage table groups
        • About table groups
        • Create a table group
        • View table group information
        • Add tables to a table group
        • Modify the SHARDING attribute of a table group
        • Manage tables within a table group
        • Delete a table group
      • Create and manage indexes
        • About indexes
        • Create an index
        • View indexes
        • Monitor indexes
        • Drop an index
        • List of system functions supported for function-based indexes
        • List of system functions not supported for function-based indexes
      • Manage views
        • Manage regular views
        • Manage materialized views
          • Overview of materialized views
          • Materialized view logs
          • Create a materialized view
          • Refresh a materialized view
          • Query rewrite using materialized views
          • Query materialized views
          • Modify materialized view attributes
          • Drop a materialized view
          • Materialized view resource isolation
      • Create and manage sequences
        • Create a sequence
        • View sequences
        • Reference a sequence
        • Modify a sequence
        • Drop a sequence
      • Create and manage triggers
        • Overview
        • Create a DML trigger
        • View trigger information
        • Drop a trigger
      • Create and manage DBLinks
        • Create a DBLink
        • View created DBLinks
        • Manage DBLinks
        • Access data in a remote database through DBLink
        • Drop a DBLink
      • Create and manage catalogs
        • Overview of Catalog
        • Create a catalog
        • View catalogs
        • Drop a catalog
    • Write and read data
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
        • Generate test data in batches
      • Read data
        • Single-table query
        • Join tables
          • INNER JOIN
          • FULL JOIN
          • LEFT JOIN
          • RIGHT JOIN
          • Subqueries
          • Lateral derived table
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numeric functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use time functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use the CASE conditional operator in queries
          • Lock query results with SELECT FOR UPDATE
          • Lock in share mode
          • Use regular expressions in queries
        • Query using DBLink
        • Set operations
    • Transaction management
      • Transaction management overview
      • Start a transaction
      • Savepoints
        • Mark a savepoint
        • Roll back a transaction to a savepoint
        • Release a savepoint
      • Commit a transaction
      • Roll back a transaction
    • AI Function service
      • Overview of AI Function Service
      • Get started with AI Function Service
      • AI Function Service Permissions
      • Register an AI model
      • Interaction with AI models (Batch File)
      • Syntax and examples of AI functions
      • View AI model information
    • SQL reference
      • SQL syntax
        • System tenants
          • Overview of management commands
          • ALTER SYSTEM
            • ACTIVATE STANDBY
            • ADD REPLICA
            • ADD RESTORE SOURCE
            • ARCHIVELOG
            • BOOTSTRAP
            • BACKUP KEY
            • BACKUP
            • BACKUP CLUSTER PARAMETERS
            • BALANCE TASK
            • BALANCE JOB
            • CANCEL BACKUP
            • CANCEL DELETE BACKUP
            • CANCEL MIGRATE UNIT
            • CANCEL REPLICA TASK
            • CANCEL RESTORE
            • CANCEL RECOVER TABLE
            • CANCEL TRANSFER PARTITION
            • CREATE LS
            • CLEAR RESTORE SOURCE
            • DELETE BACKUP POLICY
            • DELETE BACKUP ALL
            • DELETE BACKUPSET/ARCHIVELOG_PIECE
            • DELETE OBSOLETE BACKUP
            • LOAD MODULE DATA
            • MAJOR AND MINOR
            • MIGRATE REPLICA
            • MIGRATE UNIT
            • MODIFY LS
            • MODIFY PAXOS_REPLICA_NUM
            • MODIFY REPLICA
            • NOARCHIVELOG
            • FLUSH PLAN CACHE
            • FLUSH SEQUENCE CACHE
            • FLUSH LOCAL_CACHE
            • FLASHBACK STANDBY LOG
            • JOB
            • SET LOG_RESTORE_SOURCE
            • PARAMETER
            • RECOVER STANDBY
            • RECOVER STANDBY CANCEL
            • REMOVE REPLICA
            • REFRESH
            • RESTORE
            • RESTORE PREVIEW
            • SET DATA_BACKUP_DEST
            • SERVER
            • SERVICE_NAME
            • SWITCHOVER
            • SET LOG_ARCHIVE_DEST
            • SET LOG_ARCHIVE_DEST_STATE
            • THROTTLE
            • TRANSFER PARTITION
            • TTL
            • WASH MEMORY FRAGMENTATION
            • ZONE
          • ALTER RESOURCE POOL
          • ALTER RESOURCE TENANT
          • ALTER RESOURCE UNIT
          • ALTER TENANT
          • CREATE RESOURCE POOL
          • CREATE RESOURCE UNIT
          • CREATE TENANT
          • DROP RESOURCE POOL
          • DROP RESOURCE UNIT
          • DROP TENANT
          • SET DECRYPTION
          • SET ENCRYPTION
          • SHOW RESTORE PREVIEW
        • User tenants
          • Basic elements
            • ROWID Pseudo-Column
            • Data types
              • Overview of data types
              • Numeric types
                • Overview of numeric types
                • Integer types
                • Fixed-point types
                • Floating-point types
                • BIT-Value type
              • Datetime types
                • Overview of date and time types
                • DATE, DATETIME and TIMESTAMP types
                • TIME type
                • YEAR type
              • String types
                • Character type overview
                • CHAR and VARCHAR
                • BINARY and VARBINARY
              • Large objects and text types
                • Overview of LOB and text types
                • BLOB type
                • TEXT type
                • STRING type
                • LOB types
                • LOB_WRITEAPPEND
              • Enumeration types
              • Collection types
              • JSON data types
                • Overview of the JSON data type
                • Create a JSON value
                • Query and modify JSON values
                • JSON data type conversion
                • Update partial data in a JSON document
                • Semi-structured encoding
              • Spatial data types
                • Overview of spatial data types
                • Spatial Reference System (SRS)
                • Create a spatial column
                • Create a spatial index
                • Spatial data formats
              • Roaring bitmap types
                • Overview of Efficient Compression for Bitmap Data Types
                • Create an efficient compressed bitmap column
              • Array data types
                • Overview of Array Element Types
                • Create an array column
              • Map data types
                • Overview of mapped data types
                • Create a mapped column
            • Expressions
              • Overview of Expressions
              • Syntax of Expressions
              • Simple Expressions
              • Compound Expressions
              • Conditional Expressions
              • Column Expressions
              • Date and time expressions
              • Function Expressions
              • Interval Expressions
              • Scalar subquery expressions
              • List of Expressions
              • Data type conversion rules
            • Character set and collation
              • Overview
              • Character sets
              • Collation
              • Database-level character set and collation
              • Table-level character set and collation
              • Column-level character set and collation
              • Character expression character sets and collations
              • Character set and collation of client connections
            • Literals
              • Overview of Literals
              • String text
              • Numbers
              • Date and time values
              • Bit value
              • Boolean values
              • NULL values
            • Schema object name
            • User-defined variables
            • Annotations
              • Hints
                • Overview of hints
                • Control query optimization using the Query Block Name and QB_NAME hint
                • Hint list
                  • Global hints
                    • Optimizer Stats Hint under Global Hint Types
                    • Transform hint under global hints
                    • Other hints under global hints
                  • Optimizer hints
                    • Access path hints under the Optimized hint type
                    • Join Order Hint under Optimized Hint Type
                    • Join Operation Hint under Optimized Hint Type
                    • Subquery hint under Optimized hint type
                    • Group by hint under optimized hint type
                    • DISTINCT hint under Optimized hint type
                    • Set hint under Optimized hint type
                    • Distributed DML Hints under Optimized Hint Type
                    • Vector Index Hint under Optimized Hint Type
                  • Transform hints
                    • Stmt Transform Hint under the Transform Hint Type
                    • Cost Based Transform Hint under the Transform Hint Type
                    • Transform Hints of the Heuristics Type
                    • Other hints under the Transform hint type
                  • Outline-related hint
            • Comments
          • Operators
            • Operator overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operators
            • Date and time operators
            • Character concatenation operators
            • BINARY conversion operator
            • CASE Conditional Operator
          • Functions
            • Function overview
            • Single-row functions
              • Datetime functions
                • ADDDATE
                • CONVERT_TZ
                • CURDATE
                • CURRENT_DATE
                • CURRENT_TIME
                • CURRENT_TIMESTAMP
                • CURTIME
                • DATE
                • DATE_ADD
                • DATE_FORMAT
                • DATE_SUB
                • DATEDIFF
                • DAYOFMONTH
                • DAYOFWEEK
                • DAYOFYEAR
                • EXTRACT
                • FROM_DAYS
                • FROM_UNIXTIME
                • GET_FORMAT
                • HOUR
                • LAST_DAY
                • LOCALTIME
                • LOCALTIMESTAMP
                • MAKEDATE
                • MAKETIME
                • MICROSECOND
                • MINUTE
                • MONTH
                • MONTHNAME
                • NOW
                • PERIOD_ADD
                • PERIOD_DIFF
                • QUARTER
                • SEC_TO_TIME
                • SECOND
                • STR_TO_DATE
                • SUBDATE
                • SUBTIME
                • SYSDATE
                • TIME
                • TIME_FORMAT
                • TIME_TO_SEC
                • TIME_TO_USEC
                • TIMEDIFF
                • TIMESTAMP
                • TIMESTAMPADD
                • TIMESTAMPDIFF
                • TO_DAYS
                • TO_SECONDS
                • UNIX_TIMESTAMP
                • USEC_TO_TIME
                • UTC_DATE
                • UTC_TIME
                • UTC_TIMESTAMP
                • WEEK
                • WEEKDAY
                • WEEKOFYEAR
                • YEARWEEK
                • YEAR
                • ADDTIME
                • DAYNAME
                • DAY
                • DATE_TRUNC
                • MONTHS_ADD
                • FORMATDATETIME
                • TOUNIXTIMESTAMP
                • parseDateTime
              • String functions
                • ASCII
                • BIN
                • BIT_LENGTH
                • CHAR
                • CHAR_LENGTH
                • CHARACTER_LENGTH
                • CONCAT
                • CONCAT_WS
                • ELT
                • EXPORT_SET
                • FIELD
                • FIND_IN_SET
                • FORMAT
                • HEX
                • INSERT
                • INSTR
                • INT2IP
                • IP2INT
                • KEYVALUE
                • LCASE
                • LEFT
                • LENGTH
                • LOCATE
                • LOWER
                • LPAD
                • LTRIM
                • MAKE_SET
                • MAX_PT
                • MD5_CONCAT_WS
                • MID
                • OCT
                • OCTET_LENGTH
                • ORD
                • POSITION
                • QUOTE
                • REGEXP
                • REGEXP_INSTR
                • REGEXP_LIKE
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPEAT
                • REPLACE
                • REVERSE
                • RIGHT
                • RLIKE
                • RPAD
                • RTRIM
                • SPACE
                • SPLIT_PART
                • STRCMP
                • SUBSTR
                • SUBSTRING
                • SUBSTRING_INDEX
                • TRIM
                • UCASE
                • UNHEX
                • UPPER
                • URL_DECODE
                • URL_ENCODE
                • WEIGHT_STRING
                • TO_BASE64
                • FROM_BASE64
                • SOUNDEX
                • EDITDISTANCE
              • Conversion functions
                • CAST
                • CONVERT
                • DECODE_TRACE_ID
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_CHAR(character)
                • TO_CHAR(number)
                • TO_CHAR(datetime)
                • TO_DATE
              • Mathematical functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BIT_COUNT
                • CEIL
                • CEILING
                • CONV
                • COS
                • COT
                • CRC32
                • DEGREES
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • LOG
                • LOG10
                • LOG2
                • MOD
                • NEG
                • PI
                • NORMAL
                • POW
                • POWER
                • RADIANS
                • RAND
                • RANDOM
                • RANDSTR
                • ROUND
                • SIGN
                • SIN
                • SQRT
                • TAN
                • TRUNCATE
                • UNIFORM
                • ZIPF
              • Comparison functions
                • GREATEST
                • INTERVAL
                • ISNULL
                • LEAST
              • Process control functions
                • CASE
                • IF
                • IFNULL
                • NULLIF
                • ORA_DECODE
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • ARG_MAX
              • ARG_MIN
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • STRING_AGG
              • AVG_WEIGHTED
              • ARBITRARY
              • ANY
              • GROUPCONCAT
              • STDDEVSAMP
              • UNIQ
              • VARSAMP
            • Analysis functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • LAG
              • LAST_VALUE
              • LEAD
              • MAX
              • MIN
              • NTH_VALUE
              • NTILE
              • PERCENT_RANK
              • PERCENTILE_CONT
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • LAGINFRAME
              • LEADINFRAME
            • Encryption functions
              • AES_DECRYPT
              • AES_ENCRYPT
              • COMPRESS
              • DECODE
              • DES_DECRYPT
              • DES_ENCRYPT
              • ENCODE
              • ENCRYPT
              • ENHANCED_AES_ENCRYPT
              • ENHANCED_AES_DECRYPT
              • MD5
              • PASSWORD
              • UNCOMPRESS
              • UNCOMPRESSED_LENGTH
              • RANDOM_BYTES
              • SHA
              • SHA1
              • SHA2
              • VALIDATE_PASSWORD_STRENGTH
              • SM3
              • SM4_ENCRYPT
              • SM4_DECRYPT
            • Information functions
              • BENCHMARK
              • CATALOG
              • CHARSET
              • COERCIBILITY
              • COLLATION
              • CONNECTION_ID
              • CURRENT_ROLE
              • CURRENT_USER
              • DATABASE
              • FOUND_ROWS
              • LAST_INSERT_ID
              • LAST_INSERT_ID Behavior Description
              • ICU_VERSION
              • OB_TRANSACTION_ID
              • ROW_COUNT
              • SCHEMA
              • SESSION_USER
              • SYSTEM_USER
              • USER
              • VERSION
              • OB_VERSION
            • JSON functions
              • Overview of JSON functions
              • Functions for creating JSON text
                • JSON_ARRAY
                • JSON_OBJECT
                • JSON_QUOTE
              • Functions for searching JSON text
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_OVERLAPS
                • JSON_SEARCH
                • JSON_VALUE
                • MEMBER OF
              • Functions for modifying JSON text
                • JSON_ARRAY_APPEND
                • JSON_APPEND
                • JSON_ARRAY_INSERT
                • JSON_INSERT
                • JSON_MERGE
                • JSON_MERGE_PATCH
                • JSON_MERGE_PRESERVE
                • JSON_REMOVE
                • JSON_REPLACE
                • JSON_SET
                • JSON_UNQUOTE
              • Functions for returning JSON text properties
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON_TABLE function
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
              • JSON schema validation functions
                • JSON_SCHEMA_VALID
                • JSON_SCHEMA_VALIDATION_REPORT
            • XML functions
              • Overview of XML functions
              • Functions for querying XML data
                • EXTRACTVALUE
              • Functions for modifying XML data
                • UPDATEXML
            • Table functions
              • Overview of TABLE FUNCTIONS
              • FILES table function
            • Spatial functions
              • Overview of Spatial Functions
              • Create a geometric value function
              • Spatial operators
              • Spatial relationship functions
              • Geometric property functions
              • Geometric format conversion functions
              • Spatial analysis functions
              • Spatial Constructors
              • Spatial accessor functions
              • Spatial format conversion functions
              • Geometric Processing Functions
              • _ST_GeoHash
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIME
            • Lock functions
              • Overview of Lock Functions
              • GET_LOCK
              • IS_FREE_LOCK
              • IS_USED_LOCK
              • RELEASE_ALL_LOCKS()
              • RELEASE_LOCK
            • Bitmap functions
              • Overview of bitmap functions
              • Bitmap Constructor
              • Bitmap cardinality functions
              • Bitmap arithmetic functions
              • Bitmap predicate functions
              • Bitmap output functions
              • Bitmap aggregate functions
            • Array functions
              • Overview of array functions
              • Array constructor
              • Array comparison functions
              • Array output functions
              • Array functions
            • Text processing functions
              • TOKENIZE
            • Audit functions
              • Overview of audit functions
              • AUDIT_LOG_FILTER_REMOVE_FILTER
              • AUDIT_LOG_FILTER_REMOVE_USER
              • AUDIT_LOG_FILTER_SET_FILTER
              • AUDIT_LOG_FILTER_SET_USER
            • Map functions
              • Overview of mapping functions
              • Constructor of Map
              • Mapping judgment function
              • Mapping functions
            • Other functions
              • ANY_VALUE
              • BIN_TO_UUID
              • COALESCE
              • DEFAULT
              • NAME_CONST
              • INET_ATON
              • INET_NTOA
              • INET6_ATON
              • INET6_NTOA
              • IS_IPV4
              • IS_IPV4_COMPAT
              • IS_IPV6
              • IS_UUID
              • MATCH AGAINST
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
              • ISNAN
          • Queries and subqueries
            • Overview
            • Subquery
            • Connections
            • Full-text query
          • SQL statements
            • General syntax
            • Generalized Table Expressions
            • ALTER COMPILE
            • ALTER DATABASE
            • ALTER LOCATION
            • ALTER MATERIALIZED VIEW
            • ALTER MATERIALIZED VIEW LOG
            • ALTER OUTLINE
            • ALTER EXTERNAL TABLE
            • ALTER SENSITIVE RULE
            • ALTER POLICY
            • ALTER SEQUENCE
            • ALTER/CHANGE/MODIFY EXTERNAL_STORAGE_DEST
            • ALTER SYSTEM FLUSH SEQUENCE CACHE
            • MAJOR AND MINOR
            • STORAGE_CACHE_POLICY_EXECUTOR
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER TABLESPACE
            • ALTER USER
            • ALTER VIEW
            • ALTER INSTANCE ROTATE INNODB MASTER KEY
            • ALTER EVENT
            • ANALYZE
            • CACHE INDEX
            • CREATE CONCURRENT_LIMITING_RULE
            • CREATE DATABASE
            • CREATE DATABASE LINK
            • CREATE EXTERNAL CATALOG
            • CREATE EXTERNAL TABLE
            • CREATE INDEX
            • CREATE LOCATION
            • CREATE MATERIALIZED VIEW
            • CREATE MATERIALIZED VIEW LOG
            • CREATE OUTLINE
            • CREATE POLICY
            • CREATE FORMAT OUTLINE
            • CREATE ROLE
            • CREATE SENSITIVE RULE
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE TABLESPACE
            • CREATE USER
            • CREATE VIEW
            • CHECKSUM TABLE
            • CREATE EVENT
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP CATALOG
            • DROP CONCURRENT_LIMITING_RULE
            • DROP DATABASE
            • DROP EVENT
            • DROP INDEX
            • DROP LOCATION
            • DROP MATERIALIZED VIEW
            • DROP MATERIALIZED VIEW LOG
            • DROP OUTLINE
            • DROP ROLE
            • DROP SENSITIVE RULE
            • DROP POLICY
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP TABLESPACE
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • FLUSH TABLE
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOAD_FILE
            • LOAD INDEX INTO CACHE
            • LOCK TABLES
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REPAIR TABLE
            • REMOVE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SET DEFAULT ROLE
            • SELECT
              • SELECT
              • JOIN clause
              • WINDOW clause
              • UNION clause
              • HYBRID_SEARCH
              • PARTITION TIER
            • SET
            • SET CATALOG
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET ROLE
            • SET TRANSACTION
            • SHOW
            • SUBMIT JOB
            • SHOW JOB STATUS
            • CANCEL JOB
            • TRANSACTION
            • TRUNCATE TABLE
            • UNLOCK TABLES
            • UPDATE
            • USE
            • VALUES
            • XA TRANSACTION
          • DDL feature
            • Overview of DDL features
            • Online DDL and Offline DDL Operations
            • Index operations
            • Primary key operations
            • Column operations
            • Generate columns
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
            • Number type conversion rules
          • Pseudo columns
            • Overview of PseudoColumns
            • PARTITIONID Pseudo Column
            • Sequence Pseudocolumns
          • Conditions
            • Overview of SQL Conditions
            • Condition priorities
            • Comparison conditions
            • Logical conditions
            • Pattern matching conditions
            • Null value conditions
            • BETWEEN condition
            • EXISTS condition
            • IN Condition
            • JSON Member Conditions
            • Boolean test conditions
      • SQL specifications and practices
        • SQL Writing Restrictions
        • SQL writing specifications
          • SELECT statement writing specifications
          • DML statement writing guidelines
          • DDL statement writing guidelines
          • Multi-table association guidelines
          • Table scan method specifications
          • Transaction specifications
          • Usage guidelines for cache
          • Guidelines for Using HINTS
          • Other related specifications
        • SQL statement examples
          • Implicit type conversion related
          • Suggestions on using JOIN tables
          • Weak-consistency read
          • Paginated query
      • Reserved keywords
      • Data type conversion behavior in strict mode
    • PL reference
      • What is PL
        • PL Overview
        • Key features of PL
        • Architecture of PL
      • PL syntax structure
      • PL stored procedures
        • Overview of stored programs
        • Variables of stored programs
        • Stored procedure
        • Stored Procedures and Privilege Management
        • Stored functions
        • External storage functions
        • Trigger
        • EVENT
        • Limitations on stored programs
        • SQL Transpiler
        • PL asynchronous commit optimization
      • PL cursors
        • Cursor overview
        • Cursor execution process
        • Limitations on server-side cursors
      • PL conditional control statements
        • CASE
        • IF
        • ITERATE
        • LEAVE
        • LOOP
        • REPEAT
        • RETURN
        • WHILE
      • PL data manipulation statements
        • CALL
        • DO
      • PL data definition statements
        • ALTER FUNCTION
        • ALTER PROCEDURE
        • CREATE FUNCTION
        • CREATE PROCEDURE
        • CREATE TRIGGER
        • DROP FUNCTION
        • DROP PROCEDURE
        • DROP TRIGGER
      • PL database management statements
        • SHOW CREATE FUNCTION
        • SHOW CREATE PROCEDURE
        • SHOW CREATE TRIGGER
        • SHOW FUNCTION STATUS
        • SHOW PROCEDURE STATUS
        • SHOW TRIGGERS
      • PL related dictionary views
        • INFORMATION_SCHEMA PARAMETERS
        • INFORMATION_SCHEMA ROUTINES
        • INFORMATION_SCHEMA TRIGGERS
      • PL exception handling
        • Overview of exception handling
        • DECLARE ... CONDITION
        • DECLARE ... HANDLER
        • GET DIAGNOSTICS
        • RESIGNAL
        • SIGNAL
        • Scope of handlers
        • Diagnostic section
        • Exception Handling and OUT/INOUT Parameters
        • Limitations on exception handling
      • PL system packages
        • Overview of system packages
        • DBMS_AI_SERVICE
          • Overview of DBMS_AI_SERVICE
          • CREATE_AI_MODEL
          • DROP_AI_MODEL
          • CREATE_AI_MODEL_ENDPOINT
          • ALTER_AI_MODEL_ENDPOINT
          • DROP_AI_MODEL_ENDPOINT
          • REGISTER_PROVIDER
          • ALTER_PROVIDER
          • UNREGISTER_PROVIDER
          • ALTER_MODEL_PROFILE
          • DROP_MODEL_PROFILE
          • CREATE_AI_GATEWAY
          • ALTER_AI_GATEWAY
          • DROP_AI_GATEWAY
        • DBMS_ASYNC_INDEX
          • Overview of DBMS_ASYNC_INDEX
          • FORCEMERGE
        • DBMS_DAILY_MAINTENANCE
          • Overview of DBMS_DAILY_MAINTENANCE
          • TRIGGER_WINDOW_COMPACTION_PROC
          • SET_THREAD_COUNT
        • DBMS_HYBRID_SEARCH
          • Overview of DBMS_HYBRID_SEARCH
          • SEARCH
          • GET_SQL
        • DBMS_MVIEW
          • Overview of DBMS_MVIEW
          • PURGE_LOG
          • REFRESH
          • KILL_REFRESH
          • REFRESH_REPORT
        • DBMS_MVIEW_STATS
          • Overview of DBMS_MVIEW_STATS
          • PURGE_REFRESH_STATS
          • SET_MVREF_STATS_PARAMS
          • SET_SYSTEM_DEFAULT
        • DBMS_PARTITION
          • Overview of DBMS_PARTITION
          • MANAGE_DYNAMIC_PARTITION
        • DBMS_RESOURCE_MANAGER
          • Overview of DBMS_RESOURCE_MANAGER
          • CREATE_CONSUMER_GROUP
          • CREATE_PLAN
          • CREATE_PLAN_DIRECTIVE
          • COPY_PLAN
          • DELETE_CONSUMER_GROUP
          • DELETE_PLAN
          • DELETE_PLAN_DIRECTIVE
          • System Packages
          • UPDATE_PLAN_DIRECTIVE
        • DBMS_STATS
          • Overview of DBMS_STATS
          • ALTER_STATS_HISTORY_RETENTION
          • CREATE_STAT_TABLE
          • DELETE_CATALOG_GLOBAL_PREFS
          • DELETE_CATALOG_TABLE_PREFS
          • DELETE_COLUMN_STATS
          • DELETE_INDEX_STATS
          • DELETE_TABLE_STATS
          • DELETE_SCHEMA_STATS
          • DELETE_SCHEMA_PREFS
          • DELETE_SYSTEM_STATS
          • DELETE_TABLE_PREFS
          • DROP_STAT_TABLE
          • EXPORT_COLUMN_STATS
          • EXPORT_INDEX_STATS
          • EXPORT_TABLE_STATS
          • EXPORT_SCHEMA_STATS
          • FLUSH_DATABASE_MONITORING_INFO
          • GATHER_CATALOG_TABLE_STATS
          • GATHER_INDEX_STATS
          • GATHER_TABLE_STATS
          • GATHER_SCHEMA_STATS
          • GATHER_SYSTEM_STATS
          • GET_CATALOG_GLOBAL_PREFS
          • GET_CATALOG_PREFS
          • GET_STATS_HISTORY_AVAILABILITY
          • GET_STATS_HISTORY_RETENTION
          • GET_PARAM
          • GET_PREFS
          • IMPORT_INDEX_STATS
          • IMPORT_COLUMN_STATS
          • IMPORT_TABLE_STATS
          • IMPORT_SCHEMA_STATS
          • LOCK_CATALOG_PARTITION_STAT
          • LOCK_CATALOG_TABLE_STAT
          • LOCK_PARTITION_STATS
          • LOCK_SCHEMA_STATS
          • LOCK_TABLE_STATS
          • RESTORE_TABLE_STATS
          • RESTORE_SCHEMA_STATS
          • RESET_GLOBAL_PREF_DEFAULTS
          • RESET_PARAM_DEFAULTS
          • PURGE_STATS
          • SET_CATALOG_GLOBAL_PREFS
          • SET_CATALOG_TABLE_PREFS
          • SET_COLUMN_STATS
          • SET_INDEX_STATS
          • SET_TABLE_STATS
          • SET_GLOBAL_PREFS
          • SET_PARAM
          • SET_SCHEMA_PREFS
          • SET_SYSTEM_STATS
          • SET_TABLE_PREFS
          • UNLOCK_CATALOG_PARTITION_STAT
          • UNLOCK_CATALOG_TABLE_STAT
          • UNLOCK_PARTITION_STATS
          • UNLOCK_SCHEMA_STATS
          • UNLOCK_TABLE_STATS
          • CANCEL_GATHER_STATS
          • COPY_TABLE_STATS
        • DBMS_TRUSTED_CERTIFICATE_MANAGER
          • Overview of DBMS_TRUSTED_CERTIFICATE_MANAGER
          • ADD_TRUSTED_CERTIFICATE
          • DELETE_TRUSTED_CERTIFICATE
          • UPDATE_TRUSTED_CERTIFICATE
        • DBMS_UDR
          • Overview of DBMS_UDR
          • CREATE_RULE
          • DISABLE_RULE
          • ENABLE_RULE
          • REMOVE_RULE
        • DBMS_VECTOR
          • Overview of DBMS_VECTOR
          • REBUILD_INDEX
          • INDEX_VECTOR_MEMORY_ESTIMATE
          • INDEX_VECTOR_MEMORY_ADVISOR
          • FLUSH_INDEX
          • COMPACT_INDEX
          • TRIGGER_ASYNC_TASK
          • ALTER_INDEX_PARAMS
        • DBMS_WORKLOAD_REPOSITORY
          • Overview of DBMS_WORKLOAD_REPOSITORY
          • ASH_REPORT
          • CREATE_SNAPSHOT
          • DROP_SNAPSHOT_RANGE
          • MODIFY_SNAPSHOT_SETTINGS
        • DBMS_SESSION
          • Overview of DBMS_SESSION
          • SET_IDENTIFIER
          • CLEAR_IDENTIFIER
        • DBMS_APPLICATION_INFO
          • Overview of DBMS_APPLICATION_INFO
          • READ_CLIENT_INFO
          • READ_MODULE
          • SET_ACTION
          • SET_CLIENT_INFO
          • SET_MODULE
        • DBMS_XPLAN
          • Overview of DBMS_XPLAN
          • DISPLAY_ACTIVE_SESSION_PLAN
          • DISPLAY_CURSOR
          • DISPLAY
          • DISABLE_OPT_TRACE
          • DISPLAY_SQL_PLAN_BASELINE
          • ENABLE_OPT_TRACE
          • SET_OPT_TRACE_PARAMETER
        • DBMS_XPROFILE
          • Overview of DBMS_XPROFILE
          • DISPLAY_PROFILE
        • DBMS_BALANCE
          • Overview of DBMS_BALANCE
          • SET_BALANCE_WEIGHT
          • CLEAR_BALANCE_WEIGHT
          • TRIGGER_PARTITION_BALANCE
          • SET_TABLEGROUP_BALANCE_WEIGHT
          • CLEAR_TABLEGROUP_BALANCE_WEIGHT
        • DBMS_OB_LIMIT_CALCULATOR
          • Overview of DBMS_OB_LIMIT_CALCULATOR
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT
        • DBMS_EXTERNAL_TABLE
          • Overview of DBMS_EXTERNAL_TABLE
          • AUTO_REFRESH_EXTERNAL_TABLE
        • DBMS_JAVA
          • Overview of DBMS_JAVA
          • LOADJAVA
          • DROPJAVA
          • GRANT_PERMISSION
          • RESTRICT_PERMISSION
          • REVOKE_PERMISSION
          • DISABLE_PERMISSION
          • ENABLE_PERMISSION
          • DELETE_PERMISSION
        • DBMS_PYTHON
          • Overview of DBMS_PYTHON
          • DROPPYTHON
          • LOADPYTHON
        • DBMS_DATA_DICT
          • DBMS_DATA_DICT
      • Reserved and Non-Reserved PL Keywords
    • System views
      • Overview of system views
      • Overview of system views
      • SYS tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • CDB_INDEX_USAGE
          • oceanbase.CDB_INDEXES
          • CDB_MVIEW_LOGS
          • oceanbase.CDB_MVIEW_RUNNING_JOBS
          • CDB_MVIEWS
          • CDB_MVREF_CHANGE_STATS
          • CDB_MVREF_RUN_STATS
          • CDB_MVREF_STATS
          • CDB_MVREF_STATS_PARAMS
          • CDB_MVREF_STATS_SYS_DEFAULTS
          • CDB_MVREF_STMT_STATS
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.CDB_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.CDB_OB_AI_BATCH_TASKS
          • oceanbase.CDB_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.CDB_OB_AI_GATEWAYS
          • oceanbase.CDB_OB_AI_MODEL_ENDPOINTS
          • oceanbase.CDB_OB_AI_MODEL_PROFILES
          • oceanbase.CDB_OB_AI_MODEL_PROVIDERS
          • oceanbase.CDB_OB_AI_MODELS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • CDB_OB_AUX_STATISTICS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_CCL_RULES
          • oceanbase.CDB_OB_CS_REPLICA_STATS
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_TASKS
          • oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_KV_TTL_TASKS
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.CDB_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.CDB_OB_LOB_CHECK_TASKS
          • oceanbase.CDB_OB_LS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_RECOVER_TABLE_JOBS
          • oceanbase.CDB_OB_SERVICES
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_RSRC_DIRECTIVES
          • oceanbase.CDB_OB_SENSITIVE_COLUMNS
          • oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.CDB_OB_SENSITIVE_RULES
          • oceanbase.CDB_OB_SERVER_SPACE_USAGE
          • oceanbase.CDB_OB_SPACE_USAGE
          • oceanbase.CDB_OB_STORAGE_SPACE_USAGE
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_STORAGE_IO_USAGE
          • oceanbase.CDB_OB_SPM_EVO_RESULT
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_TABLE_SPACE_USAGE
          • oceanbase.CDB_OB_TEMP_FILES
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TTL_TASKS
          • oceanbase.CDB_OB_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_USERS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASKS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS
          • 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_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.CDB_WR_CONTROL
          • oceanbase.CDB_WR_EVENT_NAME
          • oceanbase.CDB_WR_RES_MGR_SYSSTAT
          • oceanbase.CDB_WR_SNAPSHOT
          • oceanbase.CDB_WR_SQL_PLAN
          • oceanbase.CDB_WR_SQLSTAT
          • oceanbase.CDB_WR_SQLTEXT
          • oceanbase.CDB_WR_STATNAME
          • oceanbase.CDB_WR_SYS_TIME_MODEL
          • oceanbase.CDB_WR_SYSSTAT
          • oceanbase.CDB_WR_SYSTEM_EVENT
          • oceanbase.CDB_OB_EXTERNAL_RESOURCES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • 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_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • DBA_OB_TRUSTED_ROOT_CERTIFICATE
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OB_ZONE_STORAGE
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
        • Performance views
          • 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_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_IO_BENCHMARK
          • GV$OB_IO_CALIBRATION_STATUS
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • 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_PLUGINS
          • 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_SERVER_STORAGE
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • 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_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_REPLICA_INFO
          • 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$OB_KV_CLIENT_INFO
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • 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_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_IO_BENCHMARK
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_HNSW_INDEX_INFO
          • V$OB_IO_CALIBRATION_STATUS
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • 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_PLUGINS
          • 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_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SERVERS
          • V$OB_SERVER_STORAGE
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • 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_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_REPLICA_INFO
          • 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$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_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
          • V$OB_VECTOR_MEMORY
      • User tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.audit_log_filter
          • mysql.audit_log_user
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_JAVA_POLICY
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SENSITIVE_COLUMNS
          • oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.DBA_OB_SENSITIVE_RULES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • 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_TABLE_SPACE_USAGE
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RLS_POLICIES
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
          • oceanbase.USER_JAVA_POLICY
        • Performance views
          • 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_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • 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_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_MACRO_CACHE_STAT
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • 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_PLAN_MONITOR
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • 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$ENCRYPTED_TABLESPACES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_HNSW_INDEX_INFO
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • 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_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$RSRC_PLAN
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • 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_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_MACRO_CACHE_STAT
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$OB_VECTOR_MEMORY
          • V$RESTORE_POINT
          • 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_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
      • Overview of Metrics
      • Common wait events
    • Parameters and system variables
      • Overview of parameters and system variables
      • Parameters
        • Parameter overview
        • Cluster-level parameters
          • alert_log_level
          • all_cluster_list
          • all_server_list
          • autoinc_cache_refresh_interval
          • async_ps_cursor_max_count
          • balancer_log_interval
          • balancer_task_timeout
          • system_protected_sys_variables
          • system-protected-tenant-parameters
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_io_isolation_mode
          • clog_sync_time_warn_threshold
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • data_dir
          • data_disk_usage_limit_percentage
          • data_disk_write_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_maxsize
          • datafile_next
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress_func
          • default_row_format
          • devname
          • diag_syslog_per_error_limit
          • disk_io_thread_count
          • dtl_buffer_size
          • enable_asan_for_memory_context
          • enable_async_syslog
          • enable_cgroup
          • enable_dblink
          • enable_ddl
          • enable_global_background_resource_isolation
          • enable_logservice
          • enable_major_freeze
          • enable_ob_error_msg_style
          • enable_ob_ratelimit
          • enable_perf_event
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_rpc_authentication_bypass
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_table_ddl
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • enable_upgrade_mode
          • ext_plugin_config
          • fuse_row_cache_priority
          • global_background_cpu_quota
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • index_block_cache_priority
          • internal_sql_execute_timeout
          • io_scheduler_thread_count
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • local_ip
          • location_cache_cpu_quota
          • location_cache_expire_time
          • location_cache_refresh_min_interval
          • location_cache_refresh_rpc_timeout
          • location_cache_refresh_sql_timeout
          • location_fetch_concurrency
          • location_refresh_thread_count
          • log_disk_percentage
          • log_disk_size
          • logservice_access_point
          • log_storage_warning_trigger_percentage
          • log_storage_warning_tolerance_time
          • ls_meta_table_check_interval
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • micro_block_merge_verify_level
          • migration_disable_time
          • min_observer_version
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • ob_startup_mode
          • ob_python_home
          • obconfig_url
          • observer_id
          • ob_storage_s3_url_encode_type
          • ob_enable_java_env
          • ob_java_home
          • ob_java_connector_path
          • ob_java_opts
          • ob_enable_java_udf_sandbox
          • ob_enable_utl_http
          • opt_tab_stat_cache_priority
          • plan_cache_evict_interval
          • px_task_size
          • plugins_load
          • recyclebin_object_expire_time
          • resource_hard_limit
          • rest_oauth2_credential_refresh_interval
          • rest_oauth2_credential_evict_time
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • rpc_client_authentication_method
          • rpc_port
          • rpc_server_authentication_method
          • rpc_timeout
          • schema_history_expire_time
          • schema_history_recycle_interval
          • server_balance_cpu_mem_tolerance_percent
          • server_balance_critical_disk_waterlevel
          • server_balance_disk_tolerance_percent
          • server_check_interval
          • server_cpu_quota_max
          • server_cpu_quota_min
          • server_permanent_offline_time
          • sql_login_thread_count
          • sql_net_thread_count
          • sql_protocol_min_tls_version
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • standby_fetch_log_bandwidth_limit
          • storage_meta_cache_priority
          • strict_check_os_params
          • sync_io_thread_count
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • sys_ckpt_thread_score
          • syslog_compress_func
          • syslog_disk_size
          • syslog_file_uncompressed_count
          • syslog_io_bandwidth_limit
          • syslog_level
          • system_memory
          • tablet_ls_cache_priority
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • tablet_size
          • tcp_keepcnt
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_task_queue_size
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • unit_gc_wait_time
          • use_large_pages
          • user_block_cache_priority
          • user_row_cache_priority
          • virtual_table_location_cache_expire_time
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • zone
        • Tenant-level parameters
          • agent_db_background_delete_thread_score
          • agent_db_hot_namespace_ttl
          • arbitration_timeout
          • archive_lag_target
          • approx_count_distinct_precision
          • audit_log_buffer_size
          • audit_log_compression
          • attach_shared_sstable_thread_score
          • audit_log_enable
          • audit_log_format
          • audit_log_max_size
          • audit_log_path
          • audit_log_prune_seconds
          • audit_log_query_sql
          • audit_log_rotate_on_size
          • audit_log_strategy
          • audit_sys_operations
          • audit_trail
          • auto_split_tablet_size
          • backup_data_file_size
          • balancer_idle_time
          • catalog_sync_target
          • choose_migration_source_policy
          • compaction_dag_cnt_limit
          • compaction_high_thread_score
          • compaction_low_thread_score
          • compaction_mid_thread_score
          • compaction_schedule_tablet_batch_cnt
          • compatible
          • connection_control_failed_connections_threshold
          • connection_control_max_connection_delay
          • connection_control_min_connection_delay
          • cpu_quota_concurrency
          • ddl_thread_score
          • default_auto_increment_mode
          • default_delta_format
          • default_enable_extended_rowid
          • default_load_mode
          • default_micro_block_format_version
          • default_progressive_merge_num
          • default_skip_index_level
          • default_storage_cache_policy
          • default_table_merge_engine
          • default_table_organization
          • default_table_store_format
          • direct_load_allow_fallback
          • ddl_high_thread_score
          • document_ai_file_max_size
          • dtl_compress_func
          • dump_data_dictionary_to_log_interval
          • enable_agent_db_background_task
          • enable_adaptive_plan_cache
          • enable_auto_split
          • enable_database_sharding_none
          • enable_early_lock_release
          • enable_hbase_rowkey_ttl
          • enable_pl_rich_error_msg
          • enable_gts_standalone
          • enable_kv_group_commit
          • enable_kv_ttl
          • enable_lake_table_parallel_resolving
          • enable_lock_priority
          • enable_manual_storage_cache_policy
          • enable_mlog_auto_maintenance
          • enable_monotonic_weak_read
          • enable_mv_binlog_minimal_mode
          • enable_ls_leader_balance
          • enable_rebalance
          • enable_sql_extension
          • enable_transfer
          • enable_ttl
          • enable_user_defined_rewrite_rules
          • enable_window_compaction
          • enable_ps_parameterize
          • external_kms_info
          • external_table_io_hole_size
          • external_table_io_range_size
          • external_table_csv_max_buffer_size
          • ob_vector_search_strategy
          • freeze_trigger_percentage
          • global_index_auto_split_policy
          • ha_high_thread_score
          • ha_low_thread_score
          • ha_mid_thread_score
          • inc_sstable_upload_thread_score
          • shared_gc_executor_thread_score
          • shared_gc_generator_thread_score
          • json_document_max_depth
          • kv_ttl_duty_duration
          • kv_group_commit_batch_size
          • kv_group_commit_rw_mode
          • kv_hbase_client_scanner_timeout_period
          • kv_ttl_delete_max_ops
          • kv_ttl_history_recycle_interval
          • kv_transport_compress_threshold
          • lake_table_pruning_thread_count
          • load_data_diagnosis_log_compression
          • load_data_diagnosis_log_max_size
          • load_vector_index_on_follower
          • lob_enable_block_cache_threshold
          • log_archive_concurrency
          • log_disk_throttling_maximum_duration
          • log_disk_throttling_percentage
          • log_disk_utilization_limit_threshold
          • log_disk_utilization_threshold
          • log_restore_concurrency
          • log_storage_compress_all
          • log_storage_compress_func
          • log_transport_compress_all
          • log_transport_compress_func
          • ls_gc_delay_time
          • ls_scale_out_factor
          • major_compact_trigger
          • major_freeze_duty_time
          • max_partition_num
          • max_stale_time_for_weak_consistency
          • mds_compaction_high_thread_score
          • mds_compaction_mid_thread_score
          • mds_minor_compact_trigger
          • merger_check_interval
          • minor_compact_trigger
          • mlog_trim_interval
          • model_max_retries
          • model_request_timeout
          • mv_refresh_concurrency
          • ob_compaction_schedule_interval
          • ob_enable_batched_multi_statement
          • ob_encoding_granularity
          • ob_enable_java_udf
          • ob_enable_python_udf
          • ob_proxy_readonly_transaction_routing_policy
          • ob_query_switch_leader_retry_timeout
          • ob_ssl_invited_common_names
          • ob_vector_index_active_segment_max_size
          • ob_vector_index_merge_trigger_percentage
          • ob_vector_memory_limit_percentage
          • open_cursors
          • optimizer_index_cost_adj
          • partition_balance_schedule_interval
          • plsql_code_type
          • plsql_debug
          • px_node_policy
          • package_state_sync_max_size
          • px_target_high_watermark
          • px_target_low_watermark
          • px_target_workers_per_cpu
          • px_workers_per_cpu_quota
          • query_memory_limit_percentage
          • query_response_time_flush
          • query_response_time_range_base
          • query_response_time_stats
          • range_optimizer_max_mem_size
          • recover_table_concurrency
          • recover_table_dop
          • replica_parallel_migration_mode
          • result_cache_max_size
          • result_cache_max_result
          • ob_result_cache_evict_percentage
          • ob_deterministic_udf_cache_max_size
          • rpc_memory_limit_percentage
          • shared_log_retention
          • shared_storage_data_check_thread_score
          • spill_compression_codec
          • sql_func_extension_mode
          • sql_work_area
          • standby_db_fetch_log_rpc_timeout
          • standby_db_preferred_upstream_log_region
          • storage_rowsets_size
          • sts_credential
          • suspend_storage_cache_task
          • kv_transport_compress_func
          • tde_method
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • temporary_file_max_disk_size
          • ttl_duty_time
          • ttl_thread_score
          • undo_retention
          • vector_index_memory_saving_mode
          • vector_index_optimization_concurrency
          • vector_index_optimize_duty_time
          • vector_task_thread_limit_percent
          • workarea_size_policy
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • zone_deploy_mode
      • System variables
        • Overview of system variables
        • Global variables
          • ap_query_cost_threshold
          • ap_query_route_policy
          • ap_query_replica_fallback
          • activate_all_roles_on_login
          • auto_increment_cache_size
          • auto_increment_increment
          • auto_increment_offset
          • autocommit
          • automatic_sp_privileges
          • binlog_row_image
          • block_encryption_mode
          • character_set_client
          • character_set_connection
          • cardinality_estimation_model
          • character_set_database
          • character_set_filesystem
          • character_set_results
          • character_set_server
          • character_set_system
          • collation_connection
          • collation_database
          • collation_server
          • connect_timeout
          • cte_max_recursion_depth
          • cursor_sharing
          • datadir
          • default_authentication_plugin
          • default_password_lifetime
          • default_storage_engine
          • div_precision_increment
          • error_on_overlap_time
          • event_scheduler
          • explicit_defaults_for_timestamp
          • enable_optimizer_rowgoal
          • foreign_key_checks
          • group_concat_max_len
          • init_connect
          • innodb_stats_persistent
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lc_time_names
          • log_row_value_options
          • long_query_time
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • mview_refresh_dop
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • ob_bnl_join_cache_size
          • ob_compatibility_mode
          • ob_compatibility_control
          • ob_compatibility_version
          • ob_default_lob_inrow_threshold
          • ob_early_lock_release
          • ob_enable_ps_parameter_anonymous_block
          • ob_enable_pl_async_commit
          • ob_enable_aggregation_pushdown
          • ob_enable_index_direct_select
          • ob_enable_jit
          • ob_enable_pl_cache
          • ob_enable_plan_cache
          • ob_enable_rich_error_msg
          • ob_enable_sql_audit
          • ob_enable_transformation
          • ob_enable_transmission_checksum
          • ob_enable_truncate_flashback
          • ob_log_level
          • ob_max_read_stale_time
          • ob_pl_block_timeout
          • ob_plan_cache_evict_high_percentage
          • ob_plan_cache_evict_low_percentage
          • ob_plan_cache_percentage
          • ob_query_timeout
          • ob_read_consistency
          • ob_reserved_meta_memory_percentage
          • ob_route_policy
          • ob_sql_audit_percentage
          • ob_sql_work_area_percentage
          • ob_table_access_policy
          • ob_tcp_invited_nodes
          • ob_temp_tablespace_size_percentage
          • ob_trx_idle_timeout
          • ob_trx_lock_timeout
          • ob_trx_timeout
          • optimizer_capture_sql_plan_baselines
          • ob_security_version
          • optimizer_dynamic_sampling
          • optimizer_features_enable
          • optimizer_use_sql_plan_baselines
          • parallel_degree_limit
          • parallel_degree_policy
          • parallel_min_scan_time_threshold
          • parallel_servers_target
          • partition_index_dive_limit
          • performance_schema
          • plugin_dir
          • pid_file
          • query_cache_size
          • plsql_optimize_level
          • plsql_can_transform_sql_to_assign
          • port
          • query_cache_type
          • query_rewrite_enabled
          • query_rewrite_integrity
          • read_only
          • recyclebin
          • regexp_stack_limit
          • regexp_time_limit
          • resource_manager_plan
          • socket
          • range_index_dive_limit
          • runtime_bloom_filter_max_size
          • runtime_filter_max_in_num
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • secure_file_priv
          • server_uuid
          • sql_auto_is_null
          • sql_mode
          • sql_quote_show_create
          • sql_safe_updates
          • sql_select_limit
          • sql_throttle_current_priority
          • sql_throttle_network
          • sql_throttle_priority
          • sql_throttle_rt
          • sql_transpiler
          • sql_warnings
          • system_time_zone
          • time_zone
          • transaction_isolation
          • transaction_read_only
          • tx_isolation
          • tx_read_only
          • validate_password_check_user_name
          • validate_password_length
          • validate_password_mixed_case_count
          • validate_password_number_count
          • validate_password_policy
          • validate_password_special_char_count
          • version
          • version_comment
          • wait_timeout
        • Session variables
          • enable_sql_plan_monitor
          • is_result_accurate
          • identity
          • last_insert_id
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_global_debug_sync
          • ob_hnsw_ef_search
          • ob_ivf_nprobes
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_proxy_global_variables_version
          • ob_sparse_drop_ratio_search
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • partition_index_dive_limit
          • range_index_dive_limit
          • timestamp
          • tracefile_identifier
    • Error codes
      • Overview of error messages
      • 0001 ~ 3999
      • 4000 ~ 4499
      • 4500 ~ 4999
      • 5000 ~ 5999
      • 6000 ~ 6999
      • 7000 ~ 7999
      • 8000 ~ 8999
      • 9000 ~ 9499
      • 9500 ~ 9999
      • 10000 ~ 12000
      • 22998, 30926, 38104, 38105
    • LogService reference
      • LogService commands
        • Overview of LS-CTRL
        • LS-CTRL commands
          • bootstrap
          • show az
          • show ln
          • show meta
          • show ap
          • show parameter
          • show v-table
          • add ln
          • delete ln
          • set param
          • check
          • upgrade
          • fetch
          • migrate replica
          • rotate-ak
          • param-version-status
      • LogService parameters
        • Overview of Log Service parameters
        • Cluster parameters
          • min_oblogservice_version
          • node_permanent_offline_time_sec
          • stream_replica_task_history_retention_sec
          • object_store_url
          • log_local_target_retention_sec
          • retained_remote_log_blocks
          • log_local_disk_utilization_threshold
          • max_syslog_file_count
          • enable_rebalance
          • load_balance_policy
          • rebalance_interval_sec
          • metric_sample_save_interval_sec
          • max_utilization_threshold
          • min_utilization_threshold
          • log_disk_throttling_percentage
          • log_disk_throttling_maximum_duration
          • rebuild_log_lag_threshold
        • Server parameters
          • cluster_id
          • region
          • az
          • local_ip
          • rpc_port
          • log_disk_size
          • io_worker_count
          • http_port
          • status_thread_pool_size
          • stack_size
          • net_thread_count
          • enable_heap_profile
          • log_disk_percentage
          • memory_limit
          • log_level
          • max_syslog_file_size
          • disk_max_iops
          • disk_max_bandwidth
          • upload_block_concurrency
          • log_cache_memory_percentage
          • log_cache_evict_scan_budget
          • log_cache_enable_write
          • log_cache_enable_read
          • log_cache_metrics_dump_interval_sec
          • ln_id
          • local_storage_dir
      • LogService views
        • Overview of LogService views
        • List of LogService views
        • Virtual views
          • node_load
          • az_load
          • stream_replica_io
        • Internal tables
          • t_stream_upload_mapping
          • t_resource_event
    • OBKV
      • OBKV overview
      • OBKV architecture
      • OBKV-Table
        • OBKV-Table overview
          • OBKV-Table overview
          • Core features of OBKV-Table
          • OBKV-Table deployment overview
        • Quick start with simple key-value storage (Java)
        • Use the OBKV-Table client
          • Java development guide for OBKV-Table
          • Prepare for development with OBKV-Table
          • Connect to a cluster by using the OBKV-Table Java client
          • OBKV-Table examples
            • Write data to OBKV-Table
            • Query data in OBKV-Table
            • Update data in OBKV-Table
            • Delete data from OBKV-Table
          • Set parameters for the OBKV-Table Java client
        • OBKV-Table management
          • OBKV-Table management overview
          • High availability of OBKV-Table
          • Security permissions of OBKV-Table
          • OBKV-Table monitoring metrics
        • OBKV-Table reference
          • Data model of OBKV-Table
          • OBKV-Table operations
          • Data types supported by OBKV-Table
          • Full-text indexes in OBKV-Table
          • Scope of use and examples of global indexes in OBKV-Table
          • Delete expired data from OBKV-Table
          • Group commit in OBKV-Table
          • Weak-consistency reads and near reads in OBKV-Table
          • OBKV-Table related views
        • OBKV-Table FAQ
      • OBKV-HBase
        • Overview of OBKV-HBase
        • Core features of OBKV-HBase
        • OBKV-HBase deployment
        • OBKV-HBase development
          • Overview of OBKV-HBase application development
          • Connect to a cluster by using the OBKV-HBase Java client
          • Migrate HBase business code to OBKV-HBase
          • Data operation examples
        • OBKV-HBase migration guide
        • OBKV-HBase management
          • Overview of OBKV-HBase management
          • High availability of OBKV-HBase
          • Security and permissions in OBKV-HBase
          • OBKV-HBase monitoring metrics
        • Query optimization in OBKV-HBase
        • Performance testing of OBKV-HBase
        • OBKV-HBase reference
          • OBKV-HBase data model
          • OBKV-HBase data model
          • HBase-compatible interfaces
          • HBase-compatible filters
          • Automatic partition splitting in OBKV-HBase
          • Delete expired data in OBKV-HBase
          • OBKV-HBase weak-consistency reads and near reads
          • OBKV-HBase views
        • OBKV-HBase integrations
          • Flink integration
            • Synchronize data to OBKV-HBase by using the Flink connector
            • Access OBKV-HBase by using native Flink
          • Access OBKV-HBase by using Hive
          • Access OBKV-HBase by using Spark
    • Performance tuning
      • Overview
      • Performance related tools
        • System tools
          • Top general purpose tool
          • CPU tools
          • Memory tools
          • Disk I/O tools
          • Network tools
        • Internal tables
          • GV$SYSSTAT
          • GV$OB_SQL_AUDIT
          • GV$OB_TRANSACTION_PARTICIPANTS
        • Logs
          • slow trans
          • tenant dump info
          • trace log
        • OCP
      • System tuning
        • Operating system parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU-related parameters
          • Network transmission parameters
          • Node routing parameters
      • Performance diagnosis
        • Monitor and diagnose cluster performance
        • Diagnose tenant performance
        • Monitor OBProxy performance
        • Monitor host performance
        • WR management
          • Overview of WR
          • Manage WR
          • Monitor historical session performance
          • Clean up WR data
        • Diagnostic practice: Use TRACE_ID to diagnose materialized view refresh performance issues
        • ASH report
          • Introduction to ASH
          • Generate an ASH report
          • Analyze an ASH report
          • ASH best practices
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
      • SQL tuning
        • SQL request execution process
        • SQL execution plans
          • Introduction to SQL execution plans
          • Execution plan operators
            • TABLE SCAN
            • JOIN
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • EXCHANGE
            • GI
          • Plan cache
          • Fast parameterization
          • Real-time execution plan display
          • SQL optimization practice with EXPLAIN
        • Distributed execution plans
          • Distributed execution and parallel query
          • Distributed plan generation
          • Distributed execution plan scheduling
          • Distributed execution plan management
          • Parallel execution enabling methods and their priority
          • Auto DOP
          • Execution of parallel queries
          • Perform parameter tuning for a parallel query
          • Parallel DML
          • Parallel DDL
        • Parallel execution plans
          • Introduction to parallel execution
          • Classification and optimization of parallel execution
          • Set concurrent execution
            • Concurrency control and queuing
            • Set the degree of parallelism for parallel execution
            • Set parallel execution parameters
          • Diagnose parallel execution issues
          • Tips for parallel execution tuning
          • Quick start of parallel execution
        • SQL tuning
          • Overview of SQL tuning
          • Basic SQL tuning process
          • SQL execution performance monitoring
            • GV$OB_SQL_AUDIT
            • SQL Trace
            • Plan cache views
            • SQL performance analysis example
              • Analyze wait events in queries by using SQL Audit
              • Analyze SQL queries that cause an abrupt RT jitter
              • View and analyze the shape of an execution plan
              • Analyze slow SQL queries
              • Query SQL traffic distribution and QPS
              • Check whether SQL queries are balanced across servers in a cluster
              • Find the TOP N SQL queries
              • Analyze whether an unusually large number of remote execution requests exist in the system or the execution of an SQL statement
              • Find full table scan SQL statements in a tenant
              • Find the TOP N queries with the longest execution time within a certain period
              • Analyze queries related to distributed plans
              • Check whether the RPC execution count of a distributed subplan is balanced across servers in a cluster
          • Optimizer statistics
            • Overview of statistics
            • Statistics collection methods
              • Overview of statistics collection methods
              • Introduction to histograms
              • Collect statistics manually
              • Automatic statistics collection
              • Online statistics collection
              • Dynamic sampling by the optimizer
            • Statistics management
              • Overview of statistics management
              • Delete statistics
              • Set statistics
              • Import and export statistics
              • Lock and unlock statistics
              • Manage statistics history
              • Manage statistics collection strategies (Prefs)
            • Partitioned table statistics collection and update strategy
            • Monitoring and diagnostics for statistics collection
            • Comprehensive example
          • Query rewrite
            • Overview
            • Rule-based query rewriting
            • Cost-based query rewriting
          • Query optimization
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
            • Join algorithm
              • Overview
              • Join algorithms
              • Runtime filter
              • Join order
          • Manage execution plans
            • Optimizer hint
            • Plan binding
            • Execution plan management
        • Related terms
        • FAQ on SQL tuning
    • Database proxy
      • Database connection and routing overview
      • OceanBase Database Proxy (ODP)
      • ODP
        • ODP management overview
        • Manage ODP clusters
          • Create an OBProxy cluster
          • Manage parameters of an OBProxy cluster
          • Delete an OBProxy cluster
          • Upgrade all OBProxies in an OBProxy cluster
          • Restart all OBProxies in an OBProxy cluster
          • Manage OceanBase AI Database clusters connected to OBProxy
          • Monitor the performance of an OBProxy cluster
        • Manage ODP
          • Add an OBProxy
          • Start OBProxy
          • Refresh OBProxy configuration
          • Stop OBProxy
          • Restart OBProxy
          • Delete an OBProxy
          • Upgrade OBProxy
        • OBProxy parameters
      • Physical connections
      • Logical connection
        • Query all sessions
        • Query the details of a session
        • Query the statistics of a session
        • Query session variables
        • Terminate a server session
      • Route management
        • Table-based routing of ODP
        • LDC-based routing
        • ODP routing policy
          • Read/write splitting
          • Follower-first read
          • Blocklist mechanism
          • Transaction routing
      • View tenant sessions
      • Terminate a tenant session
      • Set the maximum number of connections for a tenant
    • Drivers
      • OceanBase Call Interface (OBCI)
      • OceanBase Connector/J
      • OceanBase Connector/C
      • OceanBase Connector/ODBC
    • Platforms
      • OceanBase Migration Assessment (OMA)
      • OceanBase Migration Service (OMS)
      • OceanBase Cloud Platform (OCP)
      • OceanBase Developer Center (ODC)
      • OceanBase Admin Toolkit (OAT)
    • Components & tools
      • ob_error
      • Data integration
        • obloader/obdumper
        • OceanBase Binlog Service
        • obcdc
          • Overview of obcdc
          • obcdc parameters
            • Sample configuration file
            • Common obcdc parameters
            • obcdc parameters
          • obcdc development instructions
          • obcdc_tailf
          • Throttling
          • obcdc allowlist and blocklist
          • obcdc supports incremental direct load
          • obcdc supports synchronizing from a standby database
          • Data dictionary support in obcdc
          • FAQ
    • OceanBase AI Database plugins
      • Overview of OceanBase AI Database plugins
      • Tokenizer plugin
      • MySQL external table plugin
  • Release Notes
    • Version number guidelines
    • OceanBase AI Database V4.6.3
    • OceanBase AI Database V4.6.2

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase AI Database
  3. V4.6.3

Overview of system views

Last Updated:2026-11-19 02:51:02

Overview of views in the sys tenant
Overview of dictionary views
Performance view overview
User Tenant View Overview
Dictionary View Overview
Performance view overview

Overview of views in the sys tenant

Overview of dictionary views

AI models

View name
Feature description
oceanbase.CDB_OB_AI_BATCH_TASK_HISTORY Displays the history of completed or failed AI batch tasks for all tenants.
oceanbase.CDB_OB_AI_BATCH_TASKS Displays all current AI batch tasks for all tenants.
oceanbase.CDB_OB_AI_GATEWAY_ENDPOINTS Displays the endpoint details of all tenants.
oceanbase.CDB_OB_AI_GATEWAYS Displays the AI gateway configuration information for all tenants.
oceanbase.CDB_OB_AI_MODEL_ENDPOINTS Displays the AI model endpoints of all tenants.
oceanbase.CDB_OB_AI_MODEL_PROFILES Displays the AI model parameter configuration information for all tenants.
oceanbase.CDB_OB_AI_MODEL_PROVIDERS Displays the AI vendor configuration information for all tenants.
oceanbase.CDB_OB_AI_MODELS Displays the AI model information for all tenants.
oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY Displays the history of completed or failed AI batch tasks for the current tenant.
oceanbase.DBA_OB_AI_BATCH_TASKS Displays the ongoing AI batch tasks for the current tenant.
oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS Displays the endpoint details of the current tenant's AI gateway.
oceanbase.DBA_OB_AI_GATEWAYS Displays the AI gateway configuration information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_ENDPOINTS Displays the AI model endpoint information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_PROFILES Displays the AI model parameter configuration information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_PROVIDERS Displays the AI vendor configuration information of the current tenant.
oceanbase.DBA_OB_AI_MODELS Displays the AI model information of the current tenant.

Logical tables

View name
Feature description
oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS Displays all background delete tasks for logical tables being executed by tenants.
oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS Displays the background deletion tasks of logical tables currently being executed by the current tenant.
oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY Displays the history of all completed background logical table deletion tasks for tenants.
oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY Displays the history of completed background deletion tasks for logical tables in the current tenant.

Security permissions

View name
Feature description
oceanbase.CDB_OB_USERS Display the user information of all tenants.
oceanbase.CDB_OB_DATABASE_PRIVILEGE Displays the database-level privileges of all tenants.
oceanbase.DBA_OB_AUTO_INCREMENT Displays the auto-increment column information for the current tenant.
oceanbase.DBA_OB_USERS Displays the user information of the current tenant.
oceanbase.DBA_OB_DATABASE_PRIVILEGE Displays the database-level privilege information of the current tenant.
oceanbase.DBA_OB_USER_DEFINED_RULES Displays user-defined rule information.

Backup and recovery

View name
Feature description
oceanbase.CDB_OB_RESTORE_PROGRESS Displays the current execution progress of a physical restore task.
oceanbase.CDB_OB_RESTORE_HISTORY Indicates the status when a physical restore task is completed.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES Displays the status of pieces in a backup set.
oceanbase.CDB_OB_BACKUP_SET_FILES Displays the file status of the backup set.
oceanbase.CDB_OB_BACKUP_JOBS Displays the backup job tasks for all tenants in the cluster. Each time a user initiates a backup task, a corresponding job record is created.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY Displays the historical records of backup job tasks for all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS Displays the task-level backup tasks for all tenants in the cluster. Each task record corresponds to a backup set. There is a one-to-one correspondence between task records and job records.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY Displays the historical records of task-level backup tasks for all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS Displays the backup job tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY Displays the historical records of the tenant's own task-level backup tasks.
oceanbase.DBA_OB_BACKUP_SET_FILES Displays the file status of the backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY Displays completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST Displays the archive path configuration.
oceanbase.CDB_OB_ARCHIVE_DEST Displays the archive path configuration.
oceanbase.CDB_OB_BACKUP_PARAMETER Displays backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY Displays the historical information of backup cleanup tasks executed under a tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS Displays information about the backup_set or backup_piece cleanup tasks being executed under a tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY Displays the cleanup strategies set for expired cleanup and automatic cleanup under a tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO Displays the backup destination information used for backup and restore operations in a tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY Displays the historical information of backup destinations used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO Displays the backup destination information used for backup and restore operations in a tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY Displays the historical information of backup destinations used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY Displays the cleanup strategies set for expired cleanup and automatic cleanup under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY Displays the historical information of backup cleanup tasks executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS Displays information about the backup_set or backup_piece cleanup tasks being executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant.
oceanbase.DBA_OB_ARCHIVELOG Displays the log backup status for each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY Displays the status of all historical and current log backups.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES Displays the status of pieces in a backup set.
oceanbase.CDB_OB_ARCHIVELOG Displays the log archiving status for each path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY Displays the status of all historical and current log archivals.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS Displays information about table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS Displays information about table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS Displays information related to the import task.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS Displays information related to the import task.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS Displays records of cross-tenant import tasks at the table level.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS Displays records for table-level import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY Displays the results of a table-level restore task.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY Displays the results of a table-level restore task.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY Displays the result of the import task.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY Displays the result of the import task.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY Displays the historical records of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY Displays the historical records of table-level cross-tenant import tasks.

Tables and columns

View name
Feature description
oceanbase.CDB_IND_COLUMNS Displays the column information of index tables for all tenants.
oceanbase.CDB_INDEXES Displays the index information for all tenants.
oceanbase.CDB_TABLES Displays the TABLE information for all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES The system tenant displays the TABLEGROUP and TABLE relationships for all tenants. TABLES that are not part of a TABLEGROUP are not displayed.
oceanbase.CDB_TAB_COLS Displays the column information for tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$ Displays the column information for tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS Displays the columns contained in the partitioning key for all partition objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS View the columns contained in the subpartitioning key for all partition objects in the database.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO Displays column validation and inconsistency information between index tables (including global indexes and local indexes) and the primary table.
oceanbase.CDB_OB_TABLE_LOCATIONS Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
oceanbase.DBA_OB_TABLE_LOCATIONS Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
information_schema.TABLESPACES Information related to tablespaces.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

oceanbase.DBA_TABLES Displays information about all tables in the current tenant.
oceanbase.CDB_INDEX_USAGE Displays the index usage statistics for all tenants.
oceanbase.DBA_INDEX_USAGE Displays the index usage statistics for the current tenant.
oceanbase.DBA_TAB_COLS_V$ Displays the column information of table and view objects for the current tenant.
oceanbase.CDB_OB_TABLE_SPACE_USAGE Displays the space usage of each table for the current tenant.

Catalog

View name
Feature description
oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS This API is used to query partition-level statistics of external catalog external tables.
oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS This API is used to query column-level statistics of external tables in a catalog.
oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS This API is used to query table-level statistics of external tables in a catalog.

CCL

View name
Feature description
oceanbase.CDB_OB_CCL_RULES Displays the concurrency control and throttling rules for all tenants.
oceanbase.DBA_OB_CCL_RULES Displays the concurrency control and throttling rules for the current tenant.

Storage space

View name
Feature description
oceanbase.CDB_OB_SPACE_USAGE Displays the space usage of all tenants.
oceanbase.CDB_OB_SERVER_SPACE_USAGE Displays the space usage of all OBServer nodes.
oceanbase.CDB_OB_TABLE_SPACE_USAGE Displays the space usage of each table for all tenants.

Access control

View name
Feature description
oceanbase.CDB_OB_ACCESS_POINT Displays the access endpoint information for all tenants.
oceanbase.DBA_OB_ACCESS_POINT Displays the access endpoint information of the current tenant.

Partitions

View name
Feature description
oceanbase.CDB_IND_PARTITIONS Displays the partition information of all tenant index tables.
oceanbase.CDB_IND_SUBPARTITIONS View information about all index subpartitions in a database.
oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES Displays the dynamic partitioned table information for all tenants.
oceanbase.CDB_PART_INDEXES Displays the partition information of index tables for all tenants.
oceanbase.CDB_PART_TABLES Displays the partition information of partitioned tables for all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES Displays the subpartition information of the partitioned tables for all tenants.
oceanbase.CDB_TAB_PARTITIONS Displays the partition information of all tenant's partitioned tables.
oceanbase.CDB_TAB_SUBPARTITIONS Displays the subpartition information of partitioned tables for all tenants.
oceanbase.DBA_IND_PARTITIONS Displays the partition information of the index.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES Displays the dynamic partitioned table information for the current tenant.
oceanbase.DBA_PART_INDEXES Displays the partition information for all partitioned indexes.
oceanbase.DBA_PART_TABLES Displays partition information of a user table.
oceanbase.DBA_TAB_PARTITIONS Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to.
oceanbase.DBA_TAB_SUBPARTITIONS It displays the subpartition name, the table and partition names, their storage attributes, and DBMS_STATS The package generates statistics.
oceanbase.DBA_SUBPARTITION_TEMPLATES Displays the description of all subpartition templates.

Load balancing

View name
Feature description
oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT Displays all partitions with special weights under all user tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS Displays the partition transfer tasks currently in progress for all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY Displays the history of all partition transfer tasks executed by tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS Displays the current partition transfer tasks being processed under this tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY Displays the history of transfer partition tasks executed for this tenant.
oceanbase.CDB_OB_BALANCE_JOBS Displays the load balancing job tasks for all tenants.
oceanbase.CDB_OB_BALANCE_JOB_HISTORY Displays the historical records of load balancing job tasks for all tenants.
oceanbase.CDB_OB_BALANCE_TASKS Displays the load balancing tasks for all tenants.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY Displays the CLB task history for all tenants.
oceanbase.CDB_OB_TRANSFER_TASKS Displays the transfer task information for all tenants.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY Displays the transfer task history for all tenants.
oceanbase.DBA_OB_BALANCE_JOBS Displays the load balancing job tasks of the current tenant.
oceanbase.DBA_OB_BALANCE_JOB_HISTORY Displays the historical records of load balancing job tasks for the current tenant.
oceanbase.DBA_OB_BALANCE_TASKS Displays the load balancing tasks of the current tenant.
oceanbase.DBA_OB_BALANCE_TASK_HISTORY Displays the historical records of load balancing tasks for the current tenant.
oceanbase.DBA_OB_TRANSFER_TASKS Displays the transfer task information of the current tenant.
oceanbase.DBA_OB_TRANSFER_TASK_HISTORY Displays the transfer task history of the current tenant.

Replica logs

View name
Feature description
oceanbase.CDB_OB_CS_REPLICA_STATS Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node for all tenants.
oceanbase.CDB_OB_LS_LOCATIONS Displays the replica distribution information of log stream (LS) for all tenants.
oceanbase.CDB_OB_TABLEGROUPS The system tenant displays the meta information of table groups for all tenants, primarily showing the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS The system tenant displays the partition information of all tenant's partitioned table groups.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS The system tenant displays the subpartition information for all tenant's partitioned table groups.
oceanbase.CDB_OB_TABLET_TO_LS The system tenant displays the tablet list for all tenants and the log stream information to which each tablet belongs.
oceanbase.CDB_OB_TABLET_REPLICAS This view displays information for all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key: <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>.
oceanbase.CDB_PART_KEY_COLUMNS Displays the partitioning key information of all tenants' partition objects (partitioned tables and partitioned indexes).
oceanbase.CDB_SUBPART_KEY_COLUMNS Displays the subpartitioning key information for all tenant's partition objects (partitioned tables and partitioned indexes).
oceanbase.DBA_IND_SUBPARTITIONS Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS Displays the partition information of a table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS Displays the subpartition information for a table group that is partitioned.
oceanbase.DBA_OB_TABLEGROUPS Displays the meta information of a table group, mainly its partition information.
oceanbase.DBA_OB_TABLET_REPLICAS This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>.
oceanbase.DBA_OB_TABLET_TO_LS Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS Displays the replica distribution information of log stream (LS) for the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO Displays information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS Displays the status and recovery progress of the log stream.
oceanbase.DBA_OB_LS Displays the status and recovery progress of the log stream.
oceanbase.CDB_OB_LS_HISTORY Displays the log stream history information for all tenants.
oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS Displays the log stream archiving progress for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASKS Displays the log stream replication tasks for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY Displays the task history of log stream replication for all tenants.
oceanbase.CDB_OB_LOG_RESTORE_SOURCE Displays the log restore source information for all tenants.
oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN Displays the flashback log SCN information for all tenants.
oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG Displays the data dictionary information in all tenant logs.
oceanbase.DBA_OB_LS_HISTORY Displays the historical information of the current tenant's log streams.
oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS Displays the log stream archiving progress for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASKS Displays the log stream replication tasks for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY Displays the historical task records of log stream replication for the current tenant.
oceanbase.DBA_OB_LOG_RESTORE_SOURCE Displays the log restore source information for the current tenant.
oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN Displays the flashback log SCN information for the current tenant.
oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG Displays the data dictionary information in the current tenant's logs.
oceanbase.ALL_LOCATIONS Displays the location information of tables or partitions that the current user can access.

Service management

View name
Feature description
oceanbase.CDB_OB_SERVICES Displays the service information of all tenants.
oceanbase.DBA_OB_SERVICES Displays the service information of the current tenant.
oceanbase.DBA_OB_SERVER_JOBS Displays tasks related to all OBServer nodes.
oceanbase.DBA_OB_SERVERS Displays information about all OBServer nodes.

Shared storage related

View name
Feature description
CDB_OB_STORAGE_SPACE_USAGE Records the storage space usage of each tenant's object storage.
DBA_OB_STORAGE_SPACE_USAGE Records the storage space usage of the current tenant's object storage.
CDB_OB_SHARED_MACRO_BLOCK_GC_STAT Displays the number of shared data GC-deleted macroblocks per tenant per day, categorized by storage type.
DBA_OB_SHARED_MACRO_BLOCK_GC_STAT Displays the number of shared data GC-deleted macroblocks per day for each storage type in the current tenant.
DBA_OB_ZONE_STORAGE Displays the object storage information of shared storage clusters configured in each zone.

InnoDB storage engine related

View name
Feature description
information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP This view displays the mapping information between NDB transactions, the NDB transaction coordinator, and MySQL servers attached to the NDB cluster as API nodes.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_TRX This view displays information about active transactions.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_LOCK_WAITS This view displays information about the lock transactions and lock objects that are waiting when a lock conflict occurs.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_LOCKS This view displays information about all locks currently held or waiting to be acquired.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_BUFFER_PAGE This view displays information about all cached pages in the buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_BUFFER_PAGE_LRU Displays the LRU sorted information of pages in the InnoDB buffer pool.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_BUFFER_POOL_STATS This view displays statistics of the InnoDB buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMP Displays and compresses the status information related to InnoDB tables.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMP_PER_INDEX Displays information related to operations on InnoDB tables and indexes.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMP_PER_INDEX_RESET This view displays and resets the time information for InnoDB table and index-related operations, including display and compression.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

information_schema.INNODB_CMP_RESET Displays the status of operations related to compressing an InnoDB table.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMPMEM This view displays the status of compressed pages in the InnoDB buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMPMEM_RESET Displays the reset time of compressed pages in the InnoDB buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_DATAFILES Displays the data file path information for the InnoDB files of each table and general tablespace.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_INDEXES Displays InnoDB index metadata information.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_TABLES Displays the metadata information of an InnoDB table.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_TABLESPACES Displays the metadata of InnoDB table files and general tablespaces.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; it can only be used to query the table structure.

information_schema.INNODB_SYS_TABLESTATS Displays low-level status information of an InnoDB table.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_VIRTUAL Displays the metadata of virtually generated columns in InnoDB tables.

Note

This view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_TEMP_TABLE_INFO Displays information about InnoDB temporary tables created by active users.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_METRICS Displays InnoDB performance information.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

Temporary files

View name
Feature description
oceanbase.CDB_OB_TEMP_FILES Displays the temporary file information for all tenants.
oceanbase.DBA_OB_TEMP_FILES Displays temporary file information.

I/O Performance Related

View name
Feature description
CDB_OB_STORAGE_IO_USAGE Displays the I/O operation statistics of all tenant object storage and cloud disks.

OBKV-related

View name
Feature description
oceanbase.CDB_OB_KV_TTL_TASKS This API is used to query all tenants for the number of running TTL tasks.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY This API is used to query the historical TTL tasks of all tenants under the system tenant.
oceanbase.DBA_OB_KV_TTL_TASKS Displays the TTL tasks currently being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY Displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO Displays the configuration parameter information for all OBKV tenant client connections on the current node.
GV$OB_KV_CLIENT_INFO Displays the configuration parameter information for all client connections of the OBKV tenant.
oceanbase.CDB_OB_KV_REDIS_TABLE Displays the OBKV Redis table information for all tenants.
oceanbase.DBA_OB_KV_REDIS_TABLE Displays the OBKV Redis table information of the current tenant.

Outline related

View name
Feature description
oceanbase.DBA_OB_OUTLINES Displays the execution plan outline information for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL Displays the throttling rule outline information for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY Displays the execution plan and throttling rule outline historical information for this tenant.
DBA_OB_FORMAT_OUTLINES Records the details of the current tenant's format outline.

Full-text indexes

View name
Feature description
information_schema.INNODB_FT_BEING_DELETED Displays information about full-text indexes being dropped.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_FT_CONFIG Displays the configuration information of the InnoDB full-text search engine.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_FT_DELETED Displays information about full-text indexes that have been marked for deletion.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_FT_INDEX_CACHE This view displays the cache status information of InnoDB full-text indexes.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_FIELDS This view displays the metadata of key columns (fields) in an InnoDB index, which is equivalent to the information in the SYS_FIELDS table in the InnoDB data dictionary.

Note

This view is provided only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

Task Scheduling Manager

View name
Feature description
oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS Displays the running details of scheduled jobs for all tenants.
oceanbase.DBA_SCHEDULER_WINDOWS Displays the scheduling window information.
oceanbase.DBA_SCHEDULER_JOB_CLASSES Displays information about the scheduled job.

Event history monitoring related

View name
Feature description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY Displays the history of deadlock events. This view shows the history of all tenants under the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY Displays the event history of an OBServer node.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY Displays the event history of the root service.

SPM-related

View name
Feature description
oceanbase.CDB_OB_SPM_EVO_RESULT Displays the evolution results of SQL plan management for all tenants.
oceanbase.DBA_OB_SPM_EVO_RESULT Displays the evolution results of SQL plan management for the current tenant.

Upgrade related

View name
Feature description
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY Displays the historical event information of a cluster.

Basic database information

View name
Feature description
oceanbase.CDB_OB_DATABASES The system tenant displays the database metadata of all tenants.
oceanbase.DBA_OB_DATABASES Displays the database metadata of a tenant.
information_schema.events Records all event information.
oceanbase.CDB_OB_AUTO_INCREMENT Displays the auto-increment column information for all tenants.

| oceanbase.DBA_OB_TENANT_EVENT_HISTORY | Displays the event history of a tenant. | | oceanbase.DBA_OB_SYS_VARIABLES | Displays the system variable information of the current tenant. |

Statistics and histograms

View name
Feature description
oceanbase.DBA_TAB_STATISTICS Displays the optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS Displays the column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS Displays the column statistics and histogram information for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS Displays the column statistics and histogram information for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS Displays histograms for all columns in the database.
oceanbase.DBA_PART_HISTOGRAMS Displays the histogram data (the endpoints of each histogram) for all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY Displays the historical table statistics for all tables in the database.
oceanbase.DBA_IND_STATISTICS Displays the optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS Displays the cumulative modification information of tables in the database.
oceanbase.CDB_TAB_COL_STATISTICS Column-level statistics are displayed under the sys tenant.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY Query the historical collection execution of a table.
CDB_OB_AUX_STATISTICS Displays auxiliary statistics for all tenants.
DBA_OB_AUX_STATISTICS Displays the auxiliary statistics of the current tenant.
oceanbase.DBA_OB_TABLE_STAT_STALE_INFO Displays the expiration status of statistics.
oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY Displays the history of table statistics collection tasks.

External resources

View name
Feature description
oceanbase.CDB_OB_EXTERNAL_RESOURCES Displays all uploaded resource files.
oceanbase.CDB_OB_EXTERNAL_TABLE_FILES Displays the file list of external tables created by all tenants.
oceanbase.DBA_OB_EXTERNAL_RESOURCES Displays the uploaded resource files.
oceanbase.DBA_OB_EXTERNAL_TABLE_FILES Displays the file list corresponding to all external tables created under the current tenant.
oceanbase.ALL_OB_EXTERNAL_TABLE_FILES Displays a list of files for external tables to which the current user has access.

Foreign key related

View name
Feature description
information_schema.INNODB_SYS_FOREIGN Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_FOREIGN_COLS This view displays information about the status of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

Materialized view related

View name
Feature description
oceanbase.CDB_MVIEW_RUNNING_JOBS This API is used to display all current materialized view-related tasks of all tenants, including refresh tasks and MLOG cleanup tasks.
oceanbase.CDB_MVIEWS This API is used to display the materialized view information of all tenants.
oceanbase.CDB_MVIEW_LOGS This API is used to display the materialized view log information of all tenants.
CDB_MVREF_CHANGE_STATS This view displays statistics related to materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_RUN_STATS This view displays information about each refresh operation of materialized views for all tenants.
oceanbase.CDB_MVREF_STATS This view displays basic timing statistics for materialized view refreshes across all tenants.
CDB_MVREF_STATS_PARAMS This view displays the refresh statistics for each materialized view associated with all tenants.
CDB_MVREF_STATS_SYS_DEFAULTS Displays the system-wide default values for all tenants' materialized view refresh history statistics.
CDB_MVREF_STMT_STATS This view displays information related to all tenant materialized view refresh statements.
oceanbase.DBA_MVIEW_DEPS Displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS Displays the log information of materialized views.
oceanbase.DBA_MVIEW_RUNNING_JOBS Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS Displays information about all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS This view displays statistics related to materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS It displays information about each refresh operation of a materialized view, with each operation identified by a REFRESH_ID.
oceanbase.DBA_MVREF_STATS This view displays basic timing statistics for materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS Displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS The system-wide default value for the historical statistics refresh attribute of materialized views.
oceanbase.DBA_MVREF_STMT_STATS Describes the information associated with the refresh statement.

WR-related

View name
Feature description
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY Displays the persisted ASH data for all tenants.
oceanbase.CDB_WR_CONTROL Displays the configuration information related to write requests.
oceanbase.CDB_WR_EVENT_NAME Displays the names of persistent tenant-level wait events for all tenants.
oceanbase.CDB_WR_SNAPSHOT Display all tenants' SNAPSHOT information.
oceanbase.CDB_WR_SQLSTAT This view displays the basic performance statistics of all SQL statements executed by tenants. Each SQL statement is represented as a row in the table. SQL_ID + Plan_Hash (The unique value of is one row.)
oceanbase.CDB_WR_SQLTEXT Displays the SQL text collected for write operations of all tenants.
oceanbase.CDB_WR_STATNAME Displays the names of system statistics for all tenants.
oceanbase.CDB_WR_SYS_TIME_MODEL This API is used to display the write data of all tenants' time model statistics.
oceanbase.CDB_WR_SYSSTAT Displays detailed system statistics for all tenants.
oceanbase.CDB_WR_SYSTEM_EVENT This API is used to display the persistent tenant-level wait event information for all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY Displays the persisted ASH data for this tenant.
oceanbase.DBA_WR_CONTROL Displays the configuration information related to write requests.
oceanbase.DBA_WR_EVENT_NAME Displays the names of persistent tenant-level wait events for the current tenant.
oceanbase.DBA_WR_SNAPSHOT Display the of this tenant. SNAPSHOT Information.
oceanbase.DBA_WR_SQLSTAT This view displays the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table. SQL_ID + Plan_Hash The unique value of is one row).
oceanbase.DBA_WR_SQLTEXT Displays the SQL text collected for write operations of the current tenant.
oceanbase.DBA_WR_STATNAME Displays the names of system statistics for the current tenant.
oceanbase.DBA_WR_SYS_TIME_MODEL Displays the write data of time model statistics for the current tenant.
oceanbase.DBA_WR_SYSSTAT Displays the detailed system statistics of the current tenant.
oceanbase.DBA_WR_SYSTEM_EVENT Displays the persistent tenant-level wait event information for the current tenant.
oceanbase.CDB_WR_SQL_PLAN Displays the SQL execution plan information collected for write operations of all tenants.
oceanbase.CDB_WR_RES_MGR_SYSSTAT Displays the resource manager statistics collected for write operations of all tenants.
oceanbase.DBA_WR_SQL_PLAN Displays the SQL execution plan information collected for write operations of the current tenant.
oceanbase.DBA_WR_RES_MGR_SYSSTAT Displays the resource manager statistics collected for write requests of the current tenant.

Vector index related

View name
Feature description
oceanbase.CDB_OB_VECTOR_INDEX_TASKS Displays the vector index task information for all tenants.
oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY Displays the vector index task history for all tenants.
oceanbase.DBA_OB_VECTOR_INDEX_TASKS Displays the vector index task information of the current tenant.
oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY Displays the historical information of vector index tasks for the current tenant.

Minor compaction and major compaction

View name
Feature description
oceanbase.CDB_OB_MAJOR_COMPACTION The system tenant displays the global major compaction information for all tenants.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION The system tenant displays the major compaction information for each zone of all tenants.
oceanbase.DBA_OB_MAJOR_COMPACTION Displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION Displays the major compaction information for each zone in the tenant.
oceanbase.CDB_OB_FREEZE_INFO Displays the version information generated during a major freeze.
oceanbase.DBA_OB_FREEZE_INFO Displays the version information generated during a major freeze.

Certificate Management

View name
Feature description
DBA_OB_TRUSTED_ROOT_CERTIFICATE Displays information about trusted root certificates.

Resource management

View name
Feature description
oceanbase.DBA_OB_RESOURCE_POOLS Displays the resource pool information for all tenants.
oceanbase.DBA_OB_UNIT_JOBS Displays all unit-related tasks.
oceanbase.DBA_OB_UNITS Displays the unit information for all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS Displays the unit specifications of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS Displays all sequences in the database.
CDB_OB_RSRC_DIRECTIVES Displays the resource configuration parameters of all tenants in the Resource Manager.

Tenant management

View name
Feature description
oceanbase.DBA_OBJECTS Displays all database objects. The view definition is the same as that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS The system tenant displays the object information for all tenants.
oceanbase.DBA_OB_TENANTS This API is used to display the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants by TENANT_TYPE Columns are used to distinguish tenant types.
oceanbase.DBA_OB_TENANT_JOBS Displays task information at the tenant level.
oceanbase.CDB_OB_SYS_VARIABLES Displays the system variable information of all tenants under the sys tenant.
oceanbase.CDB_OB_TENANT_EVENT_HISTORY Displays the event history of all tenants.
oceanbase.DBA_OB_ZONES Displays information for all zones.

TTL related

View name
Feature description
oceanbase.CDB_OB_TTL_TASKS Displays the execution status of all user tenant TTL tasks in SQL mode.
oceanbase.CDB_OB_TTL_TASK_HISTORY Displays the execution history of all user tenant TTL tasks in SQL mode.
oceanbase.DBA_OB_TTL_TASKS Displays the execution status of the TTL tasks for the current tenant in SQL mode.
oceanbase.DBA_OB_TTL_TASK_HISTORY Displays the execution history of the TTL tasks for the current tenant in SQL mode.

Performance view overview

ASH-related

View name
Feature description
GV$ACTIVE_SESSION_HISTORY Displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY Displays the history of active sessions.
GV$OB_ACTIVE_SESSION_HISTORY This API is used to display the active session history of all OBServer nodes under all tenants.
V$OB_ACTIVE_SESSION_HISTORY This API is used to display the active session history on the current OBServer node for all tenants.

Catalog-related

View name
Feature description
GV$OB_HMS_CLIENT_POOL_STAT This API is used to display the usage of HMS Catalog clients for all tenants.
V$OB_HMS_CLIENT_POOL_STAT This API is used to display the usage of HMS Catalog clients for all tenants.
GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT Retrieves the catalog pooling information of all OBServer nodes.
V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT Retrieves the catalog pooling information of the OBServer node that executed the SQL statement.

DTL related

View name
Feature description
GV$OB_DTL_INTERM_RESULT_MONITOR Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR Displays the monitoring information of the DTL intermediate result manager.

Replica logs

View name
Feature description
GV$OB_TABLET_REPLICA_INFO Displays the basic information of all tablet replicas on each node of all tenants, including the tenant to which they belong, log stream, table, database, and disk usage.
V$OB_TABLET_REPLICA_INFO Displays the basic information of all tablet replicas for all tenants on the current node, including details such as the tenant, log stream, table, database, and disk usage.
GV$OB_LOG_STAT Displays the status of Palf.
GV$OB_LS_SNAPSHOTS Displays information about the log stream snapshots stored persistently in all units.
V$OB_LOG_STAT Displays the status of Palf.

Partitioning

View name
Feature description
V$OB_DYNAMIC_PARTITION_TABLES Displays the dynamic partitioned table information for all tenants.

Shared storage related

View name
Feature description
V$OB_SHARED_SSTABLES Displays the SSTable information on the shared storage of all tenants.
GV$OB_LOCAL_CACHE This topic displays metrics related to various cached data types in the local cache of all tenants on each OBServer node under the shared storage mode.
V$OB_LOCAL_CACHE This topic displays metrics related to various cached data types in the local cache of all tenants on the current OBServer node under shared storage mode.
GV$OB_STORAGE_CACHE_TASKS Displays the cache task information of each tenant on all OBServer nodes.
V$OB_STORAGE_CACHE_TASKS Displays the cache task information of each tenant on the current OBServer node.
GV$OB_TABLET_LOCAL_CACHE Displays the overall cache usage of each tenant across all OBServer nodes.
V$OB_TABLET_LOCAL_CACHE Displays the overall cache usage of each tenant on the current OBServer node.
GV$OB_SERVER_STORAGE Displays the object storage information of the shared storage cluster configuration on all OBServer nodes.
V$OB_SERVER_STORAGE Displays the object storage information of the shared storage cluster configured on the current OBServer node.
GV$OB_LOCAL_CACHE_DIAGNOSE This API is used to diagnose the running status of the local cache sub-module for all tenants on each OBServer node in shared storage mode.
V$OB_LOCAL_CACHE_DIAGNOSE This API is used to diagnose the running status of the local cache sub-module for all tenants on the current OBServer node in shared storage mode.

I/O-related

View name
Feature description
GV$OB_SHARED_STORAGE_QUOTA Displays the I/O access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA Displays the I/O access resource information on the current OBServer node.
GV$OB_IO_CALIBRATION_STATUS Displays the execution status of the I/O calibration task.
V$OB_IO_CALIBRATION_STATUS Displays the execution status of the I/O calibration task.
GV$OB_IO_BENCHMARK Displays the disk calibration data used by the I/O module.
V$OB_IO_BENCHMARK Displays the disk calibration data used by the I/O module.

Encryption tables

View name
Feature description
V$OB_ENCRYPTED_TABLES Displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES Displays the encryption status of tablespaces with encryption enabled.

Memory-related

View name
Feature description
GV$OB_MEMORY Displays memory statistics at the tenant level.
V$OB_MEMORY Displays memory statistics at the tenant level.
GV$OB_MEMSTORE This API is used to display the memory usage of the MemTable for all tenants on all servers.
V$OB_MEMSTORE This API is used to display tenant-level MemStore statistics.
GV$OB_MEMSTORE_INFO Displays detailed information about the MemTables of all partitions for all tenants on all servers.
V$OB_MEMSTORE_INFO Displays detailed information about the MemTables of all partitions for all tenants on all servers.
GV$OB_SSTABLES Displays the SSTable information of a tenant.
V$OB_SSTABLES Displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY This API is used to query the memory usage of each tenant in a cluster.
V$OB_TENANT_MEMORY This view displays the memory usage of each tenant in the current observer process.

Event-related

View name
Feature description
GV$OB_PROCESSLIST Displays the session information on all OBServer nodes of a tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO Displays the diagnostic information of COMPACT.
GV$OB_TABLET_COMPACTION_HISTORY Displays the historical information of tablet-level compaction.
GV$OB_TABLET_COMPACTION_PROGRESS Displays the progress information of tablet-level compaction.
GV$OB_TRANSACTION_PARTICIPANTS Displays information about transaction participants on all OBServer nodes.
GV$SESSION_EVENT This view displays session-level wait events for all OBServer nodes in the cluster.
GV$SESSION_WAIT This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time.
GV$SESSION_WAIT_HISTORY This view displays information about the last 10 wait events for all sessions on all servers.
GV$SYSTEM_EVENT Displays wait events at the tenant level for all tenants in the cluster.
GV$SESSTAT Statistics on session-level events for all OBServer nodes.
GV$SYSSTAT Displays tenant-level statistical event information on all servers.
V$OB_COMPACTION_PROGRESS Displays the server-level major compaction progress information of a tenant.
V$OB_COMPACTION_SUGGESTIONS Displays the recommended information for COMPACT.
V$OB_PROCESSLIST Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO Displays the diagnostic information of COMPACT.
V$OB_TABLET_COMPACTION_HISTORY Displays the historical information of tablet-level compaction.
V$OB_TABLET_COMPACTION_PROGRESS Displays the progress information of tablet-level compaction.
V$OB_TRANSACTION_PARTICIPANTS Displays information about transaction participants on all OBServer nodes.
V$STATNAME This topic describes all statistical events.
V$EVENT_NAME The following table describes the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT The following table describes the parameters of each event.
V$SESSION_WAIT_HISTORY Details of the events currently being waited for by each session, including the last 10 such events.
V$SESSTAT Displays the overview of statistical events at the session level.
V$SYSSTAT Displays tenant-level statistical event information on the current server.
V$SYSTEM_EVENT Statistics on tenant-level wait events.
GV$SESSION_LONGOPS Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS Displays the execution status and progress of DDL operations on the current OBServer node.

Cache-related

View name
Feature description
GV$OB_PLAN_CACHE_STAT Displays the overall status of each plan cache on all OBServer nodes for the current tenant.
V$OB_PLAN_CACHE_STAT Records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT Records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT Records the status of each cached object in the plan cache for the current tenant on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN Displays the physical execution plans cached on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN Displays the physical execution plans cached in the plan cache of the current server.
GV$OB_PS_STAT Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_PX_P2P_DATAHUB Displays information related to data transfer operations during parallel execution.
GV$OB_PX_TARGET_MONITOR Displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR Displays the PX thread usage on the OBServer node.
GV$OB_SQL_AUDIT It displays statistical information such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT It displays statistical information such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding record that also includes the trace information of that plan.
V$SQL_PLAN_MONITOR Statistics at the operation level for slow queries, with one statistic record per operation.
V$SQL_MONITOR_STATNAME Display GV$SQL_PLAN_MONITOR of OTHERSTAT_X_ID The meaning of the numbers in the fields.
GV$OB_FLT_TRACE_CONFIG Displays diagnostic information for end-to-end tracing.

Session-related

View name
Feature description
GV$OB_SESSION Records session information created on all servers.

Database-related

View name
Feature description
GV$OB_KVCACHE Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS Displays the parameter information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO Displays schema information on all servers.
GV$OB_SERVERS Displays information about all OBServer nodes.
GV$OB_UNITS Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster.
V$OB_KVCACHE Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO Displays schema information on all servers.
V$OB_SERVERS Displays information about the current OBServer node.
V$OB_UNITS Displays the unit information of this OBServer node.
GV$DML_STATS Displays DML information in the current user's tables.
V$DML_STATS Displays DML information in the current user's tables.
V$OB_COMPATIBILITY_CONTROL This topic describes all features whose product behavior can be controlled for compatibility with the OceanBase AI Database release version.

Lock-related

View name
Feature description
GV$LATCH The view displays the latch information of all OBServer nodes in the cluster.
V$LATCH View the latch information of all OBServer nodes in the cluster.

Network

View name
Feature description
GV$OB_RPC_OUTGOING The RPC sending statistics of all OBServer nodes.
GV$OB_RPC_INCOMING This API is used to display the statistics of RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING Statistics on the number of RPC packets sent by different tenant RPC packet codes on the OBServer node.
V$OB_RPC_INCOMING This metric is used to count the number of RPC packets received by different tenant RPC packet codes on the OBServer node.

Workarea-related

View name
Feature description
GV$SQL_WORKAREA Workarea statistics of all operators previously executed by the SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE Displays the workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM Displays the statistics of all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
GV$OB_SQL_WORKAREA_MEMORY_INFO This API is used to query general information about SQL Workarea, such as the maximum available memory, current memory usage, and current held memory.
V$SQL_WORKAREA Workarea statistics of all operators previously executed by the SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE Displays the workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM Displays statistics from all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
V$OB_SQL_WORKAREA_MEMORY_INFO This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory.

WR-related

View name
Feature description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM A histogram that shows the query execution time of all nodes in all tenants.
GV$OB_RES_MGR_SYSSTAT This API is used to display the statistics of resource groups in all OBServer nodes of all tenants.
GV$OB_SESS_TIME_MODEL This API is used to display time model statistics at the session level in a cluster.
GV$OB_SQLSTAT This view displays the basic performance statistics of SQL statements in a cluster. Each SQL statement is represented by a row (that is, each SQL_ID + Plan_Hash (The unique value of is one row.)
GV$OB_SYS_TIME_MODEL This API is used to display time series metrics at the tenant level in a cluster.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM A histogram that shows the query execution time of current nodes for all tenants.
V$OB_RES_MGR_SYSSTAT This API is used to display the statistics of resource groups in the current OBServer for all tenants.
V$OB_SESS_TIME_MODEL Displays the time model statistics at the session level on the current node.
V$OB_SQLSTAT This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (that is, each SQL_ID + Plan_Hash (The unique value of is one row.)
V$OB_SYS_TIME_MODEL Displays the time model statistics at the tenant level on the current node.

Thread-related

View name
Feature description
GV$OB_PX_WORKER_STAT In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT In parallel execution scenarios, view the execution information of each thread.
GV$OB_TENANT_RUNTIME_INFO Displays information related to thread queues and thread quotas for a tenant.
V$OB_TENANT_RUNTIME_INFO Displays information related to thread queues and thread quotas for a tenant.

Minor compaction and major compaction

View name
Feature description
GV$OB_MERGE_INFO Displays statistics related to completed compactions for the OceanBase AI Database cluster.
V$OB_MERGE_INFO Displays statistics related to completed compactions for the OceanBase AI Database cluster.
GV$OB_COMPACTION_PROGRESS Displays the OBServer-level major compaction progress information of a tenant.
GV$OB_COMPACTION_SUGGESTIONS Displays the recommended information for COMPACT.

Resource management

View name
Feature description
GV$OB_GROUP_IO_STAT Displays the real-time status of each resource group on all OBServer nodes of all tenants.
GV$OB_FUNCTION_IO_STAT Displays the I/O statistics at the function level for all tenants across all OBServer nodes.
V$OB_GROUP_IO_STAT Displays the real-time status of each resource group for all tenants on the current OBServer node.
V$OB_FUNCTION_IO_STAT Displays the IO statistics at the function level for all tenants on the current OBServer node.

User Tenant View Overview

Dictionary View Overview

Logical Tables

View name
Feature description
oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS Displays the background deletion tasks of logical tables currently being executed by the current tenant.
oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY Displays the history of completed background deletion tasks for logical tables in the current tenant.

Backup and Recovery

View name
Feature description
oceanbase.DBA_OB_BACKUP_JOBS Displays the backup job tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_JOBS Displays the backup job tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY Displays the historical records of the tenant's own task-level backup tasks.
oceanbase.DBA_OB_BACKUP_SET_FILES Displays the file status of the backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY Displays completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST Displays the archive path configuration.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO Displays the backup destination information used for backup and restore operations in a tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY Displays the historical information of backup destinations used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY Displays the cleanup strategies set for expired cleanup and automatic cleanup under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY Displays the historical information of backup cleanup tasks executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS Displays information about the backup_set or backup_piece cleanup tasks being executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant.
oceanbase.DBA_OB_ARCHIVELOG Displays the log backup status for each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY Displays the status of all historical and current log backups.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES Displays the status of pieces in a backup set.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS Displays information about table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS Displays information related to the import task.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS Displays records for table-level import tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY Displays the results of a table-level restore task.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY Displays the result of the import task.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY Displays the historical records of table-level cross-tenant import tasks.

Tables and Columns

View name
Feature description
information_schema.COLUMNS Record column information.
information_schema.STATISTICS Records table index information.
information_schema.TABLES Records table information.
information_schema.VIEWS Record view information.
information_schema.VIEW_TABLE_USAGE Displays information about the tables and views used in the view definition.
oceanbase.DBA_OB_TABLEGROUP_TABLES Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS Displays the columns contained in the partitioning key for all partition objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS View the columns contained in the subpartitioning key for all partition objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
information_schema.TABLESPACES Information related to tablespaces.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

oceanbase.DBA_TABLES Displays information about all tables in the current tenant.

Storage

View name
Feature description
mysql.proc Displays information about the stored procedure.
information_schema.ENGINES Records information related to the storage engine.
information_schema.PARAMETERS Provides information about stored procedure parameters and return values.
information_schema.ROUTINES Provides information related to stored procedures.

Access Control

View name
Feature description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Displays the number of failed login attempts by different users.
oceanbase.DBA_RLS_POLICIES Displays the row-level security (RLS) policy configuration of the current user tenant.

Partitioning

View name
Feature description
information_schema.PARTITIONS Records partition information.
oceanbase.DBA_IND_PARTITIONS Displays the partition information of the index.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES Displays the dynamic partitioned table information for the current tenant.
oceanbase.DBA_PART_INDEXES Displays the partition information for all partitioned indexes.
oceanbase.DBA_PART_TABLES Displays partition information of a user table.
oceanbase.DBA_TAB_PARTITIONS Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to.
oceanbase.DBA_TAB_SUBPARTITIONS It displays the subpartition name, the table and partition names to which it belongs, its storage attributes, and DBMS_STATS The statistics generated by the package.
oceanbase.DBA_SUBPARTITION_TEMPLATES Displays the description of all subpartition templates.

Load Balancing

View name
Feature description
oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT Displays all partitions with special weights set under the current user tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS Displays the current partition transfer tasks being processed under this tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY Displays the history of transfer partition tasks executed for this tenant.

Replica Logs

View name
Feature description
oceanbase.DBA_OB_CS_REPLICA_STATS Displays the progress of converting tablets to columnar storage in the log streams of the C replicas on each OBServer node of the tenant.
oceanbase.DBA_IND_SUBPARTITIONS Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS Displays the partition information of a table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS Displays the subpartition information for a table group that is partitioned.
oceanbase.DBA_OB_TABLEGROUPS Displays the meta information of a table group, mainly its partition information.
oceanbase.DBA_OB_TABLET_REPLICAS This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>.
oceanbase.DBA_OB_TABLET_TO_LS Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS Displays the replica distribution information of log stream (LS) for the current tenant.
oceanbase.DBA_OB_CS_REPLICA_STATS Displays the progress of converting tablets to columnar storage in the log streams of the C replicas on each OBServer node of the tenant.
oceanbase.DBA_IND_SUBPARTITIONS Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS Displays the partition information of a table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS Displays the subpartition information for a table group that is partitioned.
oceanbase.DBA_OB_TABLEGROUPS Displays the meta information of a table group, mainly its partition information.
oceanbase.DBA_OB_TABLET_REPLICAS This view displays information for all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>.
oceanbase.DBA_OB_TABLET_TO_LS Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS Displays the replica distribution information of log stream (LS) for the current tenant.

Shared Storage

View name
Feature description
DBA_OB_STORAGE_SPACE_USAGE Records the storage space usage of the current tenant's object storage.
DBA_OB_SHARED_MACRO_BLOCK_GC_STAT Displays the number of shared data GC-deleted macroblocks per day for each storage type in the current tenant.

Help Commands

View name
Feature description
mysql.help_topic With the other three tables mysql.help_category, mysql.help_relation, mysql.help_keyword Generate the help command together.
mysql.help_category With the other three tables mysql.help_relation, mysql.help_topic, mysql.help_keyword Co-create help commands.
mysql.help_keyword With the other three tables mysql.help_relation, mysql.help_topic, mysql.help_category Generate help commands in collaboration.
mysql.help_relation With the other three tables mysql.help_category, mysql.help_topic, mysql.help_keyword Collaborate to generate Help commands.

InnoDB Storage Engine

View name
Feature description
information_schema.INNODB_LOCK_WAITS This view displays information about the lock transactions and lock objects that are waiting when a lock conflict occurs.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_LOCKS This view displays information about all locks currently held or waiting to be acquired.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP This view displays the mapping information between NDB transactions, the NDB transaction coordinator, and MySQL servers attached to the NDB cluster as API nodes.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_TRX This view displays information about active transactions.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_BUFFER_PAGE This view displays information about all cached pages in the buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_BUFFER_PAGE_LRU Displays the LRU sorted information of pages in the InnoDB buffer pool.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_BUFFER_POOL_STATS This view displays statistics of the InnoDB buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMP Displays and compresses the status information related to InnoDB tables.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMP_PER_INDEX Displays information related to operations on InnoDB tables and indexes.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMP_PER_INDEX_RESET This view displays and resets the time information for InnoDB table and index-related operations, including display and compression.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

information_schema.INNODB_CMP_RESET Displays the status of operations related to compressing an InnoDB table.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMPMEM This view displays the status of compressed pages in the InnoDB buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_CMPMEM_RESET Displays the reset time of compressed pages in the InnoDB buffer pool.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_DATAFILES Displays the data file path information for the InnoDB files of each table and general tablespace.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_INDEXES Displays InnoDB index metadata information.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_TABLES Displays the metadata information of an InnoDB table.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_TABLESPACES Displays the metadata of InnoDB table files and general tablespaces.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; it can only be used to query the table structure.

information_schema.INNODB_SYS_TABLESTATS Displays low-level status information of an InnoDB table.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_VIRTUAL Displays the metadata of virtually generated columns in InnoDB tables.

Note

This view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_TEMP_TABLE_INFO Displays information about InnoDB temporary tables created by active users.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_METRICS Displays InnoDB performance information.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

I/O Performance

View name
Feature description
DBA_OB_STORAGE_IO_USAGE Displays the I/O operation statistics of the current tenant's object storage and cloud disk.

OBKV-related

View name
Feature description
oceanbase.DBA_OB_KV_TTL_TASKS Displays the TTL tasks currently being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY Displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO Displays the configuration parameter information of the current node's OBKV tenant client connection.
GV$OB_KV_CLIENT_INFO Displays the configuration parameter information of the client connection for this OBKV tenant.

Outline related

View name
Feature description
oceanbase.DBA_OB_OUTLINES Displays the execution plan outline information for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL Displays the throttling rule outline information for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY Displays the execution plan and throttling rule outline historical information for this tenant.
DBA_OB_FORMAT_OUTLINES Records the details of the current tenant's format outline.

Task Scheduling Manager Related

View name
Feature description
oceanbase.DBA_SCHEDULER_JOBS Displays information about all scheduler jobs in the database.

Permissions

View name
Feature description
mysql.db Displays database-level privileges (VIRTUAL_TABLE).
mysql.user Used to record user-level privilege information (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES Displays column permission information.
information_schema.SCHEMA_PRIVILEGES Describes database permission information.
information_schema.TABLE_PRIVILEGES Records table privilege information.
information_schema.USER_PRIVILEGES Records user permission information.
oceanbase.DBA_JAVA_POLICY Displays the Java permission policy for all users in the current tenant.
oceanbase.USER_JAVA_POLICY Displays the Java permission policy of the currently logged-in user.

Full-text indexes

View name
Feature description
information_schema.INNODB_FT_BEING_DELETED Displays information about full-text indexes being dropped.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_FT_CONFIG Displays the configuration information of the InnoDB full-text search engine.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_FT_DELETED Displays information about full-text indexes that have been marked for deletion.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_FT_INDEX_CACHE This view displays the cache status information of InnoDB full-text indexes.

Note

This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_FIELDS This view displays the metadata of key columns (fields) in an InnoDB index, which is equivalent to the information in the SYS_FIELDS table in the InnoDB data dictionary.

Note

This view is provided only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

Session-related

View name
Feature description
information_schema.SESSION_STATUS Records session status information, such as the current number of active connections and database uptime.
information_schema.SESSION_VARIABLES Variable information of the session.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant.

Time zone

View name
Feature description
mysql.time_zone Displays time zone-related information (SYSTEM_VIEW).
mysql.time_zone_name Used to record the name of the time zone (SYSTEM_VIEW).
mysql.time_zone_transition mysql.time_zone_transition is a system view used to record time zone conversion information.
mysql.time_zone_transition_type Used to record the time zone conversion type (SYSTEM_VIEW).

SPM-related

View name
Feature description
oceanbase.DBA_SQL_PLAN_BASELINES Displays the plan baseline of the SQL statement in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG Displays the configuration parameters in SPM.

Basic database information

View name
Feature description
information_schema.GLOBAL_STATUS Records the global state information of OceanBase AI Database.
information_schema.GLOBAL_VARIABLES Records global variable information.
information_schema.SCHEMATA Records database metadata.
oceanbase.DBA_OB_DATABASES Displays the database metadata of a tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION Displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION Displays the major compaction information for each zone in the tenant.
oceanbase.DBA_OB_FREEZE_INFO Displays the version information generated during a major freeze.
information_schema.events Records all event information.

Statistics and histograms

View name
Feature description
oceanbase.DBA_TAB_STATISTICS Displays the optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS Displays the column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS Displays the column statistics and histogram information for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS Displays the column statistics and histogram information for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS Displays histograms for all columns in the database.
oceanbase.DBA_PART_HISTOGRAMS Displays the histogram data (the endpoints of each histogram) for all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY Displays the historical table statistics for all tables in the database.
oceanbase.DBA_IND_STATISTICS Displays the optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS Displays the cumulative modification information of tables in the database.
information_schema.QUERY_RESPONSE_TIME It displays data types such as RESPONSE TIME histograms for monitoring by Prometheus.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY Query the historical collection execution of a table.

Foreign key related

View name
Feature description
information_schema.INNODB_SYS_FOREIGN Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

information_schema.INNODB_SYS_FOREIGN_COLS This view displays information about the status of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.

Note

This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

WR-related

View name
Feature description
oceanbase.DBA_WR_SNAPSHOT Display the of this tenant. SNAPSHOT Information.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY Displays the persisted ASH data for this tenant.
oceanbase.DBA_WR_STATNAME Displays the names of system statistics for the current tenant.
oceanbase.DBA_WR_SYSSTAT Displays the detailed system statistics of the current tenant.
oceanbase.DBA_WR_CONTROL Displays the configuration information related to write requests.
oceanbase.DBA_WR_SYSTEM_EVENT Displays the persistent tenant-level wait event information for the current tenant.
oceanbase.DBA_WR_EVENT_NAME Displays the names of persistent tenant-level wait events for the current tenant.
oceanbase.DBA_WR_SQLTEXT Displays the SQL text collected for write operations of the current tenant.
oceanbase.DBA_WR_SQLSTAT This view displays the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table. SQL_ID + Plan_Hash Each unique value corresponds to one row).
oceanbase.DBA_WR_SYS_TIME_MODEL This table displays the write data of time model statistics for the current tenant.

Materialized view related

View name
Feature description
oceanbase.DBA_MVIEW_DEPS Displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS Displays the log information of materialized views.
oceanbase.DBA_MVIEW_RUNNING_JOBS Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS Displays information about all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS This view displays statistics related to materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS It displays information about each refresh operation of a materialized view, with each operation identified by a REFRESH_ID.
oceanbase.DBA_MVREF_STATS This view displays basic timing statistics for materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS Displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS The system-wide default value for the historical statistics refresh attribute of materialized views.
oceanbase.DBA_MVREF_STMT_STATS Describes the information associated with the refresh statement.

TTL-related

View name
Feature description
oceanbase.DBA_OB_TTL_TASKS Displays the execution status of the TTL tasks for the current tenant in SQL mode.
oceanbase.DBA_OB_TTL_TASK_HISTORY Displays the execution history of the TTL tasks for the current tenant in SQL mode.

Thread-related

View name
Feature description
information_schema.PROCESSLIST Provides information about running threads.

Constraints

View name
Feature description
information_schema.CHECK_CONSTRAINTS Display CREATE TABLE Constraints on tables and columns during operations.
information_schema.KEY_COLUMN_USAGE Records the constraint information of the key in the column.
information_schema.REFERENTIAL_CONSTRAINTS Displays the metadata of foreign key constraints.
information_schema.TABLE_CONSTRAINTS Describes table constraints.

Resource-related

View name
Feature description
oceanbase.DBA_OB_SEQUENCE_OBJECTS Displays all sequences in the database.

Resource Manager-related

View name
Feature description
DBA_OB_RSRC_DIRECTIVES Displays the resource configuration parameters of the current tenant in the Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES Displays the I/O resource configuration of the current tenant in the Resource Manager.
DBA_RSRC_GROUP_MAPPINGS Displays the binding relationship between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS Display information about all resource groups in the database.
DBA_RSRC_PLANS Displays all system-defined resource management plans.
DBA_RSRC_PLAN_DIRECTIVES Displays the details of each resource plan directive in the database.

Tenant management

View name
Feature description
oceanbase.DBA_OBJECTS Displays all database objects. The view definition is the same as that of ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS Displays the basic information of all tenants. This includes the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants by TENANT_TYPE Columns are used to distinguish tenant types.

Character set

View name
Feature description
information_schema.CHARACTER_SETS Records the character set information of OceanBase AI Database.
information_schema.COLLATIONS Records the comparison method information for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY Records the correspondence between characters and collations.

Performance view overview

ASH-related

View name
Feature description
GV$ACTIVE_SESSION_HISTORY Displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY Displays the history of active sessions.
V$OB_ACTIVE_SESSION_HISTORY This API is used to display the active session history of the current OBServer node in the tenant.
GV$OB_ACTIVE_SESSION_HISTORY This API is used to display the active session history of all OBServer nodes in the current tenant.

Catalog-related

View name
Feature description
GV$OB_HMS_CLIENT_POOL_STAT This API is used to query the HMS catalog usage of the current tenant.
V$OB_HMS_CLIENT_POOL_STAT This API is used to query the HMS catalog usage of the current tenant.
GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT Retrieves the catalog pooling information of all OBServer nodes.
V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT Retrieves the catalog pooling information of the OBServer node that executed the SQL statement.

Wait for Events

View name
Feature description
GV$OB_COMPACTION_PROGRESS Displays the OBServer-level major compaction progress information of a tenant.
GV$OB_COMPACTION_SUGGESTIONS Displays the recommended information for COMPACT.
GV$OB_PROCESSLIST Displays the session information on all OBServer nodes of a tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO Displays the diagnostic information of COMPACT.
GV$OB_TABLET_COMPACTION_HISTORY Displays the historical information of tablet-level compaction.
GV$OB_TABLET_COMPACTION_PROGRESS Displays the progress information of tablet-level compaction.
GV$OB_TRANSACTION_PARTICIPANTS Displays information about transaction participants on all OBServer nodes.
GV$SESSION_EVENT This view displays session-level wait events for all OBServer nodes in the cluster.
GV$SESSION_WAIT This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time.
GV$SESSION_WAIT_HISTORY This view displays information about the last 10 wait events for all sessions on all servers.
GV$SYSTEM_EVENT Displays wait events at the tenant level for all tenants in the cluster.
GV$SESSTAT Statistics on session-level events for all OBServer nodes.
GV$SYSSTAT Displays tenant-level statistical event information on all servers.
V$OB_COMPACTION_PROGRESS Displays the server-level major compaction progress information of a tenant.
V$OB_COMPACTION_SUGGESTIONS Displays the recommended information for COMPACT.
V$OB_PROCESSLIST Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO Displays the diagnostic information of COMPACT.
V$OB_TABLET_COMPACTION_HISTORY Displays the historical information of tablet-level compaction.
V$OB_TABLET_COMPACTION_PROGRESS Displays the progress information of tablet-level compaction.
V$OB_TRANSACTION_PARTICIPANTS Displays information about transaction participants on all OBServer nodes.
V$STATNAME This topic describes all statistical events.
V$EVENT_NAME The following table describes the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT The following table describes the parameters of each event.
V$SESSION_WAIT_HISTORY Details of the events currently being waited for by each session, including the last 10 such events.
V$SESSTAT Displays the overview of statistical events at the session level.
V$SYSSTAT Displays tenant-level statistical event information on the current server.
V$SYSTEM_EVENT Statistics on tenant-level wait events.

DTL-related

View name
Feature description
GV$OB_DTL_INTERM_RESULT_MONITOR Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR Displays the monitoring information of the DTL intermediate result manager.

Replica logs

View name
Feature description
GV$OB_LOG_STAT Displays the status of Palf.
V$OB_LOG_STAT Displays the status of Palf.

Partitioning

View name
Feature description
V$OB_DYNAMIC_PARTITION_TABLES Displays the dynamic partitioned table information of the current tenant.

Shared storage related

View name
Feature description
V$OB_SHARED_SSTABLES Displays the SSTable information on the shared storage of the current tenant.
GV$OB_LOCAL_CACHE This topic describes the metrics for various cache data types stored locally in the cache memory of each OBServer node for all tenants under the shared storage mode.
V$OB_LOCAL_CACHE This topic displays metrics related to various cached data types in the local cache of all tenants on the current OBServer node under shared storage mode.
GV$OB_STORAGE_CACHE_TASKS Displays the cache task information of the current tenant on all OBServer nodes.
V$OB_STORAGE_CACHE_TASKS Displays the cache task information of the current tenant on the current OBServer node.
GV$OB_TABLET_LOCAL_CACHE Displays the overall cache status of the current tenant across all OBServer nodes.
V$OB_TABLET_LOCAL_CACHE Displays the overall cache status of the current tenant on the current OBServer node.
GV$OB_TABLET_MACRO_CACHE_STAT Displays the tablet macroblock cache statistics of the current tenant across all OBServer nodes.
V$OB_TABLET_MACRO_CACHE_STAT Displays the tablet macroblock cache statistics of the current tenant on the current OBServer node.
GV$OB_LOCAL_CACHE_DIAGNOSE This API is used to diagnose the running status of the local cache sub-module of the current tenant on each OBServer node in shared storage mode.
V$OB_LOCAL_CACHE_DIAGNOSE This API is used to diagnose the running status of the local cache sub-module of the current tenant on the current OBServer node in shared storage mode.

Cache related

View name
Feature description
GV$OB_PLAN_CACHE_STAT Displays the overall status of each plan cache on all OBServer nodes for the current tenant.
V$OB_PLAN_CACHE_STAT Records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT Records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT Records the status of each cached object in the plan cache for the current tenant on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN Displays the physical execution plans cached on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN Displays the physical execution plans cached in the plan cache of the current server.
GV$OB_PS_STAT Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR Displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR Displays the PX thread usage on the OBServer node.
GV$OB_SQL_AUDIT It displays statistical information such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT It displays statistical information such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding record that also includes the trace information of that plan.
V$SQL_PLAN_MONITOR Statistics at the operation level for slow queries, with one statistic record per operation.
V$SQL_MONITOR_STATNAME Display GV$SQL_PLAN_MONITOR of OTHERSTAT_X_ID The meaning of the numbers in the fields.
GV$OB_FLT_TRACE_CONFIG Displays diagnostic information for end-to-end tracing.

I/O-related

View name
Feature description
GV$OB_SHARED_STORAGE_QUOTA Displays the I/O access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA Displays the I/O access resource information on the current OBServer node.

Encryption tables

View name
Feature description
V$OB_ENCRYPTED_TABLES Displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES Displays the encryption status of tablespaces with encryption enabled.

Memory

View name
Feature description
GV$OB_MEMORY Displays memory statistics at the tenant level.
V$OB_MEMORY Displays memory statistics at the tenant level.
GV$OB_MEMSTORE This API is used to display the memory usage of the MemTable for all tenants on all servers.
V$OB_MEMSTORE This API is used to display tenant-level MemStore statistics.
GV$OB_MEMSTORE_INFO Displays detailed information about the MemTables of all partitions for all tenants on all servers.
V$OB_MEMSTORE_INFO Displays detailed information about the MemTables of all partitions for all tenants on all servers.
GV$OB_SSTABLES Displays the SSTable information of a tenant.
V$OB_SSTABLES Displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY This API is used to query the memory usage of each tenant in a cluster.
V$OB_TENANT_MEMORY This view displays the memory usage of each tenant in the current observer process.

Session-related

View name
Feature description
GV$SESSION_LONGOPS Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS Displays the execution status and progress of DDL operations on the current OBServer node.

Lock-related

View name
Feature description
GV$LATCH The view displays the latch information of all OBServer nodes in the cluster.
V$LATCH View the latch information of all OBServer nodes in the cluster.

Database-related

View name
Feature description
GV$OB_KVCACHE Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS Displays the parameter information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO Displays schema information on all servers.
GV$OB_UNITS Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster.
V$OB_KVCACHE Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO Displays schema information on all servers.
V$OB_UNITS Displays the unit information of this OBServer node.
GV$DML_STATS Displays DML information in the current user's tables.
V$DML_STATS Displays DML information in the current user's tables.
V$OB_COMPATIBILITY_CONTROL This topic describes all features whose product behavior can be controlled for compatibility with the OceanBase AI Database release version.

Workarea-related

View name
Feature description
GV$SQL_WORKAREA Workarea statistics of all operators previously executed by the SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE Displays the workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM Displays the statistics of all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
GV$OB_SQL_WORKAREA_MEMORY_INFO This API is used to query general information about SQL Workarea, such as the maximum available memory, current memory usage, and current held memory.
V$SQL_WORKAREA Workarea statistics of all operators previously executed by the SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE Displays the workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM Displays statistics from all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
V$OB_SQL_WORKAREA_MEMORY_INFO This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory.

WR-related

View name
Feature description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM A histogram that shows the query execution time of all nodes in the current tenant.
GV$OB_RES_MGR_SYSSTAT This API is used to display the statistics of resource groups on all OBServer nodes in the current tenant.
GV$OB_SQLSTAT This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented by a row (that is, each SQL_ID + Plan_Hash The unique value of the primary key is one row).
V$OB_SQLSTAT This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (that is, each SQL_ID + Plan_Hash (The unique value of is one row.)
GV$OB_SESS_TIME_MODEL This API is used to display time model statistics at the session level in a cluster.
V$OB_SESS_TIME_MODEL Displays the time model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL This API is used to display time series metrics at the tenant level in a cluster.
V$OB_SYS_TIME_MODEL Displays the time model statistics at the tenant level on the current node.
V$OB_RES_MGR_SYSSTAT This view displays the statistical metrics of resource groups in the current OBServer node under the current tenant.

Network

View name
Feature description
GV$OB_RPC_OUTGOING The RPC sending statistics of all OBServer nodes.
GV$OB_RPC_INCOMING This API is used to display the statistics of RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING Statistics on the number of RPC packets sent by different tenant RPC packet codes on the OBServer node.
V$OB_RPC_INCOMING This metric is used to count the number of RPC packets received by different tenant RPC packet codes on the OBServer node.

Thread-related

View name
Feature description
GV$OB_PX_WORKER_STAT In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT In parallel execution scenarios, view the execution information of each thread.

Resource management

View name
Feature description
GV$OB_GROUP_IO_STAT Displays the real-time status of each resource group on all OBServer nodes of the current tenant.
GV$OB_FUNCTION_IO_STAT Displays the I/O statistics at the function level for the current tenant across all OBServer nodes.
V$OB_GROUP_IO_STAT Displays the real-time status of each resource group for the current tenant on the current OBServer node.
V$OB_FUNCTION_IO_STAT Displays the I/O statistics at the function level for the current tenant on the current OBServer node.

Minor compaction and major compaction related

View name
Feature description
GV$OB_MERGE_INFO Displays statistics related to completed compactions for the OceanBase AI Database cluster.
V$OB_MERGE_INFO Displays statistics related to completed compactions for the OceanBase AI Database cluster.

Previous topic

Overview of system views
Last

Next topic

information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
Next
on this page
Overview of views in the sys tenant
Overview of dictionary views
Performance view overview
User Tenant View Overview
Dictionary View Overview
Performance view overview