OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V4.2.1

  • What is OceanBase Database
    • Overview
    • Differences between the Enterprise Edition and the Community Edition
    • System architecture
    • Compatibility with Oracle
      • Overview
      • SQL data types
      • Built-in functions
      • System views
    • Compatibility with MySQL
    • Limitations
  • Get Started
    • Video tutorials
    • Quick start with OceanBase Database Community Edition
    • Try out advanced features of OceanBase Database
      • Scalable OLTP
        • Run the TPC-C benchmark in OceanBase Database
        • Try out the hot row update capability of OceanBase Database
      • Try out operational OLAP
      • Try out parallel import and data compression
      • Try out the multi-tenant feature
    • Build a sample application (Oracle mode)
      • Build a Java application
      • Build a C application
    • Learn OceanBase SQL
      • Basic SQL operations (Oracle mode)
      • Basic SQL operations (MySQL mode)
      • Before you begin
    • Build a sample application (MySQL mode)
      • Build a Python application
      • Build a Java application
      • Build a C application
      • Build a Go application
  • Develop
    • Develop applications (MySQL mode)
      • Sample applications
        • Java
          • Spring Boot
          • Spring Batch
          • Spring Data JDBC
          • Spring Data JPA
          • Hibernate
          • MyBatis
        • Python
          • mysqlclient
          • PyMySQL
        • Go
          • Go-SQL-Driver/MySQL
          • GORM
      • Write data
        • Delete data
        • Update data
        • Insert data
        • Replace data
      • Application errors
        • Troubleshooting guidelines
          • About error codes
          • Error handling specifications for MySQL-compatible applications
        • Common errors and troubleshooting practices
          • Table does not exist, with ERROR 1146 reported
          • Data truncated while being inserted, with ERROR 1265 reported
          • Incorrect user password, with ERROR 1045 reported
          • Transaction timed out, with ERROR 4012 reported
          • User locked, with ERROR 3118 reported
          • Idle transaction timed out, with ERROR 6002 reported
          • Table already exists, with ERROR 1050 reported
          • Duplicate data inserted, with ERROR 1062 reported
          • Disconnected from the server, with ERROR 2013 reported
          • ERROR 1215 reported in foreign key addition
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase Database tenant by using the mysql client
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
        • Use database connection pool
          • Database connection pool configuration
          • Tomcat
          • c3p0
          • Proxool
          • HikariCP
          • DBCP
          • Commons Pool
          • Druid
      • Read data
        • Use a DBLink in queries
        • Single-table queries
        • Set operations
        • Use operators and functions in queries
          • Use aggregate functions in queries
          • Use numerical functions in queries
          • Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
          • Use the CASE conditional operator in queries
          • Use type conversion functions in queries
          • Use datetime functions in queries
          • Use arithmetic operators in queries
          • Use string functions in queries
          • Use string concatenation operators in queries
          • Use NULL-related functions in queries
          • Use the SELECT ... FOR UPDATE statement to lock query results
        • Join tables
          • RIGHT JOIN queries
          • Subqueries
          • LEFT JOIN queries
          • INNER JOIN queries
          • FULL JOIN queries
      • Plan database objects
        • Create a database
        • Create a table group
        • Create a table
        • Create an index
        • Create an external table
      • Transactions
        • Overview
        • Start a transaction
        • Savepoints
          • Mark a savepoint
          • Release a savepoint
          • Roll back a transaction to a savepoint
        • Commit a transaction
        • Roll back a transaction
    • Develop applications (Oracle mode)
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
        • Use database connection pool
          • c3p0
          • Database connection pool configuration
          • DBCP
          • HikariCP
          • Proxool
          • Tomcat
          • Commons Pool
          • Druid
      • Sample applications
        • Java
          • Spring Boot
          • MyBatis
          • OceanBase Connector/J
          • Spring Data JPA
          • Spring Data JDBC
          • Hibernate
          • Spring Batch
          • JFinal
        • C/C++
          • OceanBase Connector/C
          • OceanBase Connector/ODBC
          • SqlSugar
      • Plan database objects
        • Create a table group
        • Create a table
        • Create an index
        • Create an external table
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
      • Read data
        • Set operations
        • Single-table queries
        • Use a DBLink in queries
        • Join tables
          • INNER JOIN queries
          • RIGHT JOIN queries
          • LEFT JOIN queries
          • Subqueries
          • FULL JOIN queries
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use numerical functions in queries
          • Use string concatenation operators in queries
          • Use CASE functions in queries
          • Use the SELECT...FOR UPDATE statement to lock query results
          • Use string functions in queries
          • Use NULL-related functions in queries
          • Use datetime functions in queries
      • Transactions
        • Overview
        • Start a transaction
        • Savepoints
          • Mark a savepoint
          • Roll back a transaction to a savepoint
        • Commit a transaction
        • Roll back a transaction
      • Application errors
        • Common errors and troubleshooting practices
          • Transaction timed out, with Error ORA-00600 reported
          • Idle transaction timed out, with Error ORA-24761 reported
          • Duplicate data inserted, with Error ORA-00001 reported
          • Table does not exist, with Error ORA-04043 reported
          • Inconsistent data types, with Error ORA-00932 reported
          • User locked, with ERROR 3118 reported
          • Table already exists, with Error ORA-00955 reported
          • Error ORA-00600 reported in foreign key addition
          • Incorrect user password, with ERROR 1045 reported
        • Troubleshooting guidelines
          • About error codes
          • Error handling specifications for Oracle-compatible applications
  • Deploy
    • Overview
    • HA deployment solutions for OceanBase clusters
    • Deploy OceanBase Database Enterprise Edition
      • Deployment process
      • Before deployment
        • Prepare servers
        • Configure servers
        • Prepare installation packages
        • Deploy OAT
      • Deploy through GUI
        • Configure deployment environment using OAT
          • Add a server
        • Deploy OCP
          • Overview
          • Upload installation packages
          • Create MetaDB
          • Deploy OCP
        • Deploy OceanBase clusters using OCP
          • Deploy a standalone OceanBase database by using OCP
          • Deploy a two-replica OceanBase cluster with the arbitration service by using OCP
          • Add a server to the resource pool
          • Deploy a three-replica OceanBase cluster by using OCP
          • Deploy a single-replica OceanBase cluster by using OCP
        • (Optional) Deploy ODP
      • Deploy through CLI
        • Configure deployment environment
          • Initialize an OBServer node by using oatcli
          • (Optional) Configure the clock source
        • Deploy OceanBase clusters using CLI
          • Deploy a standalone OceanBase database by using the CLI
          • Deploy a two-replica OceanBase cluster with the arbitration service by using the CLI
          • Deploy a three-replica OceanBase cluster by using the CLI
          • Deploy a single-replica OceanBase cluster by using the CLI
        • (Optional) Deploy ODP
    • Deploy OceanBase Database Community Edition
      • Overview
      • Deploy locally
        • Deploy OceanBase Database in a production environment by using the CLI
        • Software and hardware requirements
        • Before deployment
          • (Optional) Check resources
          • (Optional) Set password-free SSH logon
          • (Optional) Configure the clock source
          • (Optional) Perform disk planning
          • (Optional) Configure limits.conf
          • (Optional) Configure sysctl.conf
          • (Optional) Disable the firewall and SELinux
          • (Optional) Create a user
        • Deploy through GUI
          • Deploy an OceanBase cluster through the GUI of OBD
          • Deploy an OceanBase cluster through the GUI of OCP
      • Deploy OceanBase Database in a Kubernetes cluster
    • Clear an OceanBase cluster
  • Migrate
    • Overview
    • Migrate from MySQL databases to OceanBase Database
      • Use Flink CDC to synchronize data from a MySQL database to OceanBase Database
      • Use OMS to migrate data from a MySQL database to a MySQL tenant of OceanBase Database
      • Use mydumper and myloader to migrate data from a MySQL database to OceanBase Database
      • Use ChunJun to migrate data from a MySQL database to OceanBase Database
      • Use CloudCanal to migrate data from a MySQL database to OceanBase Database
      • Use DataX to migrate table data from a MySQL database to OceanBase Database
      • Use DBCAT to migrate schemas from a MySQL database to OceanBase Database
      • Use Canal to synchronize data from a MySQL database to OceanBase Database
    • Migrate from OceanBase Database to MySQL databases
      • Use OMS to migrate data from a MySQL tenant of OceanBase Database to a MySQL database
      • Use OMS to migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database
      • Use DBCAT to migrate schemas from OceanBase Database to a MySQL database
      • Use DataX to migrate table data from OceanBase Database to a MySQL database
      • Use Canal to synchronize data from OceanBase Database to a MySQL database
      • Use CloudCanal to migrate data from OceanBase Database to a MySQL database
      • Use Flink CDC to migrate data from OceanBase Database to a MySQL database
      • Use ChunJun to migrate data from OceanBase Database to a MySQL database
    • Migrate from Oracle databases to OceanBase Database
      • Use OMS to migrate data from an Oracle database to a MySQL tenant of OceanBase Database
      • Use OMS to migrate data from an Oracle database to an Oracle tenant of OceanBase Database
      • Use DBCAT to migrate schemas from an Oracle database to OceanBase Database
      • Use DataX to migrate table data from an Oracle database to OceanBase Database
    • Migrate from OceanBase Database to Oracle databases
      • Use DBCAT to migrate schemas from OceanBase Database to an Oracle database
      • Use DataX to migrate table data from OceanBase Database to an Oracle database
      • Use OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle database
    • Migrate from DB2 databases to OceanBase Database
      • Use OMS to migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database
      • Use OMS to migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database
      • Use DBCAT to migrate table schemas from a DB2 LUW database to OceanBase Database
    • Migrate from OceanBase Database to DB2 databases
      • Use OMS to migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database
      • Use OMS to migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database
    • Migrate from TiDB databases to OceanBase Database
      • Use OMS to migrate data from a TiDB database to a MySQL tenant of OceanBase Database
    • Migrate from PostgreSQL databases to OceanBase Database
      • Use OMS to migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database
    • Migrate from CSV files to OceanBase Database
      • Import data by using the LOAD DATA statement
      • Use DataX to migrate CSV files to OceanBase Database
    • Import data from SQL files to OceanBase Database
    • Migrate data between OceanBase Database
      • Use OBLOADER & OBDUMPER to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database
      • Use OMS to migrate data from an OceanBase Database tenant to another of the same type
      • Use OMS to migrate data from an OceanBase Database tenant to another of the same type in active-active disaster recovery scenarios
      • Use OBLOADER & OBDUMPER to migrate data between Oracle tenants in OceanBase Database
      • Use OBLOADER & OBDUMPER to migrate data between MySQL tenants in OceanBase Database
      • Use OBLOADER & OBDUMPER to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database
    • Migrate data using SQL statements
      • Export data by using OUTFILE statements
      • Migrate resource units
      • Migrate data between tables
    • Bypass import
      • Overview
      • Import data in bypass mode by using the LOAD DATA statement
      • Import data in bypass mode by using the INSERT INTO SELECT statement
  • Manage
    • Log on to an OceanBase Database tenant
    • Manage replicas
      • Overview
      • Replica distribution
        • Locality
        • Common locality operations
          • View locality
          • Adjust the distribution of replicas
          • Remove replicas
          • Add replicas
          • View the locality change history
          • Migrate units
          • Modify locality
      • Traffic distribution
      • Data distribution
    • Performance tuning
      • Overview
      • Identify bottlenecks on the data link
      • Identify bottlenecks within components
        • ODP performance bottlenecks
        • ODP performance analysis
        • OBServer performance bottlenecks
          • Overview
          • Non-optimal plan
            • Non-optimal plans
            • Cardinality
            • Buffer tables
          • Hard parsing
          • Capacity issues
          • Internal wait events
      • SQL tuning
        • SQL tuning system
        • Execution plan optimization
          • Order and limit optimization
            • Overview
            • SORT assignment and optimization
            • Optimization in ORDER BY + LIMIT scenarios
          • Plan management
            • Plan cache
            • Disadvantages of the plan cache and countermeasures
            • Views related to the plan cache
          • Statistical information and row estimation
            • Overview
            • Statistical information
              • Overview
              • Collect statistical information
                • Overview
                • Manually collect statistics
                • Automatically collect statistics
              • Query statistics
              • Manage statistical information
                • Overview
                • Delete and set statistics
                • Import and export statistics
                • Lock statistics
                • Query historical versions of statistics and roll back to a specified version
                • Configure statistics collection strategies
            • Row estimation
              • Overview
              • Row estimation based on the selectivity
              • Row estimation based on the storage layer
            • Use statistical information and row estimation
          • Join order and join algorithm
            • Joins
            • Join algorithm
              • Nested loop joins
              • Hash joins
              • Merge joins
              • Common business issues
            • Join types
            • Join order
          • Index selection
            • Overview
            • Reduce row reads
            • Avoid table access by index primary key
            • Avoid sorting
        • Business logic optimization
          • SQL specifications
          • Schema specifications
        • Locate and analyze slow queries I
        • Locate and analyze slow queries II
        • Typical scenarios and cases
    • Daily inspection
      • Deadlock detection
      • Overview
      • Check tenant resource usage
      • Check cluster parameters
      • Check cluster resource usage
      • Check the host status
      • Check the NTP offset
      • Check the OBServer node status
      • End-to-end tracing
        • Overview
        • Process
        • Methods
        • Show end-to-end tracing information
    • Manage clusters
      • Overview
      • Cluster parameters
      • Common cluster operations
        • Delete a zone
        • Isolate a zone
        • Add a zone
        • Restart a node
        • Delete a node
        • Modify a zone
        • Modify cluster parameters
        • Isolate a node
        • Online upgrade from standalone deployment to distributed deployment
        • View cluster parameters
        • View a zone
        • Add a node
        • Start a zone
        • View a node
        • Replace a node
        • Upgrade clusters
          • Upgrade OceanBase Database Enterprise Edition
            • Overview
            • Upgrade the arbitration service
            • Upgrade an OceanBase cluster
            • Check upgrade results
          • Upgrade OceanBase Database Community Edition
            • Upgrade OceanBase Database by using OBD
      • Troubleshoot common problems
        • Failures of a minority of nodes
        • Failures of the majority of nodes
    • Security and permissions
      • Overview
      • Access control
        • Network security access control
        • Row-level access control
        • RPC connection authentication
        • Overview
        • Users and permissions
          • Overview
          • MySQL mode
            • Privilege delegation
            • Drop a user
            • Lock or unlock a user
            • Grant privileges
            • Modify user privileges
            • View user privileges
            • Create a user
            • Privilege types in MySQL mode
          • Oracle mode
            • Privilege types in Oracle mode
            • Create a user
            • Grant direct privileges
            • Privilege delegation
            • Manage roles
              • Overview
              • Create a role
              • Grant a role to another role
              • Grant a role to a user
              • Activate or deactivate roles for a user
              • View roles
              • Modify a role
              • Revoke a role
              • Drop a role
            • Grant indirect privileges
            • Query user privileges
            • Modify user privileges
            • Lock or unlock a user
            • Drop a user
      • Transparent data encryption
        • Transparent data encryption test report
        • Overview
        • MySQL mode
          • Enable transparent data encryption for existing tables
          • Decrypt a table
          • Enable transparent data encryption for new tables
        • Oracle mode
          • Decrypt a table
          • Enable transparent data encryption for existing tables
          • Enable transparent data encryption for new tables
      • Identification and authentication
        • MySQL mode
          • Identity authentication
          • Password complexity
          • Logon failure processing
        • Oracle mode
          • Identity authentication
          • Password complexity
          • Logon failure processing
      • Security audit
        • Overview
        • Enable security audit
        • Set and view audit rules
        • View audit records
        • Audit user logon operations
        • Audit user operations
        • Audit specified database objects
      • Data transmission encryption
        • Overview
        • OBServer transmission encryption
        • ODP transmission encryption
    • Backup and restore
      • Introduction to physical backup and restore
      • Deploy NFS
      • Restore by table
        • Preparations
        • Perform table restore
        • Cancel table restore
        • View the table restore progress
        • View the table restore result
        • Parameters related to table restore
        • Views related to table restore
      • Clear backup data
        • Automatically clean up expired backup data
        • Stop backup cleanup
        • Query the backup cleanup progress
        • Query the backup cleanup history
        • Backup cleanup parameter
        • Views related to backup cleanup
      • Log archive
        • Overview
        • Disable ARCHIVELOG
        • Change the log archive destination
        • View information about pieces
        • Views related to log archiving
        • View the archiving progress
        • Preparations
        • View the archiving history
        • View the archiving parameter settings
        • Enable ARCHIVELOG
      • Restore data
        • Parameters related to physical restore
        • Views related to physical restore
        • Convert a standby tenant into primary tenant
        • Cancel physical restore
        • Preparations
        • Upgrade a tenant after restore
        • View the physical restore progress
        • View physical restore results
        • Perform physical restore
        • Replay logs to a standby tenant
      • Data backup
        • Preparations
        • Initiate a full data backup job
        • Initiate an incremental data backup job
        • Stop a backup job
        • View the data backup progress
        • View the data backup history
        • View data backup parameter settings
        • Change the backup destination
        • Views related to data backup
    • Emergency response
      • Emergency response overview
      • Analysis, diagnosis, and decision-making procedure
      • Common emergency problem handling
        • Hardware issues
          • Other hardware and network issues
          • Node failure
          • ODP failure
          • Network failure
        • Capacity issues
          • Exceptions of SQL queries
          • Node disk I/O high
          • Node network card overload
          • Tenant memory full
          • obproxy thread exhaustion
          • Node clog disk full
          • Node data disk full
          • Tenant request queue backlog
        • Other cluster issues
          • Insufficiency or leakage of system memory
          • sys tenant or RootService exceptions
    • High availability
      • High availability overview
      • Multi-replica disaster recovery
        • Disaster recovery architecture and levels
        • ODP high availability
        • Database-level high availability
        • Data link introduction
      • Physical standby database disaster recovery
        • Overview
        • Limitations
        • Create a standby tenant
          • Preparations
          • Create an empty standby tenant
          • Create a standby tenant by using the backup and recovery feature
          • Create a standby tenant by using the BACKUP DATABASE PLUS ARCHIVELOG feature
        • Log transmission service
          • Overview
          • Configure log transmission service
            • Specify a log restore source
            • Set the log recovery endpoint
          • View log restore source information
          • View the log synchronization progress
          • Pause or resume log synchronization
          • Optimize the log synchronization performance
          • Set the log synchronization bandwidth limit
          • Set log synchronization compression
        • Log storage service
        • Switch roles
          • Switchover
          • Overview of tenant roles
          • Failover
        • Drop primary and standby tenants
      • Arbitration high availability
        • Overview
        • Enable the arbitration service for a tenant
        • Disable the arbitration service for a tenant
        • Modify the log stream downgrade control time
        • Replace the arbitration service for a cluster
        • Remove the arbitration service for a cluster
        • Clear residual cluster information
      • Manage recycle bin
        • Overview
        • Enable or disable the recycle bin
        • View objects in the recycle bin
        • Restore objects from the recycle bin
        • Purge the recycle bin
      • Flashback queries
    • 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
          • Manage resource isolation (Oracle mode)
            • Configure SQL statement-level resource isolation
            • Update a resource management plan config
            • Configure cgroups
            • Delete a resource management plan
            • Calibrate the disk performance
            • Configure user-level resource isolation
            • Delete a resource management plan config
            • Clear cgroup configurations
            • Delete a resource group
          • Manage resource isolation (MySQL mode)
            • Configure cgroups
            • Configure user-level resource isolation
            • Calibrate the disk performance
            • Configure SQL statement-level resource isolation
            • Update a resource management plan config
            • Delete a resource management plan config
            • Delete a resource management plan
            • Delete a resource group
            • Clear cgroup configurations
        • View tenant and resource information
        • View and set the tenant allowlist
        • View tenant system variables
        • Modify system variables of a tenant
        • Scale in/out
          • Introduction to scaling in/out
          • Modify the unit configs for a tenant
          • Modify the number of resource units for a tenant
          • Modify the number of primary zones for a tenant
        • Modify attributes of a resource pool
        • Modify attributes of a tenant
        • Lock and unlock a tenant
        • Drop a tenant
        • Recover a tenant
        • Rename a tenant
        • Manage resource pools
          • View resource pool information
          • Allocate a resource pool to a tenant
          • Remove resource pools from a tenant
          • Merge and split resource pools
          • Drop a resource pool
        • Manage unit configs
          • Query unit configs
          • Modify unit configs
          • Drop unit configs
    • Troubleshooting
      • Overview
      • Bootstrap
      • Storage
        • Minor compaction and major compaction
        • Memory-related errors
        • Migration, replication, and rebuild tasks
      • Election
        • Election
        • Leader switchover exceptions
        • Absence of the leader
      • Transaction
        • Suspended transactions
        • Long-running transactions
        • Transaction-related errors
        • Transaction rollbacks
        • Idle transactions
      • Log synchronization-related errors
      • Physical standby database
        • Log synchronization stuck for the physical standby database
        • Switchover failures
      • Backup and restore
        • Physical restore failures
        • Data backup failures
    • Monitor
      • Overview
      • Metrics
        • System monitoring
          • Overview
          • Metrics
          • Wait events
          • Latch events
        • SQL monitoring
          • Overview
          • SQL audit
          • Execution plans
      • Cases
    • Logs
      • Overview
      • Log levels
      • Log stability
      • Log control
      • Log metrics
      • 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
  • OBKV
    • Overview
    • Architecture
    • OBKV-Table
      • FAQ
      • Delete expired data
      • Use the OBKV-Table GO client
        • Aggregation API
        • Use the OBKV-Table Go client to connect to a cluster
        • About queries
        • Overview of the Go client
        • Batch operations
        • Filters
        • Individual API operations
      • Use the OBKV-Table Java client
        • Use the OBKV-Table Java client to connect to a cluster
        • Set client parameters
        • Supported client interfaces
        • Use the OBKV-Table Java client
      • OBKV-Table
        • Differences between replace and insert_or_update
        • Overview
        • OBKV-Table operation types
        • Supported value types
        • OBKV-Table data models
    • OBKV-HBase
      • Overview
      • Core features
      • Compatibility with HBase
      • Deployment
      • Use OBKV-HBase
        • Overview
        • Data model
        • Data model design
        • Connect to a cluster by using the OBKV-HBase client
        • Data operation examples
        • Delete expired data
      • OBKV-HBase management
        • Overview
        • High availability
        • Security and permissions
        • Monitoring metrics
      • Performance test
      • OBKV-HBase integration
        • Synchronize data to OBKV-HBase by using Flink
      • Views
      • FAQ
    • RPC message compression
  • Reference
    • SQL reference
      • Reserved keywords (Oracle mode)
      • Reserved keywords (MySQL mode)
      • SQL syntax
        • System tenants
          • ALTER RESOURCE UNIT
          • CREATE RESOURCE POOL
          • SET DECRYPTION
          • DROP RESOURCE UNIT
          • CREATE TENANT
          • CREATE RESOURCE UNIT
          • SET ENCRYPTION
          • ALTER RESOURCE POOL
          • ALTER RESOURCE TENANT
          • DROP TENANT
          • ALTER TENANT
          • DROP RESOURCE POOL
          • Overview
          • ALTER SYSTEM
            • ACTIVATE
            • ARCHIVELOG
            • ARBITRATION
            • BOOTSTRAP
            • BACKUP
            • BALANCE TASK
            • CANCEL MIGRATE UNIT
            • CANCEL RECOVER TABLE
            • MERGE
            • MIGRATE UNIT
            • DELETE BACKUP
            • FAILOVER
            • FLUSH PLAN CACHE
            • JOB
            • LOG RESTORE SOURCE
            • PARAMETER
            • RECOVER
            • REFRESH
            • RESTORE
            • RECOVER TABLE
            • SERVER
            • SWITCHOVER
            • THROTTLE
            • ZONE
        • User tenants (MySQL mode)
          • Basic elements
            • Data types
              • SET type
              • Overview
              • ENUM type
              • Datetime types
                • TIME type
                • DATE, DATETIME, and TIMESTAMP types
                • Overview
                • YEAR type
              • Numeric types
                • Overview
                • Integer data types
                • Fixed-point data types
                • Floating-point data types
                • Bit value data type
              • Spatial data types
                • Overview
                • SRS
                • Create a spatial column
                • Create a spatial index
                • Spatial data formats
              • Large objects and text types
                • TEXT types
                • Overview
                • BLOB types
              • JSON data types
                • Overview
                • Create a JSON value
                • Query and modify JSON values
                • Convert a JSON data type
              • String types
                • Overview
                • CHAR and VARCHAR
                • BINARY and VARBINARY
            • Expressions
              • Convert data types in expression evaluation
              • Expression syntax
              • Overview
            • Character set and collation
              • Overview
              • Character sets
              • Collations
              • Database-level character sets and collations
              • Table-level character sets and collations
              • Column-level character sets and collations
              • Character sets and collations for character expressions
              • Character sets and collations for client connection
            • Literals
              • Overview
              • Strings
              • Numbers
              • Datetime values
              • Bit values
              • Boolean values
              • NULLs
            • Schema object names
            • User-defined variables
            • Comments
          • Operators
            • Overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operators
            • Date and time operators
            • Concatenation operators
            • BINARY operator
            • CASE conditional operator
          • Sequence pseudocolumns
          • Functions
            • 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
              • String functions
                • LPAD
                • RTRIM
                • UCASE
                • REPLACE
                • LOWER
                • CONCAT_WS
                • REGEXP_SUBSTR
                • OCTET_LENGTH
                • LTRIM
                • REGEXP_REPLACE
                • REGEXP_LIKE
                • WEIGHT_STRING
                • CONCAT
                • IP2INT
                • BIN
                • RPAD
                • SUBSTRING
                • SPACE
                • FORMAT
                • MAKE_SET
                • REPEAT
                • QUOTE
                • LOCATE
                • FROM_BASE64
                • SOUNDEX
                • INSERT
                • TO_BASE64
                • OCT
                • FIELD
                • LEFT
                • CHARACTER_LENGTH
                • HEX
                • RLIKE
                • POSITION
                • REVERSE
                • STRCMP
                • REGEXP
                • BIT_LENGTH
                • EXPORT_SET
                • INSTR
                • SUBSTR
                • SUBSTRING_INDEX
                • ELT
                • REGEXP_INSTR
                • MID
                • LCASE
                • UPPER
                • ORD
                • TRIM
                • LENGTH
                • CHAR
                • FIND_IN_SET
                • CHAR_LENGTH
                • ASCII
                • RIGHT
                • UNHEX
                • INT2IP
              • Conversion functions
                • CAST
                • CONVERT
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
              • Mathematical functions
                • GENERATOR
                • RAND
                • RANDOM
                • ZIPF
                • ACOS
                • CONV
                • ABS
                • LOG2
                • TAN
                • EXP
                • LOG10
                • ATAN
                • DEGREES
                • FLOOR
                • ATAN2
                • BIT_COUNT
                • LOG
                • POWER
                • CEIL
                • SIGN
                • PI
                • MOD
                • TRUNCATE
                • RADIANS
                • NEG
                • UNIFORM
                • NORMAL
                • SQRT
                • LN
                • ASIN
                • CRC32
                • RANDSTR
                • CEILING
                • POW
                • SIN
                • ROUND
                • COT
                • COS
              • Comparison functions
                • INTERVAL
                • LEAST
                • GREATEST
                • ISNULL
              • Process control functions
                • IF
                • NULLIF
                • IFNULL
                • ORA_DECODE
                • CASE
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
            • 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
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
            • Encryption functions
              • AES_DECRYPT
              • RANDOM_BYTES
              • DES_ENCRYPT
              • COMPRESS
              • UNCOMPRESS
              • SHA1
              • SHA2
              • AES_ENCRYPT
              • DES_DECRYPT
              • ENCODE
              • UNCOMPRESSED_LENGTH
              • ENCRYPT
              • MD5
              • DECODE
              • SHA
              • VALIDATE_PASSWORD_STRENGTH
            • Information functions
              • SESSION_USER
              • SCHEMA
              • BENCHMARK
              • LAST_INSERT_ID
              • SYSTEM_USER
              • ICU_VERSION
              • CONNECTION_ID
              • COERCIBILITY
              • FOUND_ROWS
              • VERSION
              • CURRENT_USER
              • USER
              • COLLATION
              • CHARSET
              • ROW_COUNT
              • DATABASE
              • OB_VERSION
            • JSON functions
              • Overview
              • Create JSON text functions
                • JSON_OBJECT
                • JSON_QUOTE
                • JSON_ARRAY
              • Search JSON text functions
                • JSON_OVERLAPS
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • MEMBER OF
                • JSON_SEARCH
                • JSON_VALUE
              • Modify JSON text functions
                • JSON_REPLACE
                • JSON_MERGE_PATCH
                • JSON_MERGE
                • JSON_SET
                • JSON_UNQUOTE
                • JSON_REMOVE
                • JSON_INSERT
                • JSON_ARRAY_INSERT
                • JSON_ARRAY_APPEND
                • JSON_MERGE_PRESERVE
              • Return JSON text property functions
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON_TABLE
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
            • Spatial functions
              • Functions that create geometry values
              • Spatial operation functions
              • Spatial relation functions
              • Geometry property functions
              • Geometry format conversion functions
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIME
            • 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
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
          • Queries and subqueries
            • Joins
            • Overview
            • Subqueries
          • SQL statements
            • General syntax
            • CTE
            • ALTER DATABASE
            • ALTER EXTERNAL TABLE
            • ALTER OUTLINE
            • ALTER SEQUENCE
            • MERGE
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER USER
            • ALTER VIEW
            • ANALYZE
            • CREATE DATABASE
            • CREATE DATABASE LINK
            • CREATE INDEX
            • CREATE EXTERNAL TABLE
            • CREATE OUTLINE
            • DROP RESTORE POINT
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE USER
            • CREATE VIEW
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP DATABASE
            • DROP INDEX
            • DROP OUTLINE
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOCK TABLES
            • MERGE
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SELECT
              • SELECT statement
              • OVER clause
              • JOIN clause
              • UNION clause
            • SET
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET TRANSACTION
            • SHOW
            • TRANSACTION
            • TRUNCATE TABLE
            • UPDATE
            • USE
            • VALUES
          • DDL feature
            • Column type change rules
            • Generated column operations
            • Column operations
            • Foreign key operations
            • Partition operations
            • Overview
            • Online and offline DDL operations
            • Primary key operations
            • Index operations
            • Table operations
        • User tenants (Oracle mode)
          • Introduction to SQL
          • Pseudo columns
            • Sequence pseudocolumns
            • Overview
            • ORA_ROWSCN pseudocolumn
            • ROWNUM pseudocolumn
            • Hierarchical query pseudocolumns
            • ROWID pseudocolumn
          • Basic elements
            • Built-in data types
              • Overview
              • Character data types
                • CHAR data type
                • Overview
                • NVARCHAR2 data type
                • NCHAR data type
                • VARCHAR2 data type
                • VARCHAR data type
              • Numeric data types
                • Precedence of numeric data types
                • NUMBER data type
                • FLOAT data type
                • Overview
                • Floating-point numbers
              • Datetime and interval data types
                • INTERVAL YEAR TO MONTH data type
                • TIMESTAMP data type
                • TIMESTAMP WITH TIME ZONE data type
                • DATE data type
                • INTERVAL DAY TO SECOND data type
                • Calculation of dates, timestamps, and intervals
                • TIMESTAMP WITH LOCAL TIME ZONE data type
                • Overview
              • RAW data type
              • Large object data types
                • CLOB data type
                • BLOB data type
                • Overview
              • Rowid data types
              • User-defined data types
              • Any types
              • JSON data types
                • Overview
                • Create JSON columns
                • Query JSON data
                • Conversion rules for JSON data types
              • XML data types
                • Query XMLType data
                • XML data definition
                • Convert XMLType data
                • Create an XMLType column
                • Overview
            • Data type comparison rules
              • Data type conversion rules
              • Date value comparison rules
              • Overview
              • Security considerations for data conversion
              • Numeric value comparison rules
              • Data type precedence
              • Character value comparison rules
            • Literals
              • Overview
              • Text literals
              • Numeric literals
              • Datetime literals
                • Date literals
                • Timestamp literals
              • Interval literals
            • Format model
              • Number format models
              • RR datetime format element
              • Datetime format models
              • Overview
              • String-to-date conversion rules
            • NULL value
              • Overview
              • NULLs in comparison conditions
              • NULLs in SQL functions
              • NULLs in conditional expressions
            • Annotations
              • Overview
              • Comments within SQL statements
              • Comments on schema and non-schema objects
              • Hints
                • Overview
                • Hint list
                  • Hints related to access path
                  • Hints related to join orders
                  • Hints related to joins
                  • Hints related to parallel execution
                  • Hints related to query strategy
                  • Hints related to query conversion
                  • Other hints
            • Database objects
              • Schema objects
              • Non-schema objects
            • Database naming conventions
              • Suggestions on schema object names
              • Overview
            • Database object reference methods
              • Reference an attribute or method of an object type
              • Overview
              • Reference partitioned tables and indexes
              • Reference schema objects
              • Reference objects in a remote database
                • Create a DBLink
                • Reference a DBLink
            • Character sets and collations
          • Operators
            • Arithmetic operators
            • Set operators
            • COLLATE operator
            • Operator precedence
            • Overview
            • Hierarchical query operators
            • Concatenation operator
          • Functions
            • Overview
            • Single-row functions
              • Numeric functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BITAND
                • CEIL
                • COS
                • COSH
                • EXP
                • FLOOR
                • LN
                • GENERATOR
                • LOG
                • MOD
                • NANVL
                • NORMAL
                • POWER
                • REMAINDER
                • ROUND
                • RANDOM
                • RANDSTR
                • SIGN
                • SIN
                • SINH
                • SQRT
                • TAN
                • TANH
                • TRUNC
                • UNIFORM
                • WIDTH_BUCKET
                • ZIPF
              • String functions that return a string
                • CONCAT
                • INITCAP
                • CHR
                • NLS_LOWER
                • REPLACE
                • LPAD
                • SUBSTR
                • LTRIM
                • NLSSORT
                • TRANSLATE ... USING
                • TRIM
                • UPPER
                • REGEXP_REPLACE
                • TRANSLATE
                • RTRIM
                • RPAD
                • LOWER
                • NLS_UPPER
                • REGEXP_SUBSTR
              • String functions that return numbers
                • INSTR
                • LENGTH
                • ASCII
                • REGEXP_COUNT
                • REGEXP_INSTR
              • Datetime functions
                • ADD_MONTHS
                • CURRENT_DATE
                • CURRENT_TIMESTAMP
                • DBTIMEZONE
                • EXTRACT(datetime)
                • FROM_TZ
                • LAST_DAY
                • LOCALTIMESTAMP
                • MONTHS_BETWEEN
                • NEXT_DAY
                • NUMTODSINTERVAL
                • NUMTOYMINTERVAL
                • ROUND(date)
                • SESSIONTIMEZONE
                • SYS_EXTRACT_UTC
                • SYSDATE
                • SYSTIMESTAMP
                • TO_CHAR(datetime)
                • TO_DSINTERVAL
                • TO_TIMESTAMP
                • TO_TIMESTAMP_TZ
                • TO_YMINTERVAL
                • TRUNC(date)
                • TZ_OFFSET
              • Generic comparison functions
                • GREATEST
                • LEAST
              • Conversion functions
                • ASCIISTR
                • CAST
                • CHARTOROWID
                • CONVERT
                • HEXTORAW
                • NUMTODSINTERVAL
                • NUMTOYMINTERVAL
                • RAWTOHEX
                • ROWIDTOCHAR
                • ROWIDTONCHAR
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_BINARY_DOUBLE
                • TO_BINARY_FLOAT
                • TO_BLOB
                • TO_CHAR(character)
                • TO_CHAR(datetime)
                • TO_CHAR(number)
                • TO_CLOB
                • TO_DATE
                • TO_DSINTERVAL
                • TO_MULTI_BYTE
                • TO_NUMBER
                • TO_NCHAR(character)
                • TO_NCHAR(datetime)
                • TO_NCHAR(number)
                • TO_SINGLE_BYTE
                • TO_TIMESTAMP
                • TO_TIMESTAMP_TZ
                • TO_YMINTERVAL
                • UNISTR
              • Encoding and decoding functions
                • ORA_HASH
                • DECODE
                • VSIZE
                • DUMP
              • Null value related functions
                • NULLIF
                • NVL2
                • COALESCE
                • NANVL
                • NVL
                • LNNVL
              • Environment and identifier functions
                • SYS_CONTEXT
                • SYS_GUID
                • UID
                • USER
                • USERENV
                • OB_VERSION
              • Hierarchical functions
                • SYS_CONNECT_BY_PATH
              • JSON functions
                • Overview
                • Modify JSON text functions
                  • JSON_MERGEPATCH
                • Create JSON text functions
                  • JSON_ARRAY
                  • JSON_OBJECTAGG
                  • JSON_ARRAYAGG
                  • JSON_OBJECT
                • Query JSON text functions
                  • JSON_VALUE
                  • JSON_QUERY
                  • JSON_EXISTS
                  • JSON_TABLE
                • Validate JSON text functions
                  • JSON_EQUAL
              • XML functions
                • Overview
                • Construct XMLType data functions
                  • XMLAGG
                  • XMLATTRIBUTES
                  • XMLPARSE
                  • XMLELEMENT
                • Modify XMLType data functions
                  • UPDATEXML
                • Query XMLType data functions
                  • EXTRACTVALUE
                  • XMLSERIALIZE
                  • XMLCAST
                  • EXTRACT
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • CORR
              • COUNT
              • COVAR_POP
              • COVAR_SAMP
              • CUME_DIST
              • DENSE_RANK
              • GROUPING
              • KEEP
              • LISTAGG
              • MAX
              • MEDIAN
              • MIN
              • PERCENT_RANK
              • PERCENTILE_CONT
              • PERCENTILE_DISC
              • RANK
              • REGR_(Linear Regression)
              • ROLLUP
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • WMSYS.WM_CONCAT/WM_CONCAT
            • Analysis functions
              • Analytic functions
              • AVG
              • CORR
              • COUNT
              • COVAR_POP
              • COVAR_SAMP
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • KEEP
              • LAG
              • LAST_VALUE
              • LEAD
              • LISTAGG
              • MAX
              • MEDIAN
              • MIN
              • NTILE
              • NTH_VALUE
              • PERCENT_RANK
              • PERCENTILE_CONT
              • PERCENTILE_DISC
              • RANK
              • RATIO_TO_REPORT
              • REGR_(Linear Regression)
              • ROW_NUMBER
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • WMSYS.WM_CONCAT/WM_CONCAT
          • Expressions
            • Function expressions
            • Datetime expressions
            • Column expressions
            • Compound expressions
            • Scalar subquery expressions
            • Overview
            • Case expressions
            • Expression list
            • Interval expressions
            • CURSOR expressions
            • Type constructor expressions
            • Simple expressions
          • Conditions
            • Overview
            • Condition precedence
            • Comparison conditions
            • Floating-point conditions
            • Logical conditions
            • Pattern-matching conditions
            • NULL conditions
            • Compound conditions
            • BETWEEN condition
            • EXISTS condition
            • IN condition
          • Queries and subqueries
            • Overview
            • Simple query
            • Hierarchical query
            • Compound query
            • Join query
            • Subquery
            • DUAL table query
          • SQL statements
            • DDL
              • ALTER EXTERNAL TABLE
              • ALTER INDEX
              • ALTER KEYSTORE
              • ALTER OUTLINE
              • ALTER PROFILE
              • ALTER ROLE
              • ALTER SEQUENCE
              • ALTER SESSION
              • ALTER SYSTEM FLUSH PLAN CACHE
              • ALTER SYSTEM PARAMETER
              • ALTER TABLE
              • ALTER TABLEGROUP
              • ALTER USER
              • CREATE CONTEXT
              • CREATE DIRECTORY
              • CREATE DATABASE LINK
              • CREATE EXTERNAL TABLE
              • CREATE INDEX
              • CREATE KEYSTORE
              • CREATE OUTLINE
              • CREATE PROFILE
              • CREATE ROLE
              • CREATE SEQUENCE
              • CREATE SYNONYM
              • CREATE TABLE
              • CREATE TABLEGROUP
              • CREATE TABLESPACE
              • CREATE USER
              • CREATE VIEW
              • DROP CONTEXT
              • DROP DATABASE LINK
              • DROP DIRECTORY
              • DROP INDEX
              • DROP OUTLINE
              • DROP PROFILE
              • DROP ROLE
              • DROP SEQUENCE
              • DROP SYNONYM
              • DROP TABLE
              • DROP TABLEGROUP
              • DROP TABLESPACE
              • DROP USER
              • DROP VIEW
              • RENAME
              • TRUNCATE TABLE
              • ALTER SYSTEM MAJOR FREEZE
            • DML
              • UPDATE
              • MERGE
              • PURGE
              • EXPLAIN
              • INSERT
              • DELETE
              • SELECT
                • Set-based SELECT
                • SIMPLE SELECT
                • WITH clause
            • DCL
              • ANALYZE
              • ALTER SYSTEM KILL SESSION
              • AUDIT
              • COMMENT
              • COMMIT
              • FLASHBACK TABLE BEFORE DROP
              • GRANT
              • KILL
              • LOAD DATA
              • LOCK TABLE
              • REVOKE
              • ROLLBACK
              • SAVEPOINT
              • SET NAMES
              • SET PASSWORD
              • SET ROLE
              • SET VARIABLE
              • SHOW
              • SHRINK
              • TRANSACTION
          • DDL feature
            • Overview
            • Online and offline DDL operations
            • Index operations
            • Primary key operations
            • Column operations
            • Generated column operations
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
      • PL reference
        • What is PL
          • PL architecture
          • Overview
          • Main features of PL
        • PL reference (MySQL mode)
          • Syntax of PL stored programs
          • PL stored procedures
            • Overview
            • Variables in stored programs
            • Stored procedures
            • Stored functions
            • Triggers
            • Limitations on stored programs
          • PL cursors
            • Overview
            • Cursor execution process
            • Limitations on server 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 TRIGGERS
            • SHOW CREATE TRIGGER
            • SHOW FUNCTION STATUS
            • SHOW CREATE FUNCTION
            • SHOW PROCEDURE STATUS
            • SHOW CREATE PROCEDURE
          • PL related dictionary views
            • INFORMATION_SCHEMA ROUTINES
            • INFORMATION_SCHEMA PARAMETERS
            • INFORMATION_SCHEMA TRIGGERS
          • PL exception handling
            • Overview
            • DECLARE ... CONDITION
            • DECLARE ... HANDLER
            • GET DIAGNOSTICS
            • RESIGNAL
            • SIGNAL
            • Effective scope of an exception handler
            • Diagnostics area
            • Exception handling and OUT/INOUT parameters
            • Limitations on exception handling
          • PL system packages
            • Overview
            • DBMS_RESOURCE_MANAGER
              • CREATE_PLAN
              • DELETE_PLAN_DIRECTIVE
              • DELETE_CONSUMER_GROUP
              • SET_CONSUMER_GROUP_MAPPING
              • CREATE_CONSUMER_GROUP
              • DELETE_PLAN
              • Overview
              • CREATE_PLAN_DIRECTIVE
              • UPDATE_PLAN_DIRECTIVE
            • DBMS_STATS
              • GET_PREFS
              • CREATE_STAT_TABLE
              • DROP_STAT_TABLE
              • SET_TABLE_PREFS
              • GET_STATS_HISTORY_AVAILABILITY
              • GATHER_SCHEMA_STATS
              • SET_TABLE_STATS
              • DELETE_COLUMN_STATS
              • UNLOCK_SCHEMA_STATS
              • SET_PARAM
              • IMPORT_SCHEMA_STATS
              • RESET_PARAM_DEFAULTS
              • GET_PARAM
              • DELETE_TABLE_PREFS
              • GET_STATS_HISTORY_RETENTION
              • DELETE_TABLE_STATS
              • DELETE_INDEX_STATS
              • EXPORT_INDEX_STATS
              • FLUSH_DATABASE_MONITORING_INFO
              • DELETE_SCHEMA_STATS
              • UNLOCK_PARTITION_STATS
              • Overview
              • SET_GLOBAL_PREFS
              • ALTER_STATS_HISTORY_RETENTION
              • SET_INDEX_STATS
              • RESTORE_TABLE_STATS
              • IMPORT_TABLE_STATS
              • UNLOCK_TABLE_STATS
              • EXPORT_TABLE_STATS
              • IMPORT_COLUMN_STATS
              • DELETE_SCHEMA_PREFS
              • IMPORT_INDEX_STATS
              • LOCK_TABLE_STATS
              • SET_SCHEMA_PREFS
              • GATHER_INDEX_STATS
              • RESET_GLOBAL_PREF_DEFAULTS
              • EXPORT_COLUMN_STATS
              • LOCK_SCHEMA_STATS
              • RESTORE_SCHEMA_STATS
              • EXPORT_SCHEMA_STATS
              • PURGE_STATS
              • GATHER_TABLE_STATS
              • LOCK_PARTITION_STATS
              • SET_COLUMN_STATS
            • DBMS_XPLAN
              • DISPLAY_ACTIVE_SESSION_PLAN
              • DISABLE_OPT_TRACE
              • DISPLAY
              • DISPLAY_CURSOR
              • ENABLE_OPT_TRACE
              • SET_OPT_TRACE_PARAMETER
              • Overview
              • DISPLAY_SQL_PLAN_BASELINE
            • DBMS_UDR
              • CREATE_RULE
              • DISABLE_RULE
              • Overview
              • ENABLE_RULE
              • REMOVE_RULE
            • DBMS_WORKLOAD_REPOSITORY
              • Overview
              • ASH_REPORT
              • CREATE_SNAPSHOT
              • DROP_SNAPSHOT_RANGE
              • MODIFY_SNAPSHOT_SETTINGS
          • Reserved and non-reserved PL keywords
        • PL reference (Oracle mode)
          • PL language basics
            • Character sets
            • Lexical units
            • Declaration
            • Quote identifiers
            • Scope and visibility of identifiers
            • Assign values
            • Expressions
            • PL blocks
            • Subprograms
            • Error-reporting functions
          • PL data types
            • Overview
            • SQL data types
            • LOB data types
            • BOOLEAN type
            • User-defined subtypes
            • PLS_INTEGER and BINARY_INTEGER
            • Arrays
            • PL JSON data types
          • PL process control
            • Overview
            • Sequential control
            • Loop control
            • Conditional control
          • PL collections and records
            • Overview
            • Collections
            • Associative arrays
            • Varrays
            • Nested tables
            • Collection constructor function
            • Collection methods
              • COUNT method
              • EXISTS method
              • EXTEND method
              • FIRST and LAST methods
              • Overview
              • DELETE method
              • TRIM method
              • LIMIT method
              • PRIOR and NEXT methods
            • Records
            • Insert records into a table and update a table by using records
            • Create and call a subprogram with record type parameters
          • PL static SQL
            • Transaction processing and control
            • Overview
            • Cursors
              • Overview
              • Cursor attributes
              • Implicit cursors
              • Explicit cursors
              • Cursor variables
              • Traverse cursor data by using the FOR loop
              • Modify and drop a cursor
            • Autonomous transactions
              • Overview
              • Control an autonomous transaction
              • Autonomous triggers
              • Call autonomous functions from SQL statements
          • PL dynamic SQL
            • DBMS_SQL system package
            • Execute dynamic SQL statements
            • Overview
          • PL stored procedures and functions
            • Overview
            • Create a stored procedure
            • Create a function
            • Manage stored procedures and functions
            • Privilege control
            • Pipeline functions
              • Overview
              • Create a pipelined function
              • Application
            • User-defined functions
              • Overview
              • Interface for user-defined aggregate functions
              • Create user-defined aggregate functions
              • Use user-defined aggregate functions
            • Collection of stored procedure information and its impact on parallel execution of SQL statements
            • PL DBLink
          • PL triggers
            • Query trigger information
            • INSTEAD OF DML trigger
            • Create a DML trigger
            • Overview
            • Disable or enable a trigger
            • Modify and drop a trigger
            • Compound DML trigger
          • PL packages
            • Create a program package
            • Manage program packages
            • Definition of the PL environment by the STANDARD package
            • Overview
            • Overloaded programs in a package
          • PL exception handling
            • Overview
            • Compile-Time alerts
            • Exception types
            • Exception handling processes
          • DDL operations on stored PL units
            • Overview
            • DROP FUNCTION
            • CREATE PACKAGE BODY
            • CREATE TRIGGER
            • DROP TYPE BODY
            • CREATE FUNCTION
            • CREATE PACKAGE
            • CREATE PROCEDURE
            • DROP TYPE
            • DROP PROCEDURE
            • DROP TRIGGER
            • ALTER PACKAGE
            • CREATE TYPE
            • DROP PACKAGE
            • ALTER TRIGGER
            • ALTER PROCEDURE
            • CREATE TYPE BODY
            • ALTER TYPE
            • ALTER FUNCTION
          • PL label security package
            • Overview
            • SA_SESSION session management package
              • Overview
              • SA_SESSION.LABEL
              • SA_SESSION.RESTORE_DEFAULT_LABELS
              • SA_SESSION.ROW_LABEL
              • SA_SESSION.SET_LABEL
              • SA_SESSION.SET_ROW_LABEL
            • SA_LABEL_ADMIN label management package
              • SA_LABEL_ADMIN.ALTER_LABEL
              • SA_LABEL_ADMIN.CREATE_LABEL
              • SA_LABEL_ADMIN.DROP_LABEL
              • Overview
            • SA_POLICY_ADMIN policy management package
              • Overview
              • SA_POLICY_ADMIN.APPLY_TABLE_POLICY
              • SA_POLICY_ADMIN.DISABLE_TABLE_POLICY
              • SA_POLICY_ADMIN.REMOVE_TABLE_POLICY
              • SA_POLICY_ADMIN.ENABLE_TABLE_POLICY
            • SA_USER_ADMIN user label management package
              • Overview
              • SA_USER_ADMIN.SET_LEVELS
            • SA_SYSDBA policy management package
              • Overview
              • SA_SYSDBA.ALTER_POLICY
              • SA_SYSDBA.DROP_POLICY
              • SA_SYSDBA.CREATE_POLICY
            • SA_COMPONENTS label component package
              • Overview
              • SA_COMPONENTS.ALTER_LEVEL
              • SA_COMPONENTS.CREATE_LEVEL
              • SA_COMPONENTS.DROP_LEVEL
          • PL system package (Oracle mode)
            • Overview
            • DBMS_APPLICATION_INFO
              • Overview
              • READ_CLIENT_INFO
              • READ_MODULE
              • SET_ACTION
              • SET_CLIENT_INFO
              • SET_MODULE
            • DBMS_AUDIT_MGMT
              • CLEAN_AUDIT_TRAIL
              • SET_LAST_ARCHIVE_TIMESTAMP
              • SET_PURGE_JOB_STATUS
              • Overview
              • CREATE_PURGE_JOB
              • DROP_PURGE_JOB
            • DBMS_CRYPTO
              • Overview
              • ENCRYPT
              • DECRYPT
              • HASH
            • DBMS_DEBUG
              • Overview
              • ATTACH_SESSION
              • CONTINUE
              • DEBUG_ON
              • DEBUG_OFF
              • DETACH_SESSION
              • DELETE_BREAKPOINT
              • DISABLE_BREAKPOINT
              • ENABLE_BREAKPOINT
              • GET_VALUE
              • GET_VALUES
              • GET_RUNTIME_INFO
              • GET_TIMEOUT_BEHAVIOUR
              • INITIALIZE
              • PROBE_VERSION
              • PRINT_BACKTRACE
              • SET_TIMEOUT
              • SET_TIMEOUT_BEHAVIOUR
              • SET_BREAKPOINT
              • SHOW_BREAKPOINTS
            • DBMS_DESCRIBE
              • Overview
              • DESCRIBE_PROCEDURE
            • DBMS_JOB
              • RUN
              • Overview
              • SUBMIT
              • INTERVAL
              • BROKEN
              • ZONE
              • WHAT
              • USER_EXPORT
              • REMOVE
              • NEXT_DATE
              • CHANGE
            • DBMS_LOB
              • Overview
              • APPEND
              • CLOSE
              • COPY
              • CREATETEMPORARY
              • ERASE
              • FREETEMPORARY
              • GETLENGTH
              • ISOPEN
              • INSTR
              • ISTEMPORARY
              • OPEN
              • READ
              • SUBSTR
              • TRIM
              • WRITE
              • WRITEAPPEND
            • DBMS_LOCK
              • Overview
              • ALLOCATE_UNIQUE
              • ALLOCATE_UNIQUE_AUTONOMOUS
              • REQUEST
              • SLEEP
            • DBMS_METADATA
              • Overview
              • GET_DDL
            • DBMS_OUTPUT
              • Overview
              • DISABLE
              • ENABLE
              • GET_LINE
              • GET_LINES
              • NEW_LINE
              • PUT
              • PUT_LINE
            • DBMS_PLAN_CACHE
              • PURGE
              • Overview
            • DBMS_RANDOM
              • TERMINATE
              • STRING
              • Overview
              • RANDOM
              • NORMAL
              • SEED
              • INITIALIZE
              • VALUE
            • DBMS_RESOURCE_MANAGER
              • Overview
              • CREATE_CONSUMER_GROUP
              • CREATE_PLAN
              • CREATE_PLAN_DIRECTIVE
              • DELETE_CONSUMER_GROUP
              • DELETE_PLAN
              • DELETE_PLAN_DIRECTIVE
              • SET_CONSUMER_GROUP_MAPPING
              • UPDATE_PLAN_DIRECTIVE
            • DBMS_SCHEDULER
              • Overview
              • SET_ATTRIBUTE
              • DROP_JOB
              • DISABLE
              • SET_JOB_ARGUMENT_VALUE
              • GENERATE_JOB_NAME
              • ENABLE
              • RUN_JOB
              • DROP_PROGRAM
              • CREATE_PROGRAM
              • DEFINE_PROGRAM_ARGUMENT
              • CREATE_JOB
            • DBMS_SESSION
              • Overview
              • CLEAR_ALL_CONTEXT
              • CLEAR_CONTEXT
              • CLEAR_IDENTIFIER
              • RESET_PACKAGE
              • SET_CONTEXT
              • SET_IDENTIFIER
            • DBMS_SQL
              • DEFINE_ARRAY
              • EXECUTE_AND_FETCH
              • DESCRIBE_COLUMNS
              • Overview
              • BIND_VARIABLE
              • OPEN_CURSOR
              • EXECUTE
              • COLUMN_VALUE
              • CLOSE_CURSOR
              • LAST_ERROR_POSITION
              • IS_OPEN
              • DEFINE_COLUMN
              • PARSE
              • FETCH_ROWS
            • DBMS_STATS
              • Overview
              • ALTER_STATS_HISTORY_RETENTION
              • CREATE_STAT_TABLE
              • DELETE_COLUMN_STATS
              • DELETE_INDEX_STATS
              • DELETE_TABLE_STATS
              • DELETE_SCHEMA_STATS
              • DELETE_SCHEMA_PREFS
              • DELETE_TABLE_PREFS
              • DROP_STAT_TABLE
              • EXPORT_COLUMN_STATS
              • EXPORT_INDEX_STATS
              • EXPORT_TABLE_STATS
              • EXPORT_SCHEMA_STATS
              • FLUSH_DATABASE_MONITORING_INFO
              • GATHER_INDEX_STATS
              • GATHER_TABLE_STATS
              • GATHER_SCHEMA_STATS
              • 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_PARTITION_STATS
              • LOCK_SCHEMA_STATS
              • LOCK_TABLE_STATS
              • RESTORE_TABLE_STATS
              • RESTORE_SCHEMA_STATS
              • RESET_GLOBAL_PREF_DEFAULTS
              • RESET_PARAM_DEFAULTS
              • PURGE_STATS
              • SET_COLUMN_STATS
              • SET_INDEX_STATS
              • SET_TABLE_STATS
              • SET_GLOBAL_PREFS
              • SET_PARAM
              • SET_SCHEMA_PREFS
              • SET_TABLE_PREFS
              • UNLOCK_PARTITION_STATS
              • UNLOCK_SCHEMA_STATS
              • UNLOCK_TABLE_STATS
            • DBMS_UDR
              • Overview
              • CREATE_RULE
              • DISABLE_RULE
              • ENABLE_RULE
              • REMOVE_RULE
            • DBMS_UTILITY
              • IS_CLUSTER_DATABASE
              • OLD_CURRENT_SCHEMA
              • GET_SQL_HASH
              • FORMAT_ERROR_BACKTRACE
              • DB_VERSION
              • FORMAT_ERROR_STACK
              • GET_ENDIANNESS
              • ACTIVE_INSTANCES
              • Overview
              • GET_HASH_VALUE
              • GET_PARAMETER_VALUE
              • PORT_STRING
              • TABLE_TO_COMMA
              • NAME_RESOLVE
              • COMMA_TO_TABLE
              • GET_TIME
              • IS_BIT_SET
              • OLD_CURRENT_USER
              • FORMAT_CALL_STACK
              • NAME_TOKENIZE
              • CURRENT_INSTANCE
            • DBMS_WORKLOAD_REPOSITORY
              • Overview
              • ASH_REPORT
            • DBMS_XA
              • DBMS_XA_XID object type
              • XA_RECOVER
              • DBMS_XA constants
              • XA_PREPARE
              • XA_SETTIMEOUT
              • XA_GETLASTOER
              • XA_START
              • XA_END
              • XA_ROLLBACK
              • XA_FORGET
              • Overview
              • DIST_TXN_SYNC
              • XA_COMMIT
            • DBMS_XMLGEN
              • Overview
              • CONVERT
            • DBMS_XPLAN
              • Overview
              • DISPLAY_ACTIVE_SESSION_PLAN
              • DISPLAY_CURSOR
              • DISPLAY
              • DISABLE_OPT_TRACE
              • DISPLAY_SQL_PLAN_BASELINE
              • ENABLE_OPT_TRACE
              • SET_OPT_TRACE_PARAMETER
            • ODCIConst
              • ODCIStatsOptions.Options
              • ODCIIndexInfo.IndexParaDegree
              • ODCIEnv.CallProperty
              • Overview
              • ODCIIndexInfo.IndexInfoFlags
              • ODCIIndexAlter
              • ODCIStatsOptions.Flags
              • ScnFlg
              • ODCIIndexAlter parameter alter_option
              • ODCIArgDesc.ArgType
              • ODCIPredInfo.Flags
              • ODCIQueryInfo.Flags
              • Return Status
              • ODCIEnv.Envflags
            • UTL_ENCODE
              • Overview
              • BASE64_DECODE
              • BASE64_ENCODE
            • UTL_FILE
              • Overview
              • FCLOSE
              • FFLUSH
              • FOPEN
              • FGETPOS
              • FREMOVE
              • FRENAME
              • FSEEK
              • NEW_LINE
              • GET_LINE
              • PUT
              • PUT_LINE
            • UTL_I18N
              • Overview
              • RAW_TO_CHAR
              • STRING_TO_RAW
            • UTL_RAW
              • BIT_AND
              • CAST_TO_VARCHAR2
              • CAST_TO_BINARY_FLOAT
              • Overview
              • CAST_TO_RAW
              • CAST_FROM_BINARY_DOUBLE
              • BIT_OR
              • REVERSE
              • CAST_FROM_BINARY_FLOAT
              • CAST_TO_BINARY_DOUBLE
              • COMPARE
              • CONCAT
              • CAST_FROM_BINARY_INTEGER
              • BIT_XOR
              • CAST_FROM_NUMBER
              • CAST_TO_BINARY_INTEGER
              • SUBSTR
              • BIT_COMPLEMENT
              • COPIES
              • LENGTH
              • CAST_TO_NUMBER
            • ANYDATA TYPE
              • Overview
              • BEGINCREATE static procedure
              • ENDCREATE member procedure
              • GET* member functions
              • GETTYPE member function
              • GETTYPENAME member function
              • PIECEWISE member procedure
              • SET* member procedures
            • XMLType
              • CREATEXML
              • XMLTYPE
              • GETSTRINGVAL
              • Overview
              • TRANSFORM
              • GETCLOBVAL
          • Reserved PL keywords
      • SQL specifications and practices
        • Limitations on writing SQL statements
        • SQL writing specifications
          • Transactions
          • Table scan
          • SELECT statements
          • Multi-table join statements
          • Cache
          • Hint
          • DML statements
          • Others
        • SQL statement examples
          • Implicit data type conversion
          • JOIN tables
          • Weak consistency read
          • Pagination queries
    • System views
      • Overview
      • Overview of system views
      • Changes in views in OceanBase Database V3.x and V4.x
      • SYS tenant views
        • Dictionary views
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • oceanbase.CDB_INDEXES
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SUBPART_KEY_COLUMNS
          • oceanbase.CDB_SUBPARTITION_TEMPLATES
          • oceanbase.CDB_TAB_COL_STATISTICS
          • oceanbase.CDB_TAB_COLS
          • oceanbase.CDB_TAB_COLS_V$
          • oceanbase.CDB_TAB_PARTITIONS
          • oceanbase.CDB_TAB_SUBPARTITIONS
          • oceanbase.CDB_TABLES
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • information_schema.QUERY_RESPONSE_TIME
          • oceanbase.CDB_OB_LS
          • oceanbase.DBA_OB_LS
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_OB_USERS
          • oceanbase.CDB_OB_USERS
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_ARBITRATION_SERVICE
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_DB_LINKS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.CDB_WR_SNAPSHOT
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.CDB_WR_STATNAME
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.CDB_WR_SYSSTAT
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.CDB_WR_CONTROL
          • oceanbase.CDB_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.CDB_OB_KV_TTL_TASKS
          • oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
        • Performance views
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_KVCACHE
          • GV$OB_PARAMETERS
          • GV$OB_PROCESSLIST
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_SERVERS
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_UNITS
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$SESSION_EVENT
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SYSTEM_EVENT
          • GV$SESSTAT
          • GV$OB_IO_BENCHMARK
          • GV$OB_SQL_AUDIT
          • GV$LATCH
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_RPC_OUTGOING
          • GV$OB_RPC_INCOMING
          • GV$SQL_PLAN_MONITOR
          • GV$SYSSTAT
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$SESSION_LONGOPS
          • GV$OB_PX_WORKER_STAT
          • GV$OB_PS_STAT
          • GV$OB_PS_ITEM_INFO
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_SSTABLES
          • GV$OB_TENANT_MEMORY
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_KVCACHE
          • V$OB_PARAMETERS
          • V$OB_PROCESSLIST
          • V$OB_PX_TARGET_MONITOR
          • V$OB_SERVERS
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_UNITS
          • V$STATNAME
          • V$EVENT_NAME
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SYSTEM_EVENT
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_SQL_AUDIT
          • V$OB_RPC_OUTGOING
          • V$OB_RPC_INCOMING
          • V$SQL_PLAN_MONITOR
          • V$SESSION_LONGOPS
          • V$LATCH
          • V$OB_PX_WORKER_STAT
          • V$OB_PS_STAT
          • V$OB_PS_ITEM_INFO
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_MERGE_INFO
          • V$SQL_MONITOR_STATNAME
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_SSTABLES
          • V$OB_TENANT_MEMORY
          • GV$SQL_WORKAREA_ACTIVE
          • GV$OB_MEMSTORE_INFO
          • V$OB_MEMSTORE_INFO
          • GV$OB_IO_CALIBRATION_STATUS
          • V$OB_IO_CALIBRATION_STATUS
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_IO_BENCHMARK
          • V$SYSSTAT
          • V$SESSION_EVENT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • GV$OB_LOG_STAT
          • V$OB_LOG_STAT
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_ARCHIVE_DEST_STATUS
          • V$RSRC_PLAN
          • GV$OB_THREAD
          • V$OB_THREAD
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_LOCKS
          • V$OB_LOCKS
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_TIMESTAMP_SERVICE
          • GV$OB_PX_P2P_DATAHUB
          • V$OB_PX_P2P_DATAHUB
          • GV$SQL_JOIN_FILTER
          • V$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • V$OB_SQL_PLAN
          • GV$OB_TENANT_RUNTIME_INFO
          • V$OB_TENANT_RUNTIME_INFO
          • GV$OB_FLT_TRACE_CONFIG
      • MySQL tenant views
        • Performance views
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_KVCACHE
          • GV$OB_PARAMETERS
          • GV$OB_PROCESSLIST
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_SERVERS
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_UNITS
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$SESSION_EVENT
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SYSTEM_EVENT
          • GV$SESSTAT
          • GV$OB_SQL_AUDIT
          • GV$LATCH
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_RPC_OUTGOING
          • GV$OB_RPC_INCOMING
          • GV$SQL_PLAN_MONITOR
          • GV$SESSION_LONGOPS
          • GV$OB_PX_WORKER_STAT
          • GV$OB_PS_STAT
          • GV$OB_PS_ITEM_INFO
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_SSTABLES
          • GV$OB_TENANT_MEMORY
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_KVCACHE
          • V$OB_PARAMETERS
          • V$OB_PROCESSLIST
          • V$OB_PX_TARGET_MONITOR
          • V$OB_SERVERS
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_UNITS
          • V$STATNAME
          • V$EVENT_NAME
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SYSTEM_EVENT
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_SQL_AUDIT
          • V$OB_RPC_OUTGOING
          • V$OB_RPC_INCOMING
          • V$SQL_PLAN_MONITOR
          • V$SESSION_LONGOPS
          • V$LATCH
          • V$OB_PX_WORKER_STAT
          • V$OB_PS_STAT
          • V$OB_PS_ITEM_INFO
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_MERGE_INFO
          • V$SQL_MONITOR_STATNAME
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_SSTABLES
          • V$OB_TENANT_MEMORY
          • GV$SQL_WORKAREA_ACTIVE
          • GV$OB_MEMSTORE_INFO
          • V$OB_MEMSTORE_INFO
          • GV$OB_IO_CALIBRATION_STATUS
          • V$OB_IO_CALIBRATION_STATUS
          • GV$OB_IO_BENCHMARK
          • V$OB_IO_BENCHMARK
          • GV$SYSSTAT
          • V$SYSSTAT
          • V$SESSION_EVENT
          • GV$ACTIVE_SESSION_HISTORY
          • V$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • V$DML_STATS
          • GV$OB_LOG_STAT
          • V$OB_LOG_STAT
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_ARCHIVE_DEST_STATUS
          • V$RSRC_PLAN
          • GV$OB_THREAD
          • V$OB_THREAD
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_LOCKS
          • V$OB_LOCKS
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_TIMESTAMP_SERVICE
          • GV$OB_PX_P2P_DATAHUB
          • V$OB_PX_P2P_DATAHUB
          • GV$SQL_JOIN_FILTER
          • V$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • V$OB_SQL_PLAN
        • Dictionary views
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATIONS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLUMNS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.ENGINES
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLES
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.db
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_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_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • information_schema.QUERY_RESPONSE_TIME
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
      • Oracle tenant views
        • Dictionary views
          • DBA_PART_TABLES
          • DBA_INDEXES
          • DBA_OB_DATA_DICTIONARY_IN_LOG
          • USER_IND_PARTITIONS
          • USER_TRIGGERS
          • USER_DB_LINKS
          • DBA_OB_TRANSFER_TASK_HISTORY
          • DBA_SCHEDULER_PROGRAM
          • DBA_OB_FREEZE_INFO
          • DBA_SYS_PRIVS
          • ALL_SCHEDULER_JOB_ARGS
          • DBA_RSRC_CONSUMER_GROUPS
          • DBA_OB_TENANT_EVENT_HISTORY
          • ALL_PART_INDEXES
          • DBA_RSRC_PLANS
          • DBA_OB_IMPORT_TABLE_TASKS
          • DBA_SCHEDULER_WINDOWS
          • USER_POLICY_CONTEXTS
          • ALL_POLICY_CONTEXTS
          • DBA_METHOD_PARAMS
          • DBA_OB_RECOVER_TABLE_JOBS
          • DBA_OBJ_AUDIT_OPTS
          • USER_OBJECTS
          • NLS_SESSION_PARAMETERS
          • DBA_OB_TABLET_REPLICAS
          • ALL_TYPE_METHODS
          • ALL_PART_TABLES
          • ALL_METHOD_PARAMS
          • USER_PROCEDURES
          • DBA_CONTEXT
          • ALL_CONS_COLUMNS
          • DBA_IND_STATISTICS
          • ALL_SUBPART_COL_STATISTICS
          • ALL_TRIGGER_ORDERING
          • DBA_TABLESPACES
          • DBA_OB_CONCURRENT_LIMIT_SQL
          • USER_SEC_RELEVANT_COLS
          • DBA_RSRC_PLAN_DIRECTIVES
          • ROLE_SYS_PRIVS
          • USER_COL_PRIVS
          • USER_RECYCLEBIN
          • DBA_OB_EXTERNAL_TABLE_FILES
          • ALL_SUBPART_HISTOGRAMS
          • ALL_CONSTRAINTS
          • USER_ERRORS
          • DBA_OB_TABLE_LOCATIONS
          • DBA_TYPE_METHODS
          • USER_AUDIT_TRAIL
          • USER_TAB_MODIFICATIONS
          • DBA_PART_INDEXES
          • DBA_USERS
          • DBA_SQL_MANAGEMENT_CONFIG
          • USER_POLICY_GROUPS
          • USER_TAB_COMMENTS
          • DBA_OB_BACKUP_DELETE_TASKS
          • DBA_OB_LOG_RESTORE_SOURCE
          • ALL_DB_LINKS
          • DBA_TYPES
          • USER_TABLES
          • DICT
          • DBA_OB_ARCHIVE_DEST
          • DBA_DB_LINKS
          • DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • DBA_IND_PARTITIONS
          • DBA_SUBPARTITION_TEMPLATES
          • DBA_OB_ACCESS_POINT
          • DBA_TYPE_ATTRS
          • USER_SYNONYMS
          • USER_TAB_STATS_HISTORY
          • DBA_IND_EXPRESSIONS
          • USER_COL_COMMENTS
          • ALL_TAB_HISTOGRAMS
          • USER_TAB_PARTITIONS
          • DBA_OB_LS_REPLICA_TASKS
          • DBA_POLICIES
          • DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • DBA_OB_ARCHIVELOG_PIECE_FILES
          • USER_TYPE_METHODS
          • DBA_WR_SYSSTAT
          • USER_DEPENDENCIES
          • USER_ROLE_PRIVS
          • ALL_TAB_COLS
          • ALL_TRIGGERS
          • ALL_POLICIES
          • DBA_IND_SUBPARTITIONS
          • DBA_SUBPART_COL_STATISTICS
          • USER_SCHEDULER_JOB_ARGS
          • ALL_PROCEDURES
          • DBA_AUDIT_STATEMENT
          • DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • DBA_AUDIT_SESSION
          • DBA_TRIGGERS
          • DBA_OB_BACKUP_DELETE_JOBS
          • USER_SYS_PRIVS
          • DBA_PART_KEY_COLUMNS
          • STMT_AUDIT_OPTION_MAP
          • USER_AUDIT_OBJECT
          • DBA_AUDIT_EXISTS
          • ALL_POLICY_GROUPS
          • DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • ALL_OB_EXTERNAL_TABLE_FILES
          • DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • DBA_AUDIT_TRAIL
          • ALL_ALL_TABLES
          • ALL_TYPES
          • DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • ALL_PART_COL_STATISTICS
          • DBA_SUBPART_KEY_COLUMNS
          • ALL_IND_COLUMNS
          • DBA_OB_OUTLINES
          • DBA_OB_MAJOR_COMPACTION
          • DBA_SQL_PLAN_BASELINES
          • DBA_OB_BALANCE_TASKS
          • DBA_SCHEDULER_PROGRAM_ARGS
          • DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • USER_SEQUENCES
          • USER_PART_HISTOGRAMS
          • USER_INDEXES
          • DBA_TAB_COLUMNS
          • DBA_ROLES
          • DBA_POLICY_CONTEXTS
          • USER_JOBS
          • TENANT_VIRTUAL_SESSION_VARIABLE
          • USER_AUDIT_STATEMENT
          • DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • USER_TRIGGER_ORDERING
          • USER_PART_COL_STATISTICS
          • ALL_SOURCE
          • DBA_STMT_AUDIT_OPTS
          • ALL_TAB_SUBPARTITIONS
          • ALL_TYPE_ATTRS
          • DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • DBA_OB_DEADLOCK_EVENT_HISTORY
          • DBA_RSRC_GROUP_MAPPINGS
          • DBA_OB_RSRC_IO_DIRECTIVES
          • USER_TAB_COL_STATISTICS
          • DBA_DEPENDENCIES
          • DBA_TAB_PRIVS
          • DBA_CONS_COLUMNS
          • DBA_TAB_COL_STATISTICS
          • USER_SUBPART_KEY_COLUMNS
          • DBA_WR_ACTIVE_SESSION_HISTORY
          • DBA_TAB_MODIFICATIONS
          • DBA_CONSTRAINTS
          • DBA_OB_TABLEGROUP_TABLES
          • DBA_COLL_TYPES
          • DBA_OB_BACKUP_TASK_HISTORY
          • DBA_OB_ARCHIVELOG_SUMMARY
          • USER_SUBPART_COL_STATISTICS
          • DBA_TAB_COMMENTS
          • DBA_VIEWS
          • USER_TAB_SUBPARTITIONS
          • ALL_PART_HISTOGRAMS
          • DBA_JOBS_RUNNING
          • DBA_SEQUENCES
          • DBA_TAB_SUBPARTITIONS
          • USER_SOURCE
          • ALL_SCHEDULER_PROGRAM_ARGS
          • DBA_OB_BACKUP_TASKS
          • ALL_PART_KEY_COLUMNS
          • ALL_IND_SUBPARTITIONS
          • ROLE_TAB_PRIVS
          • DBA_SUBPART_HISTOGRAMS
          • DBA_OB_TABLEGROUP_SUBPARTITIONS
          • DBA_OB_USER_DEFINED_RULES
          • USER_TAB_COLUMNS
          • USER_TYPES
          • USER_IND_COLUMNS
          • ALL_TAB_PRIVS
          • ALL_IND_PARTITIONS
          • DBA_TAB_STATS_HISTORY
          • DBA_TAB_STATISTICS
          • USER_TYPE_ATTRS
          • ALL_TAB_COL_STATISTICS
          • USER_SUBPART_HISTOGRAMS
          • USER_TAB_STATISTICS
          • ALL_OBJECTS
          • DBA_OBJECTS
          • ALL_TAB_STATS_HISTORY
          • DBA_TAB_HISTOGRAMS
          • DBA_RECYCLEBIN
          • USER_TAB_COLS
          • DBA_PROCEDURES
          • DBA_OB_BACKUP_STORAGE_INFO
          • DBA_OB_BALANCE_TASK_HISTORY
          • ALL_DIRECTORIES
          • DBA_ARGUMENTS
          • DICTIONARY
          • DBA_OB_LS_HISTORY
          • ALL_COL_PRIVS
          • USER_SEGMENTS
          • USER_CONSTRAINTS
          • DBA_OB_BACKUP_DELETE_POLICY
          • USER_PROFILES
          • DBA_SEC_RELEVANT_COLS
          • ALL_TAB_COMMENTS
          • DBA_OB_BALANCE_JOBS
          • DBA_OB_TABLEGROUPS
          • DBA_WR_STATNAME
          • DBA_PROFILES
          • DBA_OB_BALANCE_JOB_HISTORY
          • DBA_SYNONYMS
          • ALL_TAB_MODIFICATIONS
          • ROLE_ROLE_PRIVS
          • DBA_WR_SNAPSHOT
          • DBA_OB_DATABASES
          • DBA_OB_TABLET_TO_LS
          • ALL_INDEXES
          • USER_TAB_HISTOGRAMS
          • DBA_ALL_TABLES
          • DBA_IND_COLUMNS
          • DBA_PART_COL_STATISTICS
          • DBA_ROLE_PRIVS
          • DBA_OB_ZONE_MAJOR_COMPACTION
          • USER_POLICIES
          • ALL_DEPENDENCIES
          • DBA_OB_IMPORT_TABLE_JOBS
          • DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • USER_PART_KEY_COLUMNS
          • USER_IND_EXPRESSIONS
          • DBA_OB_RESTORE_HISTORY
          • DBA_OB_TABLE_STAT_STALE_INFO
          • ALL_SUBPARTITION_TEMPLATES
          • DBA_OB_LS_LOCATIONS
          • ALL_TAB_COLUMNS
          • ALL_SEC_RELEVANT_COLS
          • DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • DBA_ERRORS
          • DBMS_LOCK_ALLOCATED
          • USER_PART_TABLES
          • DBA_TAB_COLS
          • DBA_OB_LS
          • ALL_COLL_TYPES
          • USER_IND_SUBPARTITIONS
          • DBA_AUDIT_OBJECT
          • DBA_OB_TRANSFER_TASKS
          • ALL_USERS
          • DBA_TAB_PARTITIONS
          • USER_AUDIT_SESSION
          • USER_TABLESPACES
          • ALL_PROFILES
          • DBA_WR_CONTROL
          • ALL_TAB_PARTITIONS
          • USER_ALL_TABLES
          • AUDIT_ACTIONS
          • DBA_SEGMENTS
          • USER_TAB_PRIVS
          • ALL_SCHEDULER_WINDOWS
          • ALL_IND_EXPRESSIONS
          • DBA_OB_TABLEGROUP_PARTITIONS
          • ALL_SEQUENCES
          • DBA_PART_HISTOGRAMS
          • NLS_DATABASE_PARAMETERS
          • DBA_OB_ARCHIVELOG
          • USER_VIEWS
          • USER_IND_STATISTICS
          • ALL_TAB_STATISTICS
          • USER_ARGUMENTS
          • DBA_COL_COMMENTS
          • ALL_SYNONYMS
          • DBA_SOURCE
          • DBA_OB_BACKUP_JOBS
          • USER_SUBPARTITION_TEMPLATES
          • USER_CONS_COLUMNS
          • DBA_COL_PRIVS
          • DBA_OB_LS_ARB_REPLICA_TASKS
          • ALL_ARGUMENTS
          • DBA_OB_BACKUP_PARAMETER
          • DBA_TABLES
          • ALL_DEF_AUDIT_OPTS
          • DBA_SCHEDULER_JOB_RUN_DETAILS
          • DBA_JOBS
          • TENANT_VIRTUAL_GLOBAL_VARIABLE
          • ALL_ERRORS
          • DBA_OB_TENANTS
          • DBA_OB_RESTORE_PROGRESS
          • DBA_OB_DATABASE_PRIVILEGE
          • ALL_COL_COMMENTS
          • DBA_SCHEDULER_JOB_ARGS
          • ALL_VIEWS
          • DBA_TRIGGER_ORDERING
          • USER_COLL_TYPES
          • USER_PART_INDEXES
          • ALL_SUBPART_KEY_COLUMNS
          • DBA_DIRECTORIES
          • NLS_INSTANCE_PARAMETERS
          • ALL_IND_STATISTICS
          • ALL_TABLES
          • DBA_OB_BACKUP_SET_FILES
          • DBA_OB_BACKUP_JOB_HISTORY
          • DBA_SCHEDULER_JOBS
          • DBA_POLICY_GROUPS
          • USER_SCHEDULER_PROGRAM_ARGS
        • Performance views
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_KVCACHE
          • GV$OB_PARAMETERS
          • GV$OB_PROCESSLIST
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_UNITS
          • GV$DBLINK
          • GV$INSTANCE
          • GV$OB_MEMORY
          • GV$OB_PX_WORKER_STAT
          • GV$OB_MEMSTORE
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$OB_SQL_AUDIT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSTEM_EVENT
          • GV$GLOBAL_TRANSACTION
          • GV$OB_SSTABLES
          • GV$OB_TENANT_MEMORY
          • V$GLOBALCONTEXT
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_KVCACHE
          • V$OB_PARAMETERS
          • V$OB_PROCESSLIST
          • V$OB_PX_TARGET_MONITOR
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_UNITS
          • V$DBLINK
          • V$INSTANCE
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$NLS_PARAMETERS
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PX_WORKER_STAT
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$OB_SQL_AUDIT
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$SYSTEM_EVENT
          • V$VERSION
          • V$SQL_MONITOR_STATNAME
          • V$GLOBAL_TRANSACTION
          • V$TIMEZONE_NAMES
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$RSRC_PLAN
          • V$OB_SSTABLES
          • V$OB_TENANT_MEMORY
          • GV$OB_MEMSTORE_INFO
          • V$OB_MEMSTORE_INFO
          • GV$SYSSTAT
          • V$SYSSTAT
          • V$EVENT_NAME
          • GV$ACTIVE_SESSION_HISTORY
          • V$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • V$DML_STATS
          • GV$OB_LOG_STAT
          • V$OB_LOG_STAT
          • GV$SQL_PLAN_MONITOR
          • V$SQL_PLAN_MONITOR
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_GLOBAL_TRANSACTION
          • V$OB_GLOBAL_TRANSACTION
          • V$OB_LS_REPLICA_TASK_PLAN
          • GV$OPEN_CURSOR
          • V$OPEN_CURSOR
          • V$OB_ARCHIVE_DEST_STATUS
          • GV$OB_THREAD
          • V$OB_THREAD
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_LOCKS
          • V$OB_LOCKS
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_TIMESTAMP_SERVICE
          • GV$OB_PX_P2P_DATAHUB
          • V$OB_PX_P2P_DATAHUB
          • GV$SQL_JOIN_FILTER
          • V$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • V$OB_SQL_PLAN
          • GV$OB_FLT_TRACE_CONFIG
      • Common statistics events
      • General wait events
    • Platforms
      • OMA
      • OMS
      • OCP
      • ODC
      • OCP Express
        • OCP Express
        • View cluster overview information
        • Tenant management
        • Monitor a cluster
        • Diagnostic analysis
        • Log service
      • OAT
    • Parameters and system variables
      • Overview
      • System variables
        • Overview
        • Global variables
          • auto_increment_cache_size
          • auto_increment_increment
          • auto_increment_offset
          • autocommit
          • binlog_row_image
          • block_encryption_mode
          • character_set_client
          • character_set_connection
          • character_set_database
          • character_set_filesystem
          • character_set_results
          • character_set_server
          • character_set_system
          • collation_connection
          • collation_database
          • collation_server
          • connect_timeout
          • cursor_sharing
          • datadir
          • debug_sync
          • default_password_lifetime
          • div_precision_increment
          • error_on_overlap_time
          • explicit_defaults_for_timestamp
          • foreign_key_checks
          • group_concat_max_len
          • identity
          • init_connect
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • nls_calendar
          • nls_characterset
          • nls_comp
          • nls_currency
          • nls_date_format
          • nls_date_language
          • nls_dual_currency
          • nls_iso_currency
          • nls_length_semantics
          • nls_nchar_characterset
          • nls_nchar_conv_excp
          • nls_numeric_characters
          • nls_sort
          • nls_territory
          • nls_timestamp_format
          • nls_timestamp_tz_format
          • ob_create_table_strict_mode
          • ob_bnl_join_cache_size
          • ob_default_replica_num
          • ob_compatibility_mode
          • ob_enable_blk_nestedloop_join
          • ob_early_lock_release
          • ob_enable_hash_group_by
          • ob_enable_aggregation_pushdown
          • ob_enable_index_direct_select
          • ob_enable_jit
          • ob_enable_plan_cache
          • ob_enable_sql_audit
          • ob_enable_transformation
          • ob_enable_transmission_checksum
          • ob_enable_truncate_flashback
          • ob_global_debug_sync
          • ob_log_level
          • ob_pl_block_timeout
          • ob_plan_cache_evict_high_percentage
          • ob_plan_cache_evict_low_percentage
          • ob_plan_cache_percentage
          • ob_proxy_global_variables_version
          • ob_query_timeout
          • ob_read_consistency
          • ob_reserved_meta_memory_percentage
          • ob_route_policy
          • ob_sql_audit_percentage
          • ob_sql_work_area_percentage
          • ob_tcp_invited_nodes
          • ob_temp_tablespace_size_percentage
          • ob_timestamp_service
          • ob_trx_idle_timeout
          • ob_trx_lock_timeout
          • ob_trx_timeout
          • optimizer_capture_sql_plan_baselines
          • optimizer_use_sql_plan_baselines
          • parallel_max_servers
          • parallel_servers_target
          • performance_schema
          • plugin_dir
          • query_cache_size
          • query_cache_type
          • read_only
          • recyclebin
          • resource_manager_plan
          • secure_file_priv
          • 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_warnings
          • system_time_zone
          • time_zone
          • transaction_isolation
          • transaction_read_only
          • tx_isolation
          • tx_read_only
          • version
          • version_comment
          • wait_timeout
          • 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
          • server_uuid
          • default_storage_engine
          • ob_enable_rich_error_msg
          • cte_max_recursion_depth
          • regexp_stack_limit
          • event_scheduler
          • regexp_time_limit
          • log_row_value_options
          • ob_max_read_stale_time
          • parallel_degree_policy
          • parallel_degree_limit
          • parallel_min_scan_time_threshold
          • optimizer_dynamic_sampling
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • runtime_filter_max_in_num
          • runtime_bloom_filter_max_size
          • optimizer_features_enable
        • Session-level variables
          • is_result_accurate
          • last_insert_id
          • nls_language
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • timestamp
          • tracefile_identifier
          • ob_max_read_stale_time
          • parallel_degree_policy
          • parallel_degree_limit
          • parallel_min_scan_time_threshold
          • optimizer_dynamic_sampling
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • runtime_filter_max_in_num
          • runtime_bloom_filter_max_size
      • Parameters
        • Overview
        • Cluster-level parameters
          • all_cluster_list
          • auto_broadcast_location_cache_rate_limit
          • all_server_list
          • auto_leader_switch_interval
          • auto_refresh_location_cache_rate_limit
          • autoinc_cache_refresh_interval
          • backup_backup_dest
          • backup_backup_dest_option
          • backup_dest_option
          • backup_concurrency
          • backup_dest
          • backup_log_archive_option
          • backup_net_limit
          • backup_recovery_window
          • backup_region
          • backup_zone
          • balance_blacklist_failure_threshold
          • balance_blacklist_retry_interval
          • balancer_emergency_percentage
          • balancer_log_interval
          • balancer_task_timeout
          • balancer_timeout_check_interval
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_disk_utilization_threshold
          • clog_expire_days
          • clog_cache_priority
          • clog_disk_usage_limit_percentage
          • clog_sync_time_warn_threshold
          • clog_transport_compress_func
          • cpu_reserved
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • data_copy_concurrency
          • data_dir
          • data_disk_usage_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress
          • default_transport_compress_func
          • default_compress_func
          • default_row_format
          • devname
          • disk_io_thread_count
          • dtl_buffer_size
          • election_cpu_quota
          • election_blacklist_interval
          • enable_async_syslog
          • enable_auto_refresh_location_cache
          • enable_auto_leader_switch
          • enable_ddl
          • enable_global_freeze_trigger
          • enable_log_archive
          • enable_election_group
          • enable_major_freeze
          • enable_merge_by_turn
          • enable_manual_merge
          • enable_ob_ratelimit
          • enable_one_phase_commit
          • enable_perf_event
          • enable_pg
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_separate_sys_clog
          • enable_smooth_leader_switch
          • enable_rootservice_standalone
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_table_ddl
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • fast_recovery_concurrency
          • enable_upgrade_mode
          • flush_log_at_trx_commit
          • gc_wait_archive
          • fuse_row_cache_priority
          • global_index_build_single_replica_timeout
          • global_major_freeze_residual_memory
          • get_leader_candidate_rpc_timeout
          • global_write_halt_residual_memory
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • ignore_replica_checksum_error
          • index_clog_cache_priority
          • index_info_block_cache_priority
          • index_cache_priority
          • ilog_index_expire_time
          • internal_sql_execute_timeout
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • location_cache_priority
          • 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_archive_batch_buffer_limit
          • log_archive_checkpoint_interval
          • max_kept_major_version_number
          • max_px_worker_count
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • merge_stat_sampling_ratio
          • merge_thread_count
          • merger_completion_percentage
          • merger_switch_leader_duration_time
          • micro_block_merge_verify_level
          • merger_warm_up_duration_time
          • migrate_concurrency
          • migration_disable_time
          • min_observer_version
          • minor_deferred_gc_time
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • obconfig_url
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • plan_cache_evict_interval
          • plan_cache_high_watermark
          • plan_cache_low_watermark
          • px_task_size
          • px_workers_per_cpu_quota
          • rdma_io_thread_count
          • recyclebin_object_expire_time
          • ls_meta_table_check_interval
          • resource_hard_limit
          • rebuild_replica_data_lag_threshold
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_memory_limit
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • rpc_port
          • 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
          • server_data_copy_out_concurrency
          • server_data_copy_in_concurrency
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • sql_audit_memory_limit
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • switchover_process_thread_count
          • syslog_io_bandwidth_limit
          • sys_bkgd_io_high_percentage
          • sys_bkgd_io_low_percentage
          • syslog_level
          • sys_cpu_limit_trigger
          • system_memory
          • system_trace_level
          • tableapi_transport_compress_func
          • tablet_size
          • tcp_keepcnt
          • system_cpu_quota
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_cpu_variation_per_server
          • tenant_task_queue_size
          • token_reserved_percentage
          • trace_log_sampling_interval
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • tenant_groups
          • use_large_pages
          • user_block_cache_priority
          • user_row_cache_priority
          • trx_force_kill_threshold
          • trx_try_wait_lock_timeout
          • virtual_table_location_cache_expire_time
          • unit_balance_resource_weight
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • user_iort_up_percentage
          • zone
          • user_tab_col_stat_cache_priority
          • wait_leader_batch_count
          • log_disk_size
          • log_disk_percentage
          • tablet_ls_cache_priority
          • opt_tab_stat_cache_priority
          • zone_merge_concurrency
          • index_block_cache_priority
          • zone_merge_order
          • sql_login_thread_count
          • zone_merge_timeout
          • ob_esi_rpc_port
          • enable_asan_for_memory_context
          • enable_ob_esi_process
          • enable_cgroup
          • ob_esi_session_timeout
          • diag_syslog_per_error_limit
          • ob_esi_io_concurrency
          • ob_startup_mode
          • ob_esi_memory_limit
          • log_storage_warning_tolerance_time
          • ob_esi_syslog_level
          • ob_esi_max_syslog_file_count
          • sql_net_thread_count
          • minor_freeze_times
          • minor_merge_concurrency
          • minor_warm_up_duration_time
          • multiblock_read_gap_size
          • multiblock_read_size
          • ofs_list
          • partition_table_check_interval
          • replica_safe_remove_time
          • resource_soft_limit
          • restore_concurrency
          • rpc_client_authentication_method
          • rpc_server_authentication_method
          • row_purge_thread_count
          • datafile_maxsize
          • datafile_next
          • standby_fetch_log_bandwidth_limit
          • local_ip
          • observer_id
          • storage_meta_cache_priority
          • sql_protocol_min_tls_version
        • Tenant-level parameters
          • audit_sys_operations
          • audit_trail
          • clog_max_unconfirmed_log_count
          • clog_persistence_compress_func
          • connection_control_failed_connections_threshold
          • connection_control_min_connection_delay
          • connection_control_max_connection_delay
          • enable_clog_persistence_compress
          • enable_early_lock_release
          • enable_monotonic_weak_read
          • external_kms_info
          • enable_sql_extension
          • default_progressive_merge_num
          • io_category_config
          • log_disk_utilization_limit_threshold
          • log_disk_utilization_threshold
          • major_compact_trigger
          • compaction_low_thread_score
          • max_stale_time_for_weak_consistency
          • compaction_high_thread_score
          • minor_compact_trigger
          • compaction_mid_thread_score
          • ob_enable_batched_multi_statement
          • ob_proxy_readonly_transaction_routing_policy
          • ob_ssl_invited_common_names
          • open_cursors
          • plsql_code_type
          • plsql_debug
          • plsql_optimize_level
          • plsql_warnings
          • sql_work_area
          • tde_method
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • workarea_size_policy
          • plsql_v2_compatibility
          • job_queue_processes
          • ha_high_thread_score
          • ha_mid_thread_score
          • ha_low_thread_score
          • ob_compaction_schedule_interval
          • default_auto_increment_mode
          • ob_query_switch_leader_retry_timeout
          • default_enable_extended_rowid
          • major_freeze_duty_time
          • undo_retention
          • query_response_time_stats
          • query_response_time_flush
          • query_response_time_range_base
          • merger_check_interval
          • freeze_trigger_percentage
          • cpu_quota_concurrency
          • arbitration_timeout
          • compatible
          • log_transport_compress_all
          • log_transport_compress_func
          • rpc_memory_limit_percentage
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • dump_data_dictionary_to_log_interval
          • enable_user_defined_rewrite_rules
          • partition_balance_schedule_interval
          • log_disk_throttling_percentage
          • enable_rebalance
          • balancer_idle_time
          • log_disk_throttling_maximum_duration
          • ls_gc_delay_time
          • standby_db_preferred_upstream_log_region
          • archive_lag_target
          • range_optimizer_max_mem_size
          • log_restore_concurrency
          • log_archive_concurrency
          • standby_db_fetch_log_rpc_timeout
          • enable_transfer
          • kv_ttl_duty_duration
          • kv_ttl_history_recycle_interval
          • enable_kv_ttl
          • ttl_thread_score
          • compaction_dag_cnt_limit
          • compaction_schedule_tablet_batch_cnt
    • Database object management
      • Overview
      • Oracle mode
        • Create and manage tables
          • Overview
          • Create a table
          • Define column constraints
          • Query the definition of a table
          • Modify a table
          • Empty a table
          • Drop a table
          • Lock a table
          • Create and manage external tables
            • Overview
            • Create an external table
            • Manage external files
        • Create and manage partitions
          • Overview
          • Create a partitioned table
          • Modify partitioning rules
          • Rename a partition
          • Add a partition
          • Drop a partition
          • Truncate a partition
          • Partition pruning
          • Query data in specified partitions
          • Create indexes on partitioned tables
            • Global indexes
            • Local indexes
            • Overview
        • Create and manage table groups
          • Drop a table group
          • Query information about a table group
          • Manage tables in a table group
          • Add tables to a table group
          • Modify the SHARDING attribute of a table group
          • Overview
          • Create a table group
        • Create and manage indexes
          • Overview
          • Create an index
          • Query indexes
          • System functions not supported for function-based indexes
          • System functions supported for function-based indexes
          • Drop an index
        • Manage views
        • Manage sequences
        • Manage synonyms
        • Create and manage triggers
          • Create an INSTEAD OF trigger
          • Modify and drop a trigger
          • Create a DML trigger
          • Query trigger information
          • Disable or enable a trigger
          • Create a composite trigger
          • Overview
        • Manage directory objects
        • Create and manage DBLinks
          • Create a DBLink
          • Query existing DBLinks
          • Use a DBLink to access data in a remote database
          • Use a DBLink to modify data in a remote database
          • Drop a DBLink
          • Install and configure OCI
      • MySQL mode
        • Create and manage databases
          • Create a database
          • View databases
          • Modify a database
          • Drop a database
        • Create and manage tables
          • Empty a table
          • Create a table
          • Define column constraints
          • Lock a table
          • Modify a table
          • Query the definition of a table
          • Drop a table
          • Define an auto-increment column
          • Overview
          • Create and manage external tables
            • Overview
            • Manage external files
            • Create an external table
        • Create and manage partitions
          • Overview
          • Create a partitioned table
          • Modify partitioning rules
          • Add a partition
          • Drop a partition
          • Truncate a partition
          • Partition pruning
          • Query data in specified partitions
          • Create indexes on partitioned tables
            • Overview
            • Local indexes
            • Global indexes
        • Create and manage table groups
          • Overview
          • Create a table group
          • Query information about a table group
          • Add tables to a table group
          • Modify the SHARDING attribute of a table group
          • Manage tables in a table group
          • Drop a table group
        • Create and manage indexes
          • System functions supported for function-based indexes
          • Query indexes
          • Drop an index
          • System functions not supported for function-based indexes
          • Create an index
          • Overview
        • Manage views
        • Create and manage sequences
          • Create a sequence
          • Query sequences
          • Reference a sequence
          • Modify a sequence
          • Drop a sequence
        • Create and manage triggers
          • Overview
          • Create a DML trigger
          • Query trigger information
          • Drop a trigger
        • Create and manage DBLinks
          • Use a DBLink to access data in a remote database
          • Query a DBLink
          • Drop a DBLink
          • Create a DBLink
    • System principles
      • Architecture of OceanBase Database
      • Development of OceanBase Database
      • Multi-tenant architecture
        • Overview
        • Compatibility modes
        • Tenants
        • Tenants and resource management
          • Resource unit balancing
          • Multi-tenant resource isolation
          • Tenant resource management
      • Database objects
        • Oracle mode
          • Partitions
            • Overview
            • Partitioning keys
            • Partitioning types
            • Partitioned indexes
          • Tables
            • Overview
            • Data type
              • ROWID data types
              • Numeric data types
              • Datetime data types
              • LOB data types
              • Character data types
              • Multi-model data types
              • Overview
              • Format model
                • Number format models
                • Overview
                • Datetime format models
            • Integrity constraints
            • Table storage
            • Table compression
            • Partitioned table
            • Tables with and without a primary key
            • Temporary tables
          • Views
            • View categorization
            • Data operations in views
            • Oracle-compatible views
            • OceanBase-specific views
            • Overview
            • Data access from views
            • Updatable views
          • Introduction
            • Overview
            • Database object types
            • Database object storage
            • Dependencies between database objects
          • Other objects
            • Sequences
            • Synonyms
          • Data integrity
            • Overview
            • Use of integrity constraints
            • Integrity constraint type
              • UNIQUE KEY constraints
              • Overview
              • FOREIGN KEY constraints
              • PRIMARY KEY constraints
              • NOT NULL constraints
              • CHECK constraints
          • System views
            • Dictionary views
            • Performance views
          • Indexes
            • Local and global indexes
            • Unique and non-unique indexes
            • Index storage
            • Use indexes
            • About indexes
        • MySQL mode
          • Data integrity
            • Overview
            • Integrity constraint type
              • Overview
              • NOT NULL constraints
              • UNIQUE KEY constraints
              • PRIMARY KEY constraints
              • FOREIGN KEY constraints
            • Use of integrity constraints
          • Introduction
            • Overview
            • Database object types
            • Database object storage
            • Dependencies between database objects
          • Indexes
            • About indexes
            • Index storage
            • Use indexes
            • Unique and non-unique indexes
            • Spatial indexes
            • Local and global indexes
          • Views
            • Overview
            • View categorization
            • OceanBase-specific views
            • MySQL-compatible views
            • Oracle-compatible views in MySQL tenants
            • Oracle-compatible views in the sys tenant
            • Data operations in views
            • Data access from views
            • Updatable views
          • Partitions
            • Partitioned indexes
            • Overview
            • Partitioning types
            • Partitioning keys
          • Tables
            • Table storage
            • Tables with and without a primary key
            • Partitioned table
            • Table compression
            • Integrity constraints
            • Overview
            • Data type
              • Numeric data types
              • LOB data types
              • Datetime data types
              • Overview
              • Multi-model data types
              • JSON data types
              • Spatial data types
              • Character data types
          • System views
            • Dictionary views
            • Performance views
      • Distributed database objects
        • Overview
        • Cluster architecture
        • Data partitions and replicas
          • Overview
          • Log streams
          • Partition replica type
            • Overview
            • Full-featured replica
          • Multi-replica consensus protocols
        • Dynamic scaling
          • Cluster scaling
          • Tenant resource scaling
            • Overview
            • Horizontal scaling of tenant resources
            • Vertical scaling of tenant resources
            • Cross-zone management of tenant resources
      • Data link
        • Overview
        • Database proxy
          • Overview
          • SQL routing
          • Connection management
          • ODP configuration management
          • Logs and monitoring
        • Database connector
          • Overview
          • OBCI
          • OceanBase Connector/J
          • OceanBase Connector/C
      • User interface and query language
        • SQL
          • Query SQL execution plans
          • Execution process of SQL queries
          • Introduction
            • Overview
            • SQL data access
            • SQL standards
          • Distributed execution plan
            • Perform distributed execution and parallel queries
            • Generate distributed execution plans
            • Run and disable a parallel query
            • Manage distributed execution plans
            • Perform parameter tuning for a parallel query
          • SQL statements
            • Overview
            • DDL statements
            • DCL statements
            • DML statements
        • PL
          • PL concepts
            • MySQL mode
              • Functions
              • Stored procedures
              • Subprograms
              • Triggers
            • Oracle mode
              • Subprograms
              • Triggers
              • Functions
              • Stored procedures
              • Packages
          • PL subprogram execution mechanism
        • Client programming languages
      • Transaction management
        • Transaction
          • Overview
          • Statement-level atomicity
          • Redo logs
          • Transaction structure
          • XA transactions
          • Local transactions
          • GTS
          • Transaction control
            • Overview
            • Active transactions
            • Savepoint
            • Transaction control statements
              • MySQL transaction control
              • Oracle transaction control
          • Distributed transaction
            • Overview
            • Two-phase commit
        • Transaction concurrency and consistency
          • Overview
          • Multi-version read consistency
          • Concurrency control
            • Overview
            • Lock mechanism
          • Transaction isolation level
            • Overview
            • Transaction isolation levels in Oracle mode
            • Transaction isolation levels in MySQL mode
          • Weak consistency read
      • Storage architecture
        • Overview
        • Data storage
          • Overview
          • MemTables
          • SSTables
          • Compression and encoding
        • Compaction
          • Overview
          • Major compaction
          • Minor compaction
        • Multi-level caches
        • Query processing
        • Data integrity
          • Detect silent data corruption
      • Data reliability and high availability
        • High availability architecture
          • Overview
          • ODP high availability
          • Leader election in distributed systems
          • Multi-replica log synchronization
          • Paxos protocol
          • Automatic handling of node failures
        • Deployment solutions for disaster recovery
        • Data protection
          • Overview
          • Flashback queries
          • Recycle bin
        • Backup and restore
          • Overview
          • Backup directory structures
          • Backup architecture
          • Restore architecture
      • Database security
        • Overview
        • Authentication
        • Access control
        • Data transmission encryption
        • Data storage encryption
        • Monitoring and alerting
        • Security audit
      • OBServer node architecture
        • Structure of the OBServer node installation directory
        • Configuration files
        • Logs
        • Memory management
          • Memory-related views
          • Memory-related parameters
          • Diagnose memory errors
          • Memory usage logs
          • Overview
        • observer thread model
          • Threads
          • Worker threads
          • Background threads
    • Database design specifications and practices
      • Character set specifications
      • Comments
      • ORM conventions
      • Database connection specifications
      • Exception handling
      • Object structure design specifications
        • Field design
        • Table structure design
        • Partitioned table design
        • Index design
        • Other structural designs
      • Object naming conventions
        • Overview
        • Tenant naming conventions
        • User naming conventions
        • Table naming conventions
        • Field naming conventions
        • Other naming conventions
    • Performance tuning
      • Overview
      • SQL tuning
        • Execution process of SQL queries
        • SQL execution plans
          • Fast parameterization
          • Plan cache
          • Real-time execution plan display
          • Introduction to SQL execution plans
          • SQL tuning practice with EXPLAIN
          • Execution plan operators
            • TABLE SCAN
            • JOIN
            • COUNT
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • MERGE
            • EXCHANGE
            • GI
        • Distributed execution plans
          • Schedule distributed execution plans
          • Parallel DML
          • Parallel execution enabling methods and their priority
          • Perform parameter tuning for a parallel query
          • Manage distributed execution plans
          • Perform distributed execution and parallel queries
          • Auto DOP
          • Execute parallel queries
          • Generate a distributed plan
        • SQL tuning
          • Overview
          • General procedure
          • SQL execution performance monitoring
            • GV$OB_SQL_AUDIT
            • SQL Trace
            • Plan cache views
            • SQL performance analysis example
              • Use SQL Audit to analyze wait events in a query
              • 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
              • Histograms
              • Manual statistics collection
              • Automatic statistics collection
              • Online statistics collection
              • Dynamic sampling
            • Statistics management
              • Overview
              • Delete statistics
              • Set statistics
              • Import and export statistics
              • Lock and unlock statistics
              • Manage statistics history
              • Manage statistics preferences
            • Monitoring and diagnostics for statistics collection
            • Examples
          • Query rewrite
            • Cost-based query rewrite
            • Overview
            • Rule-based query rewrite
          • Query optimization
            • Join algorithm
              • Overview
              • Join algorithms
              • Runtime filters
              • Join order
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
          • Manage execution plans
            • Optimizer hints
            • Plan binding
            • SQL plan management
        • Glossary
        • General issues in SQL tuning
      • System tuning
        • OS parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • Network transmission parameters
          • Routing parameters on nodes
          • CPU parameters
      • Performance related tools
        • System tools
          • Top
          • 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
          • dump tenant info
          • Trace logs
        • OCP
      • Performance diagnosis
        • Monitor and diagnose the cluster performance
        • Diagnose tenant performance
        • Monitor ODP performance
        • Monitor host performance
        • WR management
          • Overview
          • Manage WR
          • Monitor historical session performance
          • Clean up WR data
        • ASH report
          • ASH
          • Generate ASH reports
          • Analyze ASH reports
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
    • System management
      • Configuration management
        • General system parameters
        • Overview
        • Set parameters
        • Default production parameters
        • Minimum resource configurations
        • Set variables
      • Storage management
        • Minor compaction management
          • Overview
          • Automatically trigger a minor compaction
          • Manually initiate a minor compaction
          • View minor compaction information
          • Modify minor compaction settings
        • Major compaction management
          • Overview
          • Automatically trigger a major compaction
          • Configure scheduled major compactions
          • Adaptive major compactions
          • Manually initiate a major compaction
          • View the major compaction process
          • Manually control a major compaction
          • Modify major compaction settings
        • Data compression
          • Overview
          • Data encoding and compression
      • Memory management
        • Overview
        • Manage the memory of the plan cache
        • Manage internal system memory
        • Set the maximum memory for an OceanBase database
        • Manage internal tenant memory
        • FAQ about memory
        • Memleak-based regular memory leak diagnostics mechanism
        • Memory structure
        • Query memory usage information
      • Process management
        • Overview
        • Multi-tenant threads of OceanBase Database
        • View the thread status
        • Background threads of OceanBase Database
        • FAQ about multi-tenant threads
      • Disk management
        • Configure automatic scale-out of disk space for data files
    • Components & tools
      • O&M management
        • ob_error
        • OBD
        • ob_admin
          • Overview
          • clog
            • log_tool
            • Format of clogs
            • Transaction logs
          • dumpsst
          • dump_backup
        • ob-operator
          • Overview
          • Quick start
          • Deploy ob-operator
          • Upgrade ob-operator
          • User guide
            • Manage clusters
              • Create a cluster
              • Scale out clusters
                • Add zones to a cluster
                • Add OBServer nodes to zones
              • Scale in clusters
                • Delete zones from a cluster
                • Delete OBServer nodes from zones
              • Delete a cluster
              • Upgrade a cluster
            • Manage tenants
              • Create a tenant
              • Delete a tenant
              • Modify tenants
                • Modify other parameters
                • Manage replicas
                • Manage resources
            • Backup and restore
              • Back up a cluster
              • Back up a tenant
              • Restore data from a backup
      • Monitoring and diagnostics
        • obdiag
        • SQL diagnoser
          • Overview
          • SQL diagnoser remarks
            • Built-in diagnostic items
            • Diagnostic rule expression
            • Diagnostic items of SQL review
            • APIs
          • Deploy and use SQL diagnoser
            • Install SQL Diagnoser
            • Use SQL Diagnoser
        • DOOBA
      • Data integration
        • OBLogProxy
        • OBLOADER & OBDUMPER
        • Partition calculator
          • Overview
          • Use the ob-partition-calculator component
        • CDC
          • Overview
          • obcdc
            • FAQ about obcdc
            • Deploy and use obcdc
              • Install and deploy obcdc
              • obcdc development instructions
              • obcdc_tailf
            • obcdc parameters
              • General obcdc parameters
              • obcdc parameters
          • oblogmsg
            • Install and deploy oblogmsg
            • Description of some oblogmsg APIs
      • Stress testing tools
        • mysqltest
          • Use obd.sh to run mysqltest
          • Use of cases
            • Add a test case
            • General test case writing commands
            • Test case writing conventions
    • Database proxy
      • Connection and routing
      • View tenant sessions
      • Physical connections
      • Terminate a tenant session
      • OceanBase Database Proxy
      • Set the maximum number of connections for a tenant
      • Logical connection
        • Query session variables
        • Terminate a server session
        • Query the metrics of a session
        • Query all sessions
        • Query the details of a session
      • Route management
        • LDC-based routing
        • Table-based routing of ODP
        • ODP routing policy
          • Read/Write splitting
          • Follower-first read
          • Blocklist mechanism
          • Transaction routing
      • ODP
        • Overview
        • Manage ODP clusters
          • Restart all ODPs in an ODP cluster
          • Create an ODP cluster
          • Delete an ODP cluster
          • Manage ODP cluster parameters
          • Upgrade all ODPs in an ODP cluster
          • Manage OceanBase clusters connected to an ODP cluster
          • Monitor ODP cluster performance
        • Manage ODP
          • Add an ODP
          • Start an ODP
          • Refresh ODP configurations
          • Stop an ODP
          • Restart an ODP
          • Delete an ODP
          • Upgrade one or more ODPs
        • ODP startup parameters
    • Error codes
      • Oracle mode
        • Overview
        • ORA-00000 to ORA-00999
        • ORA-01000 to ORA-01499
        • ORA-01500 to ORA-01999
        • ORA-02000 to ORA-04999
        • ORA-05000 to ORA-10000
        • ORA-10000 to ORA-19999
        • ORA-20000 to ORA-29999
        • ORA-30000 to ORA-49999
        • ORA-50000 to ORA-99999
        • PLS-00000 to PLS-00999
      • MySQL mode
        • 7000 - 7999
        • 4000 - 4499
        • 5000 - 5999
        • Overview
        • 9500 - 9999
        • 4500 - 4999
        • 8000 - 8999
        • 9000 - 9499
        • 6000 - 6999
        • 0001 - 3999
        • 22998, 30926, 38104, and 38105
    • Drivers
      • OBCI
      • OceanBase Connector/ODBC
      • ECOB
      • OceanBase Connector/J
      • OceanBase Connector/C
    • Performance test
      • Run the TPC-H benchmark on OceanBase Database
      • Run the TPC-C benchmark on OceanBase Database
      • Sysbench benchmark report of OceanBase Database
      • TPC-C benchmark report of OceanBase Database
      • TPC-H benchmark report of OceanBase Database
      • Run the Sysbench benchmark on OceanBase Database
      • Achieve high performance with Sysbench on OceanBase Database: deployment and troubleshooting
  • FAQ
    • Products
    • SQL statements
    • Deployment
    • Cluster management
    • High availability
  • Release Notes
    • Version rules
    • OceanBase Database Enterprise Edition
      • V4.2
        • OceanBase Database Enterprise Edition V4.2.1
        • OceanBase Database Enterprise Edition V4.2.0
      • V4.1
        • OceanBase Database Enterprise Edition V4.1.0
      • V3.2
        • OceanBase Database Enterprise Edition V3.2.4
        • OceanBase Database Enterprise Edition V3.2.3
        • OceanBase Database Enterprise Edition V3.2.2
        • OceanBase Database Enterprise Edition V3.2.1
        • OceanBase Database Enterprise Edition V3.2.0
      • V3.1
        • OceanBase Database Enterprise Edition V3.1.1
        • OceanBase Database Enterprise Edition V3.1.2
      • V2.2
        • OceanBase Database Enterprise Edition V2.2.77
        • OceanBase Database Enterprise Edition V2.2.76
        • OceanBase Database Enterprise Edition V2.2.30
    • OceanBase Database Community Edition
      • V4.0
        • OceanBase Database Community Edition V4.0.0
      • V3.1
        • OceanBase Database Community Edition V3.1.3
        • OceanBase Database Community Edition V3.1.4
        • OceanBase Database Community Edition V3.1.2
        • OceanBase Database Community Edition V3.1.1
        • OceanBase Database Community Edition V3.1.5
      • V4.2
        • OceanBase Database Community Edition V4.2.1
        • OceanBase Database Community Edition V4.2.0
      • V4.1
        • OceanBase Database Community Edition V4.1.0
  • Glossary

Download PDF

Overview Differences between the Enterprise Edition and the Community Edition System architecture Overview SQL data types Built-in functions System views Compatibility with MySQL Limitations Video tutorials Quick start with OceanBase Database Community Edition Try out operational OLAP Try out parallel import and data compression Try out the multi-tenant feature Build a Java application Build a C application Basic SQL operations (Oracle mode) Basic SQL operations (MySQL mode) Before you begin Build a Python application Build a Java application Build a C application Build a Go application Overview HA deployment solutions for OceanBase clusters Deployment process Overview Deploy OceanBase Database in a Kubernetes cluster Clear an OceanBase cluster Overview Use Flink CDC to synchronize data from a MySQL database to OceanBase Database Use OMS to migrate data from a MySQL database to a MySQL tenant of OceanBase Database Use mydumper and myloader to migrate data from a MySQL database to OceanBase Database Use ChunJun to migrate data from a MySQL database to OceanBase Database Use CloudCanal to migrate data from a MySQL database to OceanBase Database Use DataX to migrate table data from a MySQL database to OceanBase Database Use DBCAT to migrate schemas from a MySQL database to OceanBase Database Use Canal to synchronize data from a MySQL database to OceanBase Database Use OMS to migrate data from a MySQL tenant of OceanBase Database to a MySQL database Use OMS to migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database Use DBCAT to migrate schemas from OceanBase Database to a MySQL database Use DataX to migrate table data from OceanBase Database to a MySQL database Use Canal to synchronize data from OceanBase Database to a MySQL database Use CloudCanal to migrate data from OceanBase Database to a MySQL database Use Flink CDC to migrate data from OceanBase Database to a MySQL database Use ChunJun to migrate data from OceanBase Database to a MySQL database Use OMS to migrate data from an Oracle database to a MySQL tenant of OceanBase Database Use OMS to migrate data from an Oracle database to an Oracle tenant of OceanBase Database Use DBCAT to migrate schemas from an Oracle database to OceanBase Database Use DataX to migrate table data from an Oracle database to OceanBase Database Use DBCAT to migrate schemas from OceanBase Database to an Oracle database Use DataX to migrate table data from OceanBase Database to an Oracle database Use OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle database Use OMS to migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database Use OMS to migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database Use DBCAT to migrate table schemas from a DB2 LUW database to OceanBase Database Use OMS to migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database Use OMS to migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database Use OMS to migrate data from a TiDB database to a MySQL tenant of OceanBase Database Use OMS to migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database Import data by using the LOAD DATA statement Use DataX to migrate CSV files to OceanBase Database Import data from SQL files to OceanBase Database Use OBLOADER & OBDUMPER to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database Use OMS to migrate data from an OceanBase Database tenant to another of the same type Use OMS to migrate data from an OceanBase Database tenant to another of the same type in active-active disaster recovery scenarios Use OBLOADER & OBDUMPER to migrate data between Oracle tenants in OceanBase Database Use OBLOADER & OBDUMPER to migrate data between MySQL tenants in OceanBase Database Use OBLOADER & OBDUMPER to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database Export data by using OUTFILE statements Migrate resource units Migrate data between tables Overview Import data in bypass mode by using the LOAD DATA statement Import data in bypass mode by using the INSERT INTO SELECT statement Log on to an OceanBase Database tenant Overview Traffic distribution Data distribution Overview Identify bottlenecks on the data link Deadlock detection Overview Check tenant resource usage Check cluster parametersCheck cluster resource usage Check the host status Check the NTP offsetCheck the OBServer node status Overview Cluster parameters Overview Introduction to physical backup and restore Deploy NFS Emergency response overview Analysis, diagnosis, and decision-making procedure High availability overview Flashback queries Tenant introduction Tenant capacity
OceanBase logo

The Unified Distributed Database for the Al Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Database
  3. SQL
  4. V4.2.1
iconOceanBase Database
SQL - V 4.2.1
SQL
KV
  • V 4.4.2
  • V 4.3.5
  • V 4.3.3
  • V 4.3.1
  • V 4.3.0
  • V 4.2.5
  • V 4.2.2
  • V 4.2.1
  • V 4.2.0
  • V 4.1.0
  • V 4.0.0
  • V 3.1.4 and earlier

oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS

Last Updated:2023-12-25 08:49:41  Updated
share
What is on this page
Purpose
Columns

folded

share

Purpose

The oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS view displays the information about the current tenant and the ongoing arbitration tasks in the current tenant.

Note

This view is introduced since OceanBase Database V4.1.0.

Columns

Column Type Nullable? Description
CREATE_TIME datetime NO The time when the task was generated.
MODIFY_TIME datetime NO The time when the task was modified.
LS_ID bigint(20) NO The ID of the log stream.
TASK_ID bigint(20) NO The ID of the job.
TRACE_ID varchar(200) NO The trace ID of the task in the log.
TASK_TYPE varchar(32) NO The task type. Valid values:
  • ADD REPLICA: indicates a replica adding task.
  • REMOVE REPLICA: indicates a replica deletion task.
ARBITRATION_SERVICE varchar(512) NO The endpoint of the arbitration service.
ARBITRATION_SERVICE_TYPE varchar(64) NO The type of the arbitration service. Only ADDR is supported.
COMMENT varchar(2048) YES The description of the task.

Previous topic

oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
Last

Next topic

oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
Next
What is on this page
Purpose
Columns