OceanBase logo

OceanBase

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

Product Overview
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

OceanBase

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

Product Overview
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.6.0

  • What's New
  • What is OceanBase Database
    • Overview
    • Architecture
    • Compatibility with Oracle
      • Overview of Oracle compatibility
      • SQL data types
      • Built-in functions
      • System views
    • Compatibility with MySQL
    • Limitations
  • Get Started
    • Quick start with OceanBase Database Community Edition
    • Learn OceanBase SQL
      • Before you begin
      • Basic SQL operations (MySQL mode)
      • Basic SQL operations (Oracle mode)
    • Build a sample application (MySQL-compatible mode)
      • Build a Python application
      • Build a Java application
      • Build a C application
      • Build a Go application
    • Build a sample application (Oracle-compatible mode)
      • Create a Java sample application
      • Create a C application
    • 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
  • Develop
    • Develop applications (MySQL-compatible mode)
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase tenant by using the mysql client
        • Connect to an OceanBase tenant by using OBClient
        • Connect to OceanBase Database by using ODC
        • Connect to OceanBase Database by using DBeaver
        • Connect to OceanBase Database by using Navicat
        • Use database connection pool
          • Database connection pool configuration
          • Tomcat
          • c3p0
          • Proxool
          • HikariCP
          • DBCP
          • Commons Pool
          • Druid
          • JDBC
      • Sample applications
        • Java
          • Spring Boot
          • Spring Batch
          • Spring JDBC
          • Spring Data JPA
          • Hibernate
          • MyBatis sample application for connecting to OceanBase Database
          • Connector/J
          • TestContainers
        • Python
          • mysqlclient
          • PyMySQL
          • MySQL-connector-python
        • C
          • MySQL Connector/C
        • Go
          • Go-SQL-Driver/MySQL
          • GORM
        • NET
          • Connect to an OceanBase database by using OceanBase Connector/NET
        • PHP
          • EXT
          • MySQLi
          • PDO
        • Rust
          • Connect to OceanBase Database by using Rust
          • Connect to OceanBase Database by using SeaORM
      • Plan database objects
        • Create a database
        • Create a table group
        • Create a table
        • Create an index
        • Create an external table
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
        • Generate test data in batches
      • Read data
        • Single-table queries
        • Join tables
          • INNER JOIN queries
          • FULL JOIN queries
          • LEFT JOIN queries
          • RIGHT JOIN queries
          • Subqueries
          • Lateral derived table
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use datetime functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use the CASE conditional operator in queries
          • Lock query results with SELECT FOR UPDATE
          • Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
        • Use a DBLink in queries
        • Set operations
      • Transactions
        • Overview
        • Start a transaction
        • Savepoints
          • Mark a savepoint
          • Roll back a transaction to a savepoint
          • Release a savepoint
        • Commit a transaction
        • Roll back a transaction
      • Application errors
        • Troubleshooting guidelines
          • About error codes
          • Error handling specifications for MySQL-compatible applications
        • Common errors and troubleshooting practices
          • Disconnected from the server, with ERROR 2013 reported
          • Idle transaction timed out, with ERROR 6002 reported
          • Transaction timed out, with ERROR 4012 reported
          • User locked, with ERROR 3118 reported
          • Incorrect user password, with ERROR 1045 reported
          • Table already exists, with ERROR 1050 reported
          • Table does not exist, with ERROR 1146 reported
          • Duplicate data inserted, with ERROR 1062 reported
          • ERROR 1215 reported in foreign key addition
          • Data truncated while being inserted, with ERROR 1265 reported
    • Develop applications (Oracle-compatible mode)
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase 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
      • Sample applications
        • Java
          • OceanBase Connector/J
          • Spring Boot
          • Spring Batch
          • Spring Data JDBC
          • Spring Data JPA
          • Hibernate
          • MyBatis
          • JFinal
        • C/C++
          • OceanBase Connector/C
          • OceanBase Connector/ODBC
          • SqlSugar
        • NET
          • Connect to OceanBase Database using OceanBase Connector/NET
      • 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
        • Generate test data in batches
      • Read data
        • Single-table queries
        • Join tables
          • INNER JOIN queries
          • FULL JOIN queries
          • LEFT JOIN queries
          • RIGHT JOIN queries
          • Subqueries
          • Lateral derived tables
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use datetime functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use CASE functions in queries
          • Use the SELECT...FOR UPDATE statement to lock query results
        • Use a DBLink in queries
        • Set operations
      • 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
        • Troubleshooting guidelines
          • About error codes
          • Error handling specifications for Oracle-compatible applications
        • Common errors and troubleshooting practices
          • Idle transaction timed out, with Error OBE-24761 reported
          • Transaction timed out, with Error OBE-00600 reported
          • User locked, with ERROR 3118 reported
          • Incorrect user password, with ERROR 1045 reported
          • Table already exists, with Error OBE-00955 reported
          • Table does not exist, with Error OBE-04043 reported
          • Duplicate data inserted, with Error OBE-00001 reported
          • Error OBE-00600 reported in foreign key addition
          • Inconsistent data types, with Error OBE-00932 reported
  • 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 two-replica OceanBase cluster with the arbitration service by using OCP
          • Deploy a single-replica OceanBase cluster by using OCP
          • Deploy a three-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 two-replica OceanBase cluster with the arbitration service by using the CLI
          • Deploy a single-replica OceanBase cluster by using the CLI
          • Deploy a three-replica OceanBase cluster by using the CLI
        • (Optional) Deploy ODP
      • Deploy OceanBase Database Java SDK
    • Clear an OceanBase cluster
    • Recommended configurations
  • OceanBase version upgrade
    • OceanBase Database Enterprise Edition
      • Overview
      • Upgrade an arbitration service
      • Upgrade an OceanBase cluster
      • Check the status after the upgrade
    • OceanBase Database Community Edition
      • Upgrade OceanBase Database with obd
  • Migrate
    • Overview
    • Migrate from MySQL databases 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 DBCAT to migrate schemas from a MySQL database to OceanBase Database
      • Use DataX to migrate table data from a MySQL database to OceanBase Database
      • Use CloudCanal to migrate data from a MySQL database to OceanBase Database
      • Use Canal to synchronize data from a MySQL database to OceanBase Database
      • Use Flink CDC to synchronize data from a MySQL database to OceanBase Database
      • Use ChunJun to migrate 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 OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle 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
    • 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
      • Use DataX to migrate CSV files to OceanBase Database
      • Import data by using the LOAD DATA statement
    • Import data from SQL files to OceanBase Database
    • Migrate data between OceanBase Database
      • Use OMS to migrate data from an OceanBase tenant to another of the same type
      • Use OMS to migrate data from an OceanBase tenant to another of the same type in active-active disaster recovery scenarios
      • Use obloader & obdumper to migrate data between MySQL tenants in OceanBase Database
      • Use obloader & obdumper to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database
      • Use obloader & obdumper to migrate data between Oracle 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
      • Migrate data between tables
      • Migrate resource units
      • Export data using the OUTFILE statement
    • Overview of direct load
  • Manage
    • Log in to an OceanBase tenant
    • Manage clusters
      • Overview
      • Cluster parameters
      • Common cluster operations
        • View a zone
        • View a node
        • Restart a node
        • Add nodes
        • Delete a node
        • Isolate a node
        • Replace a node
        • Start a zone
        • Add a zone
        • Delete a zone
        • Modify a zone
        • Isolate a zone
        • View cluster parameters
        • Modify cluster parameters
        • Reset cluster parameters
      • Troubleshoot common problems
        • Failures of a minority of nodes
        • Failures of the majority of nodes
    • Manage tenants
      • Tenant introduction
      • Tenant capacity
      • Tenant types
      • User tenant introduction
      • Tenant system variables
      • Common tenant operations
        • Create a tenant
        • Resource isolation
          • Overview
          • Manage resource isolation (Oracle-compatible mode)
            • Configure cgroups
            • Configure global CPU resource isolation for frontend and backend tasks
            • Calibrate the disk performance
            • Configure resource isolation within a tenant
            • Update a plan directive
            • Delete a plan directive
            • Delete a resource management plan
            • Delete a resource group
            • Clear cgroup configurations
          • Manage resource isolation (MySQL-compatible mode)
            • Configure cgroups
            • Configure global CPU resource isolation for foreground and background tasks
            • Calibrate the disk performance
            • Configure resource isolation within a tenant
            • Update resource management plan directive
            • Delete a plan directive
            • Delete a resource management plan
            • Delete a resource group
            • Clear cgroup configurations
        • View tenant and resource information
        • View and set the tenant allowlist
        • View system variables of a tenant
        • Modify system variables of a tenant
        • Scale in/out
          • Overview
          • Plan resources
          • Tenant pre-scaling
          • Modify the unit config for a tenant
          • Modify the number of resource units for a tenant
          • Modify the number of primary zones for a tenant
          • Smooth scaling application scenarios
        • Modify attributes of a resource pool
        • Modify attributes of a tenant
        • Lock and unlock a tenant
        • Drop a tenant
        • Restore 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 a resource pool
          • Drop a resource pool
        • Manage unit configs
          • Query unit configs
          • Modify a unit config
          • Drop a unit config
        • Manage services
          • Create a service
          • Query the service status
          • Start a service
          • Stop a service
          • Delete a service
    • Manage log streams
      • Create a log stream
      • Modify a log stream
    • Manage replicas
      • Replicas
      • Replica distribution
        • Locality
        • Common locality operations
          • View locality
          • Modify locality
          • Add a replica
          • Remove replicas
          • Convert the type of a replica
          • Adjust the distribution of replicas
          • View the locality change history
          • Replica migration
          • Modify the number of Paxos replicas of a log stream
          • Cancel a replica task
      • Traffic distribution
      • Data distribution
    • Data load balancing
      • Overview
      • Transfer Partition
      • Cancel a partition transfer task
      • Cancel a Balance Job
      • Partition balance management
        • View the partition balancing task in the background
        • View the history of partition balancing tasks in the background
      • GTS standalone application scenario
    • High availability
      • High availability overview
      • Multi-replica disaster recovery
        • Data link introduction
        • ODP high availability
        • Database-level high availability
        • Disaster recovery architecture and levels
      • 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 restore (with complete logs) feature
          • Create a standby tenant by using the BACKUP DATABASE PLUS ARCHIVELOG feature
        • Log transmission service
          • Overview
          • Configure log transmission service
            • Set a log restore source
            • Specify a log restore 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
          • Specify log compression
        • Log storage service
        • Switch roles
          • Overview of tenant roles
          • Switchover
          • Failover
        • Drop primary and standby tenants
      • Arbitration high availability
        • Overview
        • Enable arbitration service for a tenant
        • Disable the arbitration service for a tenant
        • Modify the log stream downgrade control time
        • Query log stream upgrade/downgrade information
        • 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
    • Security and permissions
      • Overview
      • Identification and authentication
        • MySQL-compatible mode
          • Identity authentication
          • Password complexity
          • Login failure processing
        • Oracle-compatible mode
          • Identity authentication
          • Password complexity
          • Login failure processing
      • Access control
        • Overview
        • Users and permissions
          • Overview
          • MySQL-compatible mode
            • Privilege types in MySQL mode
            • Create a user
            • Grant direct privileges
            • Privilege delegation
            • Role management
              • Overview
              • Create a role
              • Grant privileges to a role
              • Grant a role to a user or another role
              • Activate a role
              • View roles
              • Revoke privileges from a role
              • Revoke a role from a user or another role
              • Drop a role
            • Grant indirect privileges
            • View user privileges
            • Revoke privileges
            • Lock or unlock a user
            • Drop a user
          • Oracle-compatible mode
            • Privilege types in Oracle mode
            • Create a user
            • View the information of 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
            • View user privileges
            • Revoke privileges
            • Use a proxy user
            • Lock or unlock a user
            • Drop a user
        • Network security access control
        • RPC connection authentication
        • Row-level access control
      • Data encryption
        • Overview
        • Data transmission encryption
          • Overview
          • Transport encryption for OBServer
          • ODP transmission encryption
        • Tenant master key management
          • Overview
          • Generate a tenant master key (MySQL mode)
          • Generate a tenant master key (Oracle mode)
        • Data storage encryption
          • Overview
          • MySQL-compatible mode
            • Enable TDE for new tables
            • Enable TDE for existing tables
            • Decrypt a table
          • Oracle-compatible mode
            • Enable TDE for new tables
            • Enable TDE for existing tables
            • Decrypt a table
        • Column encryption
          • Overview of column encryption
          • MySQL-compatible mode
            • Create a column encryption rule
            • Manage column encryption privileges
          • Oracle-compatible mode
            • Create a column encryption rule
            • Column encryption permissions
          • FAQ about column encryption
      • Security audit
        • Security audit overview
        • Security audit in MySQL-compatible mode
          • Enable security auditing
          • Set an auditing rule
          • View auditing records
          • Disable security auditing
        • Security audit in Oracle-compatible mode
          • Enable security auditing
          • Set and view auditing rules
          • View auditing records
          • Audit user logins
          • Audit user operations
          • Audit specified database objects
    • Backup and restore
      • Overview
      • Experience physical backup and restore with simplified deployment
      • Deploy NFS
      • Log archive
        • Overview
        • Prepare for log archiving
        • Enable ARCHIVELOG
        • Suspend archiving
        • Disable ARCHIVELOG
        • View information about pieces
        • View the archiving progress
        • View the archiving history
        • View archiving parameter settings
        • Change the archive destination
        • Clear the archive path setting
        • Views related to log archiving
      • Data backup
        • Prepare for backup
        • Initiate a full data backup job
        • Initiate an incremental data backup job
        • Back up parameters
        • Stop a backup job
        • View the data backup progress
        • View the data backup history
        • View parameters related to data backup
        • Change the backup destination
        • Views related to data backup
      • Update `access_id` and `access_key` information for the backup or archive path
      • Clear backup data
        • Query the backup cleanup progress
        • Query the backup cleanup history
        • Backup cleanup parameter
        • Views related to backup cleanup
      • Backup validation
        • Backup validation overview
        • Validate the entire backup path and archive path
        • Validate a specified backup set or log archive piece
        • Validate a backup set or log archive piece in a specified path
        • Cancel a backup validation task
        • View the backup verification progress
        • View the backup validation result
      • Restore data
        • Prepare for restore
        • Perform physical restore
        • Perform restore from the specified paths
        • Cancel physical restore
        • View the physical restore progress
        • View physical restore results
        • Replay logs to a standby tenant
        • Convert a standby tenant into primary tenant
        • Upgrade a tenant after restore
        • Parameters related to physical restore
        • Views related to physical restore
      • Restore by table
        • Overview of table-level restore
        • Preparations before table-level restore
        • Perform table-level restore
        • Schema recovery in table-level restore
        • Cancel table-level restore
        • Check the progress of table-level restore
        • Check the results of table-level restore
        • Parameters related to table-level restore
        • Views related to table-level restore
      • Backup and restore performance tuning
    • 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 compression and decompression
      • Log metrics
      • Alert logs
      • View logs
        • Search for the logs of a specific SQL request
        • Query the log of a previous SQL request by using the SQL Trace feature
    • Daily inspection
      • Overview
      • Check cluster parameters
      • Check the host status
      • Check the resource usage status of a tenant
      • Check cluster resource usage
      • Check the OBServer node status
      • Check the NTP offset
      • Deadlock detection
      • End-to-end tracing
        • Overview
        • Process
        • Methods
        • Show end-to-end tracing information
        • Quick start: End-to-end diagnosis with obdiag
    • 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 plan
            • Buffer tables
            • Cardinality
          • Hard parsing
          • Capacity issues
          • Internal wait events
      • SQL tuning
        • SQL tuning system
        • Execution plan optimization
          • Statistical information and row estimation
            • Overview
            • Statistical information
              • Overview
              • Collect statistical information
                • Overview
                • Manually collect statistics
                • Automatic statistics collection
              • 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
          • Plan management
            • Plan cache
            • Disadvantages of the plan cache and countermeasures
            • Views related to the plan cache
          • Index selection
            • Overview
            • Reduce row reads
            • Avoid table access by index primary key
            • Avoid sorting
          • Join
            • Joins
            • Join algorithm
              • Nested loop joins
              • Hash Join
              • Merge join
              • Common business issues
            • Join types
            • Join order
          • Order and limit optimization
            • Overview
            • SORT assignment and optimization
            • Optimization in ORDER BY + LIMIT scenarios
        • Business logic optimization
          • SQL specifications
          • Schema specifications
        • Locate and analyze slow queries I
        • Locate and analyze slow queries II
        • Typical scenarios and cases
    • Troubleshooting
      • Overview
      • BootStrap
      • Storage
        • Minor compaction and major compaction
        • Memory-related errors
        • Migration, replication, and rebuild tasks
      • Election
        • Election
        • Forced leader election
        • No leader
      • Transaction
        • Transaction issues
        • Transaction rollbacks
        • Long-running transactions
        • Suspended transactions
        • Idle transactions
      • Log synchronization-related errors
      • Physical standby database
        • Log synchronization stuck for the physical standby database
        • Switchover and failover issues
        • Other issues
      • Backup and restore
        • Data backup failures
        • Physical restore failures
      • Arbitration server process startup failures
      • FAQ about manual operations on log streams
      • Application exceptions -- error messages without OceanBase error codes
      • Application exceptions -- error messages with OceanBase error codes
      • Troubleshoot application disconnection issues
      • Troubleshooting with ASH
        • Troubleshoot uneven CPU usage
    • Emergency response
      • Emergency response overview
      • Analysis, diagnosis, and decision-making procedure
      • Common emergency problem handling
        • Hardware issues
          • Node failure
          • Network failure
          • ODP failure
          • Other hardware and network issues
        • Capacity issues
          • SQL query exceptions
          • 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
          • sys tenant or RootService exceptions
          • Insufficiency or leakage of system memory
  • OceanBase AP
    • AP feature version history
    • Overview of OceanBase Database AP
    • Core features of OceanBase Database AP
    • Quickly try out OceanBase AP
    • Deployment
      • Overview
      • Deploy an AP architecture
      • Parameter configuration recommendations for AP scenarios
      • Deploy and use columnstore replicas
      • AP query routing rules
    • Data table design
      • Overview of data tables
      • Data distribution
        • Dynamic partitioning
      • Best practices for data table design
        • Data table design and query optimization in AP scenarios
        • JSON multi-value index and full-text index practices
        • Table partitioning design practices for OLAP scenarios
        • Configure Skip Index in conjunction with table update mode
    • Data migration
      • Best practices for migrating data from mainstream AP databases to OceanBase
    • Data collection
      • Import data
        • Overview
        • Direct load
          • Overview
          • Incremental direct load
        • Import data to an external table
        • Strategies and best practices
    • Data processing
      • Data processing in OceanBase Database
      • Data processing tools
      • Materialized views query acceleration
        • Query acceleration using materialized views
        • Practice scenarios of materialized views
    • Data lake
      • Data catalog
        • Overview of data catalogs
        • HMS Catalog
      • External table
        • External tables
    • Query acceleration
      • Overview
      • Statistics
      • Select a query parallelism level
    • Export data
    • Data visualization
    • Performance diagnosis and tuning
      • Use the DBMS_XPLAN package for performance diagnostics
      • Use the GV$SQL_PLAN_MONITOR view for performance analysis
      • Views related to AP performance analysis
    • Ecosystem integration
    • Tutorials
      • Recommended practical tutorials for analytical processing
    • AP FAQ
  • OceanBase AI
    • Overview
      • Overview of vector search
      • Core features of vector search
      • AI application workflow with OceanBase Vector Search
    • Quick start
      • Use SQL to perform vector search
      • Perform a vector search by using Python
    • Vector embedding
    • Store vector data
    • Vector index
      • Overview
      • Vector index memory management
      • Dense vector index
        • Choose an index type
        • HNSW index
        • IVF series indexes
      • Semantic index
      • Sparse vector index
        • In-Memory Sparse Index
      • Monitor and maintain vector indexes
    • Use SQL functions
    • Vector similarity search
    • Hybrid search
      • Hybrid search (SQL interface)
      • Hybrid search (PL interface)
    • AI function service
      • Overview
      • Get started with AI Function Service
      • AI function service privileges
      • Register AI models
      • Syntax and examples of AI Function Service
    • Migrate to OceanBase Database from a vector database
    • Practical tutorial
      • Overview
    • Benchmark testing with VectorDBBench
    • Vector search references
      • Overview of vector data types
      • Search index
      • Compatibility
      • Supported clients and languages
        • Java SDK interface
    • FAQ
  • Shared storage
    • Shared storage overview
    • Shared storage architecture
    • Multi-level caching in shared storage
    • Shared storage disaster recovery deployment
    • Hotspot cache (MySQL-compatible mode)
      • Overview
      • Create a table-level hot and cold storage strategy
      • Create a partition-level storage cache policy
      • Modify the cold and hot storage policy at the table level
      • Modify the partition-level hot and cold storage strategy
      • Manage the custom hot and cold storage strategy
      • Create a macro-block-level hot and cold storage strategy
    • Shared storage-related views overview
    • Overview of shared storage configuration items and system variables
  • Integrations
    • Overview
    • ORM frameworks
      • Java
        • Connect to OceanBase Database by using Spring Boot
        • Connect to OceanBase Database by using Spring Batch
        • Connect to OceanBase Database by using Spring Data JDBC
        • Connect to OceanBase Database by using Spring Data JPA
        • Connect to OceanBase Database by using Hibernate
        • Sample program that uses MyBatis to connect to OceanBase Database
      • Python
        • Connect to OceanBase Database by using SQLAlchemy
        • Connect to OceanBase Database by using peewee
      • Go
        • Connect to OceanBase Database by using GORM
      • Ruby
        • Connect to OceanBase Database by using Active Record
        • Sequel
    • Database version management
      • Liquibase
    • Data integration
      • dbt
      • SeaTunnel
      • Maxwell
      • Debezium
    • SQL development
      • DBeaver
      • Navicat
      • DataGrip
      • TablePlus
    • Orchestration and scheduling
      • DolphinScheduler
      • Linkis
    • Visualization tools
      • Superset
      • Power BI
      • Quick BI
      • Tableau
    • Database management
      • NineData
      • Bytebase
    • AI
      • OpenAI
      • Qwen
      • LangChain
      • LlamaIndex
      • Dify
  • Tutorials
    • Build an image search application with OceanBase Database
    • Build an intelligent Q&A assistant with OceanBase Database
    • Build a real-time data warehouse and visual dashboard with OceanBase
    • Analyze data in OceanBase Database using Superset
    • Build a WordPress website with OceanBase Database
    • Use direct load to accelerate massive data import
  • Reference
    • OceanBase concepts
      • OceanBase Database architecture
      • Development of OceanBase Database
      • Multi-tenant architecture
        • Overview
        • Compatibility modes
        • Tenants
        • Tenants and resource management
          • Resource management for tenants
          • Multi-tenant resource isolation
          • Resource unit balancing
      • Database objects
        • Oracle-compatible mode
          • Introduction
            • Overview
            • Database object types
            • Database object storage
            • Dependencies between database objects
          • Tables
            • Overview
            • Data type
              • Overview
              • Character data types
              • Numeric data types
              • Datetime data types
              • ROWID data types
              • LOB data types
              • Format model
                • Overview
                • Number format models
                • Datetime format models
              • Multi-model data types
            • Integrity constraints
            • Table storage
            • Table compression
            • Partitioned table
            • Replicated table
            • Tables with and without a primary key
            • Temporary table
            • Table groups
          • Indexes
            • Overview of indexes
            • Local and global indexes
            • Unique and non-unique indexes
            • Use indexes
            • Index storage
          • Partitions
            • Overview
            • Partitioning keys
            • Partitioning types
            • Partitioned indexes
            • External table partitions
          • Views
            • Views in a database
            • Standard views
              • Standard views
              • Overview
              • OceanBase-specific views
              • Oracle-compatible views
              • View operations and data access
          • Other objects
            • Sequences
            • Synonyms
          • System views
            • Dictionary views
            • Performance views
          • Data integrity
            • Overview
            • Integrity constraint type
              • Overview
              • NOT NULL constraints
              • UNIQUE KEY constraints
              • PRIMARY KEY constraints
              • FOREIGN KEY constraints
              • CHECK constraints
            • Use of integrity constraints
        • MySQL-compatible mode
          • Introduction
            • Overview
            • Database object types
            • Database object storage
            • Dependencies between database objects
          • Tables
            • Overview
            • Data type
              • Overview
              • Numeric data types
              • Datetime data types
              • Character data types
              • LOB data types
              • Multi-model data types
              • Spatial data types
              • JSON data types
            • Integrity constraints
            • Table storage
            • Table compression
            • Partitioned table
            • Replicated table
            • Tables with and without a primary key
            • Table groups
          • Indexes
            • Overview
            • Local and global indexes
            • Unique and non-unique indexes
            • Spatial indexes
            • Full-text index
            • Vector index
            • Search index
            • Use indexes
            • Index storage
          • Partitions
            • Overview
            • Partitioning keys
            • Partitioning types
            • Partitioned indexes
            • External table partitions
          • Views
            • Views in a database
            • Standard views
              • Overview
              • Overview
              • OceanBase-specific views
              • MySQL-compatible views
              • Oracle-compatible views in MySQL tenants
              • Oracle-compatible views in the sys tenant
              • View operations and data access
          • System views
            • Dictionary views
            • Performance views
          • Data integrity
            • Overview
            • Integrity constraint type
              • Overview
              • NOT NULL constraints
              • UNIQUE KEY constraints
              • PRIMARY KEY constraints
              • Foreign key constraints
            • Use of integrity constraints
      • Distributed database objects
        • Overview
        • Cluster architecture
        • Data partitions and replicas
          • Overview
          • Log streams
          • Partition replica type
            • Overview
            • Full-featured replica
            • Read-only replicas
            • Columnstore replica
          • Multi-replica consensus protocols
          • Data balancing
            • Tenant-level load balancing
            • Views and parameters related to data balancing
        • Dynamic scaling
          • Tenant resource scaling
            • Overview
            • Scale out or scale in 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
        • Cross-data source access through DBLink
          • DBLink in MySQL mode
          • DBLink in Oracle mode
      • User interface and query language
        • SQL
          • Introduction
            • Overview
            • SQL data access
            • SQL standards
          • SQL statements
            • Overview
            • DDL statements
            • Monitor DDL execution progress
            • DML statements
            • DCL
          • Execution process of SQL queries
          • Query SQL execution plans
          • Distributed execution plan
            • Perform distributed execution and parallel queries
            • Generate distributed execution plans
            • Run and disable a parallel query
            • Manage distributed execution plans
            • Tune parameters for parallel queries
        • PL
          • PL concepts
            • Oracle-compatible mode
              • Subprograms
              • Stored procedures
              • Functions
              • Triggers
              • Packages
            • MySQL-compatible mode
              • Subprograms
              • Stored procedures
              • Functions
              • Triggers
          • PL subprogram execution mechanism
        • Client programming languages
      • Transaction management
        • Transaction
          • Overview
          • Transaction structure
          • Statement-level atomicity
          • GTS
          • Transaction control
            • Overview
            • Active transactions
            • Savepoint
            • Transaction control statements
              • MySQL transaction control
              • Oracle transaction control
          • Redo logs
          • Local transactions
          • Distributed transaction
            • Overview
            • Two-phase commit
          • XA transactions
        • Transaction concurrency and consistency
          • Overview
          • Multi-version read consistency
          • Concurrency control
            • Overview
            • Lock mechanism
            • Lock wait manager
          • Transaction isolation level
            • Overview
            • Transaction isolation levels in Oracle mode
            • Transaction isolation levels in MySQL mode
          • Weak-consistency read
      • Storage architecture
        • Overview of storage architecture
        • Data storage
          • Overview
          • MemTables
          • SSTables
          • Columnar storage
          • Compression and encoding
        • Compaction
          • Overview
          • Compaction
          • Major compaction
        • Multi-level caching in shared-nothing architecture
        • Multi-level caching in shared storage
        • 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 structure
          • Backup architecture
          • Restore process
        • Arbitration-based high availability solution
        • Physical Standby Database solution
      • 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 file
        • observer thread model
          • Threads
          • Worker threads
          • Background threads
        • Logs
        • Memory management
          • Overview
          • Memory-related parameters
          • Memory-related views
          • Memory usage logs
          • Diagnose memory errors
    • System management
      • Configuration management
        • Overview
        • Set parameters
        • 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 parameters
        • Major compaction management
          • Overview
          • Automatically trigger a major compaction
          • Trigger daily tenant compaction
          • Window compaction
          • Adaptive major compactions
          • Manually trigger a major compaction
          • Manually control a major compaction
          • View the information about major compactions
          • Modify major compaction settings
        • Data compression
          • Overview
          • Data encoding and compression
        • Use the TTL feature
      • Memory management
        • Overview
        • Memory structure
        • Set the maximum memory for an OceanBase database
        • Manage internal system memory
        • Memory management in a tenant
        • Manage the memory of the plan cache
        • Memleak-based regular memory leak diagnostics mechanism
        • Query memory usage information
        • FAQ about memory
      • 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 dynamic expansion of disk data files
        • View the disk space used by a tenant or table
    • Database object management
      • Overview
      • MySQL-compatible mode
        • Create and manage databases
          • Create a database
          • View databases
          • Modify a database
          • Drop a database
        • Create and manage tables
          • Overview
          • Create a table
          • Skip index attribute
          • Define an auto-increment column
          • Define column constraints
          • Query tables
          • Modify a table
          • Change the attribute of a table
          • Empty a table
          • Drop a table
          • Lock a table
          • Create and manage external tables
            • About external tables
            • Create an external table
            • Add partitions for an external table
            • Manage external files
            • Data type mapping
        • Create and manage partitions
          • Overview
          • Create a partitioned table
          • Partition splitting
            • Overview
            • Manual partition splitting
            • Automatic partition splitting
          • Dynamic partitioning
            • Overview of dynamic partitioning
            • Create a dynamic partitioned table
            • Query a dynamic partitioned table
            • Modify a dynamic partitioned table
            • Dynamic partition management tasks
          • Modify partitioning rules
          • Add a partition
          • Delete a partition
          • Truncate partitions
          • Partition pruning
          • Query data in specified partitions
          • Create indexes on partitioned tables
            • Overview
            • Local indexes
            • Global indexes
          • Partition exchange
        • 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
          • Overview
          • Create an index
          • Query indexes
          • Monitor indexes
          • Drop an index
          • System functions supported for function-based indexes
          • System functions not supported for function-based indexes
        • Manage views
          • Manage standard views
          • Manage materialized views
            • Overview of materialized views
            • Materialized view logs
            • Automatic management of materialized view logs
            • Create a materialized view
            • Refresh a materialized view
            • Rewrite queries based on materialized views
            • Query materialized views
            • Modify the attributes of a materialized view
            • Drop a materialized view
        • 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
          • Create a DBLink
          • Query existing DBLinks
          • Manage DBLinks
          • Use a DBLink to access data in a remote database
          • Drop a DBLink
        • Create and manage catalogs
          • Create a catalog
          • View a catalog
      • Oracle-compatible mode
        • Create and manage tables
          • Overview
          • Create a table
          • Skip index attribute
          • Define column constraints
          • Query the definition of a table
          • Modify a table
          • Change the attribute of a table
          • Empty a table
          • Drop a table
          • Lock a table
          • Create and manage external tables
            • Overview
            • Create an external table
            • Add partitions for an external table
            • Manage external files
            • Data type mapping
        • Create and manage partitions
          • Overview
          • Create a partitioned table
          • Partition splitting
            • Overview
            • Manual partition splitting
            • Automatic subpartition splitting
          • Dynamic partitioning
            • Overview of dynamic partitioning
            • Create a dynamic partitioned table
            • Query a dynamic partitioned table
            • Modify a dynamic partitioned table
            • Dynamic partition management tasks
          • Modify partitioning rules
          • Rename a partition
          • Add a partition
          • Drop partitions
          • Truncate a partition
          • Partition pruning
          • Query data in specified partitions
          • Create indexes on partitioned tables
            • Overview
            • Local indexes
            • Global indexes
          • Partition exchange
        • 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
          • Overview
          • Create an index
          • Query indexes
          • Monitor indexes
          • Drop an index
          • System functions supported for function-based indexes
          • System functions not supported for function-based indexes
        • Manage views
          • Manage standard views
          • Manage materialized views
            • Overview
            • Materialized view logs
            • Automatic management of materialized view logs
            • Create a materialized view
            • Refresh materialized views
            • Rewrite queries based on materialized views
            • Query materialized views
            • Modify the attributes of a materialized view
            • Drop a materialized view
        • Manage sequences
        • Manage synonyms
        • Create and manage triggers
          • Overview
          • Create a DML trigger
          • Create an INSTEAD OF trigger
          • Create a composite trigger
          • Modify and drop a trigger
          • Disable or enable a trigger
          • Query trigger information
        • Manage directory objects
        • Create and manage DBLinks
          • Create a DBLink
          • Query existing DBLinks
          • Manage DBLinks
          • Use a DBLink to access data in a remote database
          • Use a DBLink to modify the data in a remote database
          • Drop a DBLink
          • Install and configure OCI
    • Database design specifications and practices
      • Object naming conventions
        • Overview
        • Tenant naming conventions
        • User naming conventions
        • Table naming conventions
        • Field naming conventions
        • Other naming conventions
      • Object structure design specifications
        • Field design
        • Table structure design
        • Partitioned table design
        • Index design
        • Other structural designs
      • Character set specifications
      • Database connection specifications
      • Comments
      • ORM conventions
      • Exception handling
    • SQL reference
      • SQL overview
      • SQL syntax
        • System tenants
          • Overview of management commands
          • ALTER SYSTEM
            • ACTIVATE STANDBY
            • ADD REPLICA
            • ADD RESTORE SOURCE
            • ARCHIVELOG
            • ARBITRATION
            • BOOTSTRAP
            • BACKUP KEY
            • BACKUP
            • BACKUP CLUSTER PARAMETERS
            • BALANCE TASK
            • BALANCE JOB
            • CANCEL BACKUP
            • CANCEL DELETE BACKUP
            • CANCEL MIGRATE UNIT
            • CANCEL REPLICA TASK
            • CANCEL RESTORE
            • CANCEL RECOVER TABLE
            • CANCEL TRANSFER PARTITION
            • CANCEL VALIDATE
            • CLEAR RESTORE SOURCE
            • CREATE LS
            • DELETE BACKUP ALL
            • DELETE BACKUPSET/ARCHIVELOG_PIECE
            • DELETE OBSOLETE BACKUP
            • LOAD MODULE DATA
            • MAJOR and MINOR
            • MIGRATE REPLICA
            • MIGRATE UNIT
            • MODIFY LS
            • MODIFY PAXOS_REPLICA_NUM
            • MODIFY REPLICA
            • NOARCHIVELOG
            • FLUSH PLAN CACHE
            • FLUSH SEQUENCE CACHE
            • FLUSH SS_LOCAL_CACHE
            • FLUSH ss_micro_cache
            • FLASHBACK STANDBY LOG
            • JOB
            • SET LOG_RESTORE_SOURCE
            • PARAMETER
            • RECOVER STANDBY
            • RECOVER STANDBY CANCEL
            • REMOVE REPLICA
            • REFRESH
            • RESTORE
            • RESTORE PREVIEW
            • RECOVER TABLE
            • SET DATA_BACKUP_DEST
            • SERVER
            • SERVICE_NAME
            • SWITCHOVER
            • SET LOG_ARCHIVE_DEST
            • SET LOG_ARCHIVE_DEST_STATE
            • THROTTLE
            • TRANSFER PARTITION
            • TTL
            • VALIDATE
            • WASH MEMORY FRAGMENTATION
            • ZONE
          • ALTER RESOURCE POOL
          • ALTER RESOURCE TENANT
          • ALTER RESOURCE UNIT
          • ALTER TENANT
          • CREATE RESOURCE POOL
          • CREATE RESOURCE UNIT
          • CREATE TENANT
          • CREATE STANDBY TENANT
          • DROP RESOURCE POOL
          • DROP RESOURCE UNIT
          • DROP TENANT
          • SET DECRYPTION
          • SET ENCRYPTION
          • SHOW RESTORE PREVIEW
        • User tenants (MySQL-compatible mode)
          • Basic elements
            • Data types
              • Data types
              • Numeric types
                • Overview of numeric types
                • Integer types
                • Fixed-point types
                • Floating-point types
                • BIT Value
              • Datetime types
                • Overview of datetime types
                • DATE, DATETIME, and TIMESTAMP types
                • TIME type
                • YEAR type
              • String types
                • Overview of string types
                • CHAR and VARCHAR
                • BINARY and VARBINARY
              • Large objects and text types
                • Overview of large objects and text types
                • BLOB type
                • TEXT types
                • STRING type
                • LOB types
              • ENUM type
              • Set types
              • JSON data types
                • Overview of JSON data types
                • Create a JSON value
                • Query and modify JSON values
                • Convert data types to JSON
                • Update JSON data
                • Semi-structured encoding
              • Spatial data types
                • Overview of spatial data types
                • Spatial reference systems (SRS)
                • Create spatial columns
                • Create spatial indexes
                • Spatial data formats
              • Roaring bitmap types
                • Overview of the RoaringBitmap data type
                • Create a roaring bitmap column
              • Array data types
                • Overview of array element types
                • Create an array column
              • Map data types
                • Overview of mapping data types
                • Create a mapped column
            • Expressions
              • Overview of expressions
              • Expression syntax
              • Data type conversion rules
            • Character set and collation
              • Overview
              • Character Sets
              • Character sets
              • Database-level character set and collation
              • Table-level character set and collation
              • Column-level character sets and collations
              • Character set and collation of character expressions
              • Character set and collation for client connections
            • Literals
              • Literals
              • String literals
              • Numeric values
              • Date and time values
              • Bit values
              • Boolean values
              • NULL values
            • Schema object names
            • Annotations
              • Hints
                • Overview
                • Use Query Block Name and QB_NAME Hint to control query optimization
                • Hint list
                  • Global hints
                    • Optimizer Stats Hint under the Global Hint Type
                    • Transform Hint in the Global Hints section
                    • Other hints under the global hint type
                  • Optimizer hints
                    • Access path hints in the Optimized Hint category
                    • Join order hints in the Optimized Hint category
                    • Join operation hints in the Optimized Hint category
                    • Subquery hints under the Optimized Hint category
                    • Group By Hint in the Optimized Hint category
                    • Distinct hint
                    • Set Hint in Optimized Hint Type
                    • Distributed DML hints in the Optimized Hint category
                    • Vector Index Hint in the Optimized Hint category
                  • Transform hints
                    • Stmt Transform Hint
                    • Cost-based transform hints
                    • Heuristics transform hints
                    • Other hints under the Transform Hint type
                  • Outline-related hints
            • User-defined variables
            • Comments
          • Operators
            • Overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operator
            • Date and time operators
            • Character concatenation operators
            • BINARY conversion operators
            • CASE conditional operator
          • Functions
            • Function overview
            • Single-row functions
              • Datetime functions
                • ADDDATE
                • CONVERT_TZ
                • CURDATE
                • CURRENT_DATE
                • CURRENT_TIME
                • CURRENT_TIMESTAMP
                • CURTIME
                • DATE
                • DATE_ADD
                • DATE_FORMAT
                • DATE_SUB
                • DATEDIFF
                • DAYOFMONTH
                • DAYOFWEEK
                • DAYOFYEAR
                • EXTRACT
                • FROM_DAYS
                • FROM_UNIXTIME
                • GET_FORMAT
                • HOUR
                • LAST_DAY
                • LOCALTIME
                • LOCALTIMESTAMP
                • MAKEDATE
                • MAKETIME
                • MICROSECOND
                • MINUTE
                • MONTH
                • MONTHNAME
                • NOW
                • PERIOD_ADD
                • PERIOD_DIFF
                • QUARTER
                • SEC_TO_TIME
                • SECOND
                • STR_TO_DATE
                • SUBDATE
                • SUBTIME
                • SYSDATE
                • TIME
                • TIME_FORMAT
                • TIME_TO_SEC
                • TIME_TO_USEC
                • TIMEDIFF
                • TIMESTAMP
                • TIMESTAMPADD
                • TIMESTAMPDIFF
                • TO_DAYS
                • TO_SECONDS
                • UNIX_TIMESTAMP
                • USEC_TO_TIME
                • UTC_DATE
                • UTC_TIME
                • UTC_TIMESTAMP
                • WEEK
                • WEEKDAY
                • WEEKOFYEAR
                • YEARWEEK
                • YEAR
                • ADDTIME
                • DAYNAME
                • DAY
                • DATE_TRUNC
                • MONTHS_ADD
                • FORMATDATETIME
                • TOUNIXTIMESTAMP
              • String functions
                • ASCII
                • BIN
                • BIT_LENGTH
                • CHAR
                • CHAR_LENGTH
                • CHARACTER_LENGTH
                • CONCAT
                • CONCAT_WS
                • ELT
                • EXPORT_SET
                • FIELD
                • FIND_IN_SET
                • FORMAT
                • HEX
                • INSERT
                • INSTR
                • INT2IP
                • IP2INT
                • KEYVALUE
                • LCASE
                • LEFT
                • LENGTH
                • LOCATE
                • LOWER
                • LPAD
                • LTRIM
                • MAKE_SET
                • MAX_PT
                • MD5_CONCAT_WS
                • MID
                • OCT
                • OCTET_LENGTH
                • ORD
                • POSITION
                • QUOTE
                • REGEXP
                • REGEXP_INSTR
                • REGEXP_LIKE
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPEAT
                • REPLACE
                • REVERSE
                • RIGHT
                • RLIKE
                • RPAD
                • RTRIM
                • SPACE
                • SPLIT_PART
                • STRCMP
                • SUBSTR
                • SUBSTRING
                • SUBSTRING_INDEX
                • TRIM
                • UCASE
                • UNHEX
                • UPPER
                • URL_DECODE
                • URL_ENCODE
                • WEIGHT_STRING
                • TO_BASE64
                • FROM_BASE64
                • SOUNDEX
                • EDITDISTANCE
              • Conversion functions
                • CAST
                • CONVERT
                • DECODE_TRACE_ID
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_CHAR(character)
                • TO_CHAR(number)
                • TO_CHAR(datetime)
                • TO_DATE
              • Mathematical functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BIT_COUNT
                • CEIL
                • CEILING
                • CONV
                • COS
                • COT
                • CRC32
                • DEGREES
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • LOG
                • LOG10
                • LOG2
                • MOD
                • NEG
                • NORMAL
                • PI
                • POW
                • POWER
                • RADIANS
                • RAND
                • RANDOM
                • RANDSTR
                • ROUND
                • SIGN
                • SIN
                • SQRT
                • TAN
                • TRUNCATE
                • UNIFORM
                • ZIPF
              • Comparison functions
                • GREATEST
                • INTERVAL
                • ISNULL
                • LEAST
              • Process control functions
                • CASE
                • IF
                • IFNULL
                • NULLIF
                • ORA_DECODE
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • ARG_MAX
              • ARG_MIN
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • ARBITRARY
              • ANY
              • GROUPCONCAT
              • STDDEVSAMP
              • UNIQ
              • VARSAMP
            • Analysis functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • LAG
              • LAST_VALUE
              • LEAD
              • MAX
              • MIN
              • NTH_VALUE
              • NTILE
              • PERCENT_RANK
              • PERCENTILE_CONT
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • LAGINFRAME
              • LEADINFRAME
            • Encryption functions
              • AES_DECRYPT
              • AES_ENCRYPT
              • COMPRESS
              • DECODE
              • DES_DECRYPT
              • DES_ENCRYPT
              • ENCODE
              • ENCRYPT
              • ENHANCED_AES_ENCRYPT
              • ENHANCED_AES_DECRYPT
              • MD5
              • PASSWORD
              • UNCOMPRESS
              • UNCOMPRESSED_LENGTH
              • RANDOM_BYTES
              • SHA
              • SHA1
              • SHA2
              • VALIDATE_PASSWORD_STRENGTH
              • SM3
              • SM4_ENCRYPT
              • SM4_DECRYPT
            • Information functions
              • BENCHMARK
              • CHARSET
              • COERCIBILITY
              • COLLATION
              • CONNECTION_ID
              • CURRENT_ROLE
              • CURRENT_USER
              • DATABASE
              • FOUND_ROWS
              • LAST_INSERT_ID
              • LAST_INSERT_ID Behavior Description
              • ICU_VERSION
              • OB_TRANSACTION_ID
              • ROW_COUNT
              • SCHEMA
              • SESSION_USER
              • SYSTEM_USER
              • USER
              • VERSION
              • OB_VERSION
            • JSON functions
              • JSON functions
              • Functions for creating JSON text
                • JSON_ARRAY
                • JSON_OBJECT
                • JSON_QUOTE
              • Functions for searching JSON text
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_OVERLAPS
                • JSON_SEARCH
                • JSON_VALUE
                • MEMBER OF
              • Functions for modifying JSON text
                • JSON_ARRAY_APPEND
                • JSON_APPEND
                • JSON_ARRAY_INSERT
                • JSON_INSERT
                • JSON_MERGE
                • JSON_MERGE_PATCH
                • JSON_MERGE_PRESERVE
                • JSON_REMOVE
                • JSON_REPLACE
                • JSON_SET
                • JSON_UNQUOTE
              • Functions for returning JSON text properties
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON_TABLE function
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
              • JSON schema validation functions
                • JSON_SCHEMA_VALID
                • JSON_SCHEMA_VALIDATION_REPORT
            • XML functions
              • Overview of XML functions
              • Functions for querying XML data
                • EXTRACTVALUE
              • Functions for modifying XML data
                • UPDATEXML
            • Table functions
              • Overview of TABLE FUNCTIONS
              • FILES table function
            • Spatial functions
              • Overview of spatial functions
              • Create a geometry value function
              • Spatial operation functions
              • Spatial relationship functions
              • Geometry attribute functions
              • Geometry format conversion functions
              • Spatial analysis functions
              • Spatial constructor functions
              • Spatial accessor functions
              • Spatial format conversion functions
              • Spatial processing functions
              • _ST_GeoHash
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIME
            • Lock functions
              • Overview of lock functions
              • GET_LOCK
              • IS_FREE_LOCK
              • IS_USED_LOCK
              • RELEASE_ALL_LOCKS()
              • RELEASE_LOCK
            • Bitmap functions
              • Overview
              • RoaringBitmap constructor
              • Bitmap cardinality calculation functions
              • Bitmap operation functions
              • Bitmap decision functions
              • Bitmap output functions
              • Bitmap aggregate functions
            • Array functions
              • Overview of array functions
              • Array constructor functions
              • Array decision functions
              • Array output functions
              • Array functions
            • Text processing functions
              • TOKENIZE
            • Audit functions
              • Overview
              • AUDIT_LOG_FILTER_REMOVE_FILTER
              • AUDIT_LOG_FILTER_REMOVE_USER
              • AUDIT_LOG_FILTER_SET_FILTER
              • AUDIT_LOG_FILTER_SET_USER
            • Map functions
              • Overview of mapping functions
              • Map constructors and operators
              • Map decision functions
              • Map operation functions
            • Other functions
              • ANY_VALUE
              • BIN_TO_UUID
              • COALESCE
              • DEFAULT
              • NAME_CONST
              • INET_ATON
              • INET_NTOA
              • INET6_ATON
              • INET6_NTOA
              • IS_IPV4
              • IS_IPV4_COMPAT
              • IS_IPV6
              • IS_UUID
              • MATCH AGAINST
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
              • ISNAN
          • Queries and subqueries
            • Overview
            • Subqueries
            • Join
            • Full-text search
          • SQL statements
            • General syntax
            • Common table expressions
            • ALTER COMPILE
            • ALTER DATABASE
            • ALTER LOCATION
            • ALTER MATERIALIZED VIEW
            • ALTER MATERIALIZED VIEW LOG
            • ALTER EXTERNAL TABLE
            • ALTER OUTLINE
            • ALTER SENSITIVE RULE
            • ALTER SEQUENCE
            • ALTER/CHANGE/MODIFY EXTERNAL_STORAGE_DEST
            • ALTER SYSTEM FLUSH SEQUENCE CACHE
            • MAJOR and MINOR
            • STORAGE_CACHE_POLICY_EXECUTOR
            • VALIDATE
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER TABLESPACE
            • ALTER USER
            • ALTER VIEW
            • ALTER INSTANCE ROTATE INNODB MASTER KEY
            • ALTER EVENT
            • ANALYZE
            • CACHE INDEX
            • CREATE CONCURRENT_LIMITING_RULE
            • CREATE DATABASE LINK
            • CREATE DATABASE
            • CREATE EXTERNAL CATALOG
            • CREATE EXTERNAL TABLE
            • CREATE INDEX
            • CREATE LOCATION
            • CREATE MATERIALIZED VIEW
            • CREATE MATERIALIZED VIEW LOG
            • CREATE OUTLINE
            • CREATE FORMAT OUTLINE
            • CREATE RESTORE POINT
            • CREATE ROLE
            • CREATE SENSITIVE RULE
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE TABLESPACE
            • CREATE USER
            • CREATE VIEW
            • CHECKSUM TABLE
            • CREATE EVENT
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP CATALOG
            • DROP CONCURRENT_LIMITING_RULE
            • DROP DATABASE
            • DROP EVENT
            • DROP INDEX
            • DROP LOCATION
            • DROP MATERIALIZED VIEW
            • DROP MATERIALIZED VIEW LOG
            • DROP OUTLINE
            • DROP ROLE
            • DROP SENSITIVE RULE
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP TABLESPACE
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • DROP RESTORE POINT
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • FLUSH TABLE
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOAD_FILE
            • LOAD INDEX INTO CACHE
            • LOCK TABLES
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REPAIR TABLE
            • REMOVE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SELECT
              • SELECT
              • JOIN clause
              • WINDOW clause
              • UNION clause
              • HYBRID_SEARCH
            • SET DEFAULT ROLE
            • SET
            • SET CATALOG
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET ROLE
            • SET TRANSACTION
            • SHOW
            • SUBMIT JOB
            • SHOW JOB STATUS
            • CANCEL JOB
            • TRANSACTION
            • TRUNCATE TABLE
            • UNLOCK TABLES
            • UPDATE
            • USE
            • VALUES
            • XA transaction
          • DDL feature
            • Overview of DDL operations
            • Online DDL 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
            • NUMBER type conversion rules
          • Pseudo columns
            • Overview
            • PARTITIONID pseudo column
        • User tenants (Oracle-compatible mode)
          • Pseudo columns
            • Overview
            • Hierarchical query pseudo-columns
            • Sequence pseudo-column
            • ORA_ROWSCN pseudo-column
            • ROWNUM pseudo-column
            • ROWID pseudo-column
            • PARTITIONID pseudo column
          • Basic elements
            • Built-in data types
              • Overview of built-in data types
              • Character data types
                • Overview of character data types
                • CHAR data type
                • NCHAR data type
                • NVARCHAR2 data type
                • VARCHAR2 data type
                • VARCHAR data type
              • Numeric data types
                • Overview of numeric data types
                • NUMBER data type
                • FLOAT data type
                • Floating-point numbers
                • Numeric type priorities
              • Datetime and interval data types
                • Overview of datetime and interval data types
                • DATE data type
                • TIMESTAMP data type
                • TIMESTAMP WITH TIME ZONE data type
                • TIMESTAMP WITH LOCAL TIME ZONE data type
                • INTERVAL YEAR TO MONTH data type
                • INTERVAL DAY TO SECOND data type
                • Calculation of DATE and INTERVAL values
              • RAW data type
              • Large object data types
                • Overview of large object data types
                • BLOB data type
                • CLOB data type
                • LOB types
              • Rowid data type
              • User-defined data types
              • Any types
              • JSON data types
                • Overview of JSON data types
                • Create a column of the JSON data type
                • Query JSON data
                • Conversion rules for JSON data type
              • XML data types
                • Overview of the XMLType data type
                • XML data definition
                • Create a column of the XMLType data type
                • Query XMLType data
                • Conversion of the XMLType data type
              • Spatial data types
                • Overview of spatial data types
                • Create spatial columns
                • Access SDO_GEOMETRY properties
                • Create spatial indexes
            • Data type comparison rules
              • Overview of data type comparison rules
              • Comparison rules of numeric values
              • Date value comparison rules
              • Character value comparison rules
              • Data type priority
              • Data type conversion rules
              • Security considerations for data conversion in Oracle mode
            • Literals
              • Literals
              • Text literals
              • Numeric literals
              • Datetime literals
                • DATE literals
                • TIMESTAMP literals
              • INTERVAL literals
            • Format model
              • Formatting models
              • Number format models
              • Datetime format model
              • RR date-time format element
              • Conversion rules from string to date
            • NULL value
              • Overview of empty values
              • Null values in SQL functions
              • NULL values in comparison conditions
              • NULL values in conditional expressions
            • Annotations
              • Overview
              • Comments on SQL statements
              • Comment on schema and nonschema objects
              • Hints
                • Overview of hints
                • Control query optimization by using Query Block Name and QB_NAME Hint
                • Hint list
                  • Global hints
                    • Optimizer Stats Hint under Global Hints
                    • Transform Hint in Global Hints
                    • Other hints under the global hint type
                  • Optimized hints
                    • Access path hints in the Optimized Hint category
                    • Join Order Hints
                    • Join operation hints in the Optimized Hint category
                    • Subquery hints under the Optimized Hint category
                    • Group By Hint in the Optimized Hint category
                    • DISTINCT hint
                    • Set Hint
                    • Distributed DML hint in the Optimized Hint category
                  • Transform hints
                    • Stmt Transform Hint in the Transform Hint Type
                    • Cost based transform hints
                    • Heuristics transform hints
                    • Other TRANSFORM Hint
                  • Outline-related hints
            • Database objects
              • Schema objects
              • Non-schema objects
            • Database naming conventions
              • Overview of database object naming conventions
              • Schema object naming recommendations
            • Database object reference methods
              • Overview of database object references
              • Reference schema objects
              • Reference objects in a remote database
                • Create a database link
                • Database links
              • Reference partitioned tables and indexes
              • Reference attributes and methods of object types
            • Character sets and collations
          • Operators
            • Overview of operators
            • Operator precedence
            • Arithmetic operators
            • Concatenation operators
            • Hierarchical query operators
            • Set operators
            • COLLATE operator
          • Functions
            • Function overview
            • Single-row functions
              • Numeric functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BITAND
                • CEIL
                • COS
                • COSH
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • 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
                • CHR
                • CONCAT
                • INITCAP
                • LOWER
                • LPAD
                • LTRIM
                • MAX_PT
                • NLS_LOWER
                • NLSSORT
                • NLS_UPPER
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPLACE
                • RPAD
                • RTRIM
                • SUBSTR
                • TRANSLATE
                • TRANSLATE ... USING
                • TRIM
                • UPPER
              • String functions that return numbers
                • ASCII
                • INSTR
                • LENGTH
                • 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
                • DECODE
                • DUMP
                • ORA_HASH
                • VSIZE
              • Null value related functions
                • COALESCE
                • LNNVL
                • NANVL
                • NULLIF
                • NVL
                • NVL2
              • Environment and identifier functions
                • SYS_CONTEXT
                • SYS_GUID
                • UID
                • USER
                • USERENV
                • OB_VERSION
              • Hierarchical functions
                • SYS_CONNECT_BY_PATH
              • JSON functions
                • JSON functions
                • Create JSON text functions
                  • JSON_ARRAY
                  • JSON_OBJECT
                  • JSON_ARRAYAGG
                  • JSON_OBJECTAGG
                • Query JSON text functions
                  • JSON_VALUE
                  • JSON_QUERY
                  • JSON_EXISTS
                  • JSON_TABLE
                • Validate JSON text functions
                  • JSON_EQUAL
                • Modify JSON text functions
                  • JSON_MERGEPATCH
              • XML functions
                • Overview of XML functions
                • Construct XMLType data functions
                  • XMLAGG
                  • XMLATTRIBUTES
                  • XMLELEMENT
                  • XMLPARSE
                  • XMLCONCAT
                  • XMLFOREST
                • Query XMLType data functions
                  • EXTRACT
                  • EXTRACTVALUE
                  • XMLSERIALIZE
                  • XMLCAST
                  • XMLTABLE
                  • XMLSEQUENCE
                  • EXISTSNODE
                • Modify XMLType data functions
                  • UPDATEXML
                  • INSERTCHILDXML
                  • DELETEXML
              • Spatial functions
                • Spatial functions
                • Constructor functions
                • SDO_GEOMETRY query functions
                • Format conversion functions
            • 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
              • GROUP_ID
              • GROUPING_ID
            • Analysis functions
              • Analytic function description
              • AVG
              • ARG_MIN
              • ARG_MAX
              • 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
            • Information functions
              • OB_TRANSACTION_ID
            • Table functions
              • Overview of TABLE FUNCTIONS
              • FILES table function
          • Expressions
            • Overview
            • Simple expressions
            • Compound expressions
            • Conditional expressions
            • Column expressions
            • CURSOR Expressions
            • Datetime expressions
            • Function expressions
            • Interval expressions
            • Scalar Subquery Expression
            • Type constructor expressions
            • Expression list
          • Conditions
            • Overview of SQL conditions
            • Condition priority
            • Comparison conditions
            • Floating-point conditions
            • Logical conditions
            • Pattern-matching conditions
            • Null conditions
            • Compound conditions
            • BETWEEN condition
            • EXISTS condition
            • IN condition
          • Queries and subqueries
            • Overview of queries and subqueries
            • Simple query
            • Hierarchical queries
            • Composite queries
            • Join queries
            • Subqueries
            • Lateral derived tables
            • Query the DUAL table
          • SQL statements
            • DDL
              • ALTER EXTERNAL TABLE
              • ALTER INDEX
              • ALTER KEYSTORE
              • ALTER LOCATION
              • ALTER MATERIALIZED VIEW
              • ALTER MATERIALIZED VIEW LOG
              • ALTER OUTLINE
              • ALTER PROFILE
              • ALTER ROLE
              • ALTER SENSITIVE RULE
              • ALTER SEQUENCE
              • ALTER SESSION
              • ALTER SYSTEM FLUSH
              • ALTER SYSTEM FLUSH CACHE
              • ALTER/CHANGE/MODIFY EXTERNAL_STORAGE_DEST
              • ALTER SYSTEM FLUSH SEQUENCE CACHE
              • ALTER SYSTEM SET PARAMETER
              • VALIDATE
              • ALTER TABLE
              • ALTER TABLEGROUP
              • ALTER TABLESPACE
              • ALTER USER
              • COMMENT
              • CREATE CONTEXT
              • CREATE CONCURRENT_LIMITING_RULE
              • CREATE DIRECTORY
              • CREATE DATABASE LINK
              • CREATE EXTERNAL TABLE
              • CREATE INDEX
              • CREATE KEYSTORE
              • CREATE LOCATION
              • CREATE MATERIALIZED VIEW
              • CREATE MATERIALIZED VIEW LOG
              • CREATE OUTLINE
              • CREATE PROFILE
              • CREATE FORMAT OUTLINE
              • CREATE ROLE
              • CREATE SENSITIVE RULE
              • CREATE SEQUENCE
              • CREATE SYNONYM
              • CREATE TABLE
              • CREATE TABLEGROUP
              • CREATE TABLESPACE
              • CREATE USER
              • CREATE VIEW
              • DROP CONTEXT
              • DROP CONCURRENT_LIMITING_RULE
              • DROP DATABASE LINK
              • DROP DIRECTORY
              • DROP INDEX
              • DROP LOCATION
              • DROP MATERIALIZED VIEW
              • DROP MATERIALIZED VIEW LOG
              • DROP OUTLINE
              • DROP PROFILE
              • DROP ROLE
              • DROP SENSITIVE RULE
              • DROP SEQUENCE
              • DROP SYNONYM
              • DROP TABLE
              • DROP TABLEGROUP
              • DROP TABLESPACE
              • DROP USER
              • DROP VIEW
              • RENAME
              • TRUNCATE TABLE
              • MAJOR and MINOR
            • DML
              • DELETE
              • INSERT
              • MERGE
              • PURGE
              • EXPLAIN
              • SELECT
                • SIMPLE SELECT
                • Collection SELECT
                • WITH CLAUSE
                • JOIN clause
                • APPLY clause
              • UPDATE
            • DCL
              • ANALYZE
              • ALTER SYSTEM KILL SESSION
              • AUDIT
              • COMMIT
              • FLASHBACK TABLE BEFORE DROP
              • GRANT
              • KILL
              • LOAD DATA
              • LOCK TABLE
              • REMOVE
              • REVOKE
              • ROLLBACK
              • SAVEPOINT
              • SELECT INTO
              • SET NAMES
              • SET PASSWORD
              • SET ROLE
              • SET VARIABLE
              • SHOW
              • SHRINK
              • TRANSACTION
          • DDL feature
            • Overview of DDL operations
            • Online and offline DDL operations
            • Index operations
            • Primary key operations
            • Column operations
            • Operations on generated columns
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
            • NUMBER type conversion rules
      • SQL specifications and practices
        • SQL writing restrictions
        • SQL writing specifications
          • SELECT statement writing specification
          • DML statement writing specifications
          • DDL statement writing specifications
          • Multi-table association specification
          • Table scanning mode specification
          • Transaction-related specifications
          • Cache usage specifications
          • Guidelines for using hints
          • Other specifications
        • SQL statement examples
          • Implicit type conversion
          • JOIN table usage suggestions
          • Weak-consistency read
          • Pagination
      • Reserved keywords (MySQL mode)
      • Reserved keywords (Oracle mode)
      • Data type conversion behavior of a MySQL tenant in strict mode
    • PL reference
      • What is PL
        • PL overview
        • Main features of PL
        • PL architecture
      • PL reference (MySQL-compatible mode)
        • PL syntax
        • PL stored procedures
          • Overview of PL stored programs
          • Variables in stored programs
          • Stored procedures
          • Manage stored routines and privileges
          • Stored functions
          • External storage functions
          • Triggers
          • EVENT
          • Stored program usage restrictions
          • SQL Transpiler
          • PL asynchronous commit optimization
        • PL cursors
          • Overview
          • Cursor execution process
          • Server-side cursor usage limits
        • PL conditional control statements
          • CASE
          • IF
          • ITERATE
          • LEAVE
          • LOOP
          • REPEAT
          • RETURN
          • WHILE
        • PL data manipulation statements
          • CALL
          • DO
        • PL data definition statements
          • ALTER FUNCTION
          • ALTER PROCEDURE
          • CREATE FUNCTION
          • CREATE PROCEDURE
          • CREATE TRIGGER
          • DROP FUNCTION
          • DROP PROCEDURE
          • DROP TRIGGER
        • PL database management statements
          • SHOW CREATE FUNCTION
          • SHOW CREATE PROCEDURE
          • SHOW CREATE TRIGGER
          • SHOW FUNCTION STATUS
          • SHOW PROCEDURE STATUS
          • SHOW TRIGGERS
        • PL related dictionary views
          • INFORMATION_SCHEMA PARAMETERS
          • INFORMATION_SCHEMA ROUTINES
          • INFORMATION_SCHEMA TRIGGERS
        • PL exception handling
          • Overview
          • DECLARE ... CONDITION
          • DECLARE ... HANDLER
          • GET DIAGNOSTICS
          • RESIGNAL
          • SIGNAL
          • Scope of procedures
          • Diagnostics area
          • Exception handling and OUT/INOUT parameters
          • Limitations on exception handling
        • PL system packages
          • Oracle Database System Packages Overview
          • DBMS_AI_SERVICE
            • Overview of DBMS_AI_SERVICE
            • CREATE_AI_MODEL
            • DROP_AI_MODEL
            • CREATE_AI_MODEL_ENDPOINT
            • ALTER_AI_MODEL_ENDPOINT
            • DROP_AI_MODEL_ENDPOINT
          • DBMS_DAILY_MAINTENANCE
            • Overview
            • TRIGGER_WINDOW_COMPACTION_PROC
            • SET_THREAD_COUNT
          • DBMS_HYBRID_SEARCH
            • Overview of DBMS_HYBRID_SEARCH
            • SEARCH
            • GET_SQL
          • DBMS_MVIEW
            • Overview of DBMS_MVIEW
            • PURGE_LOG
            • REFRESH
          • DBMS_MVIEW_STATS
            • Overview of DBMS_MVIEW_STATS
            • PURGE_REFRESH_STATS
            • SET_MVREF_STATS_PARAMS
            • SET_SYSTEM_DEFAULT
          • DBMS_PARTITION
            • Overview
            • MANAGE_DYNAMIC_PARTITION
          • DBMS_RESOURCE_MANAGER
            • Overview
            • CREATE_CONSUMER_GROUP
            • CREATE_PLAN
            • CREATE_PLAN_DIRECTIVE
            • COPY_PLAN
            • DELETE_CONSUMER_GROUP
            • DELETE_PLAN
            • DELETE_PLAN_DIRECTIVE
            • System Packages
            • UPDATE_PLAN_DIRECTIVE
          • DBMS_STATS
            • Overview of DBMS_STATS
            • ALTER_STATS_HISTORY_RETENTION
            • CREATE_STAT_TABLE
            • DELETE_COLUMN_STATS
            • DELETE_INDEX_STATS
            • DELETE_TABLE_STATS
            • DELETE_SCHEMA_STATS
            • DELETE_SCHEMA_PREFS
            • DELETE_SYSTEM_STATS
            • DELETE_TABLE_PREFS
            • DROP_STAT_TABLE
            • EXPORT_COLUMN_STATS
            • EXPORT_INDEX_STATS
            • EXPORT_TABLE_STATS
            • EXPORT_SCHEMA_STATS
            • FLUSH_DATABASE_MONITORING_INFO
            • GATHER_INDEX_STATS
            • GATHER_TABLE_STATS
            • GATHER_SCHEMA_STATS
            • GATHER_SYSTEM_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_SYSTEM_STATS
            • SET_TABLE_PREFS
            • UNLOCK_PARTITION_STATS
            • UNLOCK_SCHEMA_STATS
            • UNLOCK_TABLE_STATS
            • CANCEL_GATHER_STATS
            • COPY_TABLE_STATS
          • DBMS_TRUSTED_CERTIFICATE_MANAGER
            • Overview
            • ADD_TRUSTED_CERTIFICATE
            • DELETE_TRUSTED_CERTIFICATE
            • UPDATE_TRUSTED_CERTIFICATE
          • DBMS_UDR
            • Overview
            • CREATE_RULE
            • DISABLE_RULE
            • ENABLE_RULE
            • REMOVE_RULE
          • DBMS_VECTOR
            • Overview of DBMS_VECTOR
            • REFRESH_INDEX
            • REBUILD_INDEX
            • INDEX_VECTOR_MEMORY_ESTIMATE
            • INDEX_VECTOR_MEMORY_ADVISOR
            • FLUSH_INDEX
            • COMPACT_INDEX
          • DBMS_WORKLOAD_REPOSITORY
            • Overview
            • ASH_REPORT
            • CREATE_SNAPSHOT
            • DROP_SNAPSHOT_RANGE
            • MODIFY_SNAPSHOT_SETTINGS
          • DBMS_XPLAN
            • Overview
            • DISPLAY_ACTIVE_SESSION_PLAN
            • DISPLAY_CURSOR
            • DISPLAY
            • DISABLE_OPT_TRACE
            • DISPLAY_SQL_PLAN_BASELINE
            • ENABLE_OPT_TRACE
            • SET_OPT_TRACE_PARAMETER
          • DBMS_XPROFILE
            • Overview of DBMS_XPROFILE
            • DISPLAY_PROFILE
          • DBMS_BALANCE
            • Overview
            • SET_BALANCE_WEIGHT
            • CLEAR_BALANCE_WEIGHT
            • TRIGGER_PARTITION_BALANCE
            • SET_TABLEGROUP_BALANCE_WEIGHT
            • CLEAR_TABLEGROUP_BALANCE_WEIGHT
          • DBMS_LIMIT_CALCULATOR
            • Overview
            • CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT
            • CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES
            • CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT
          • DBMS_EXTERNAL_TABLE
            • Overview of DBMS_EXTERNAL_TABLE
            • AUTO_REFRESH_EXTERNAL_TABLE
          • DBMS_JAVA
            • Overview of DBMS_JAVA
            • LOADJAVA
            • DROPJAVA
          • DBMS_PYTHON
            • Overview
            • DROPPYTHON
            • LOADPYTHON
          • DBMS_DATA_DICT
            • DBMS_DATA_DICT
        • PL reserved and non-reserved keywords
      • PL reference (Oracle-compatible mode)
        • PL language basics
          • Character sets
          • Lexical elements
          • Syntax
          • Reference identifiers
          • Identifier scope and visibility
          • Assignment
          • Expressions
          • PL blocks
          • Subprograms
          • Error reporting functions
        • PL data types
          • Overview
          • SQL data types
          • Large object data types
          • Boolean data type
          • User-defined subtypes
          • PLS_INTEGER and BINARY_INTEGER
          • Arrays
          • PL JSON data types
        • PL process control
          • Overview
          • Conditional control
          • Loop control
          • Sequence control
        • PL collections and records
          • Overview
          • Collections
          • Associative arrays
          • Varrays
          • Nested tables
          • Collection constructors
          • Collection methods
            • Overview
            • DELETE method
            • TRIM method
            • EXTEND method
            • EXISTS method
            • FIRST and LAST methods
            • COUNT method
            • LIMIT method
            • PRIOR and NEXT methods
          • Records
          • Insert and update tables with records
          • Create and invoke subprograms with record-type parameters
        • PL static SQL
          • Overview
          • Cursors
            • Cursor overview
            • Cursor attributes
            • Implicit cursors
            • Explicit cursor
            • Cursor variables
            • Use FOR loops to traverse cursors
            • Modify and delete cursors
          • Transaction processing and control
          • Autonomous transactions
            • Overview
            • Control autonomous transactions
            • Autonomous triggers
            • Call autonomous functions from SQL
          • FORALL and BULK COLLECT
        • PL dynamic SQL
          • Overview
          • Execute dynamic SQL statements
          • DBMS_SQL system package
        • PL stored procedures and functions
          • Overview
          • Create a stored procedure
          • Create a function
          • Manage stored procedures and functions
          • Grant privileges
          • Pipeline functions
            • Overview of pipelined table functions
            • Create a pipeline function
            • Related applications
          • SQL Transpiler
          • User-defined functions
            • Overview
            • User-defined aggregate functions
            • Create a user-defined aggregate function
            • Use user-defined aggregate functions
          • Information collection for stored procedures and parallel execution of SQL statements
          • PL Database Link
          • PL asynchronous commit optimization
        • PL triggers
          • Overview
          • Create a DML trigger
          • Modify and drop triggers
          • Disable and enable a trigger
          • View trigger information
          • INSTEAD OF DML triggers
          • Composite DML triggers
          • System triggers
        • PL packages
          • Overview
          • Create a package
          • Overloaded programs in a package
          • Manage packages
          • Definition of the STANDARD package for PL
        • PL exception handling
          • Overview
          • Compile-Time Warnings
          • Exception types
          • Exception handling order
        • DDL operations on stored PL units
          • Overview
          • ALTER FUNCTION
          • ALTER PACKAGE
          • ALTER PROCEDURE
          • ALTER TRIGGER
          • ALTER TYPE
          • CREATE FUNCTION
          • CREATE PACKAGE
          • CREATE PACKAGE BODY
          • CREATE PROCEDURE
          • CREATE TRIGGER
          • CREATE TYPE
          • CREATE TYPE BODY
          • DROP FUNCTION
          • DROP PACKAGE
          • DROP PROCEDURE
          • DROP TRIGGER
          • DROP TYPE
          • DROP TYPE BODY
        • PL label security package
          • Overview of the PL Label Security package
          • SA_SYSDBA policy management package
            • Overview
            • SA_SYSDBA.ALTER_POLICY
            • SA_SYSDBA.CREATE_POLICY
            • SA_SYSDBA.DROP_POLICY
          • SA_COMPONENTS label component package
            • Overview of the SA_COMPONENTS package
            • SA_COMPONENTS.ALTER_LEVEL
            • SA_COMPONENTS.CREATE_LEVEL
            • SA_COMPONENTS.DROP_LEVEL
          • SA_LABEL_ADMIN label management package
            • Overview
            • SA_LABEL_ADMIN.ALTER_LABEL
            • SA_LABEL_ADMIN.CREATE_LABEL
            • SA_LABEL_ADMIN.DROP_LABEL
          • SA_POLICY_ADMIN policy management package
            • Overview
            • SA_POLICY_ADMIN.APPLY_TABLE_POLICY
            • SA_POLICY_ADMIN.DISABLE_TABLE_POLICY
            • SA_POLICY_ADMIN.ENABLE_TABLE_POLICY
            • SA_POLICY_ADMIN.REMOVE_TABLE_POLICY
          • SA_USER_ADMIN user label management package
            • Overview
            • SA_USER_ADMIN.SET_LEVELS
          • SA_SESSION session management package
            • Overview of SA_SESSION
            • SA_SESSION.LABEL
            • SA_SESSION.RESTORE_DEFAULT_LABELS
            • SA_SESSION.ROW_LABEL
            • SA_SESSION.SET_LABEL
            • SA_SESSION.SET_ROW_LABEL
        • PL system package (Oracle-compatible mode)
          • Overview
          • DBMS_APPLICATION_INFO
            • Overview
            • READ_CLIENT_INFO
            • READ_MODULE
            • SET_ACTION
            • SET_CLIENT_INFO
            • SET_MODULE
          • DBMS_AUDIT_MGMT
            • Overview of DBMS_AUDIT_MGMT
            • CLEAN_AUDIT_TRAIL
            • CREATE_PURGE_JOB
            • DROP_PURGE_JOB
            • SET_LAST_ARCHIVE_TIMESTAMP
            • SET_PURGE_JOB_STATUS
          • DBMS_BALANCE
            • Overview of DBMS_BALANCE
            • SET_BALANCE_WEIGHT
            • CLEAR_BALANCE_WEIGHT
            • TRIGGER_PARTITION_BALANCE
          • DBMS_CRYPTO
            • Overview of DBMS_CRYPTO
            • ENCRYPT
            • DECRYPT
            • HASH
          • DBMS_DAILY_MAINTENANCE
            • Overview of DBMS_DAILY_MAINTENANCE
            • TRIGGER_WINDOW_COMPACTION_PROC
            • SET_THREAD_COUNT
          • 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_LOB
            • Overview of DBMS_LOB
            • APPEND
            • CLOSE
            • COPY
            • CREATETEMPORARY
            • ERASE
            • FREETEMPORARY
            • GETLENGTH
            • ISOPEN
            • INSTR
            • ISTEMPORARY
            • OPEN
            • READ
            • SUBSTR
            • TRIM
            • WRITE
            • WRITEAPPEND
            • CONVERTTOBLOB
          • DBMS_LOCK
            • Overview of DBMS_LOCK
            • ALLOCATE_UNIQUE
            • ALLOCATE_UNIQUE_AUTONOMOUS
            • REQUEST
            • SLEEP
            • RELEASE
          • DBMS_METADATA
            • Overview of DBMS_METADATA
            • GET_DDL
            • GET_TABLE_INDEX_DDL
          • DBMS_MVIEW
            • Overview of DBMS_MVIEW
            • PURGE_LOG
            • REFRESH
          • DBMS_MONITOR
            • Overview of DBMS_MONITOR
            • OB_SESSION_TRACE_ENABLE
            • OB_SESSION_TRACE_DISABLE
            • OB_CLIENT_ID_TRACE_ENABLE
            • OB_CLIENT_ID_TRACE_DISABLE
            • OB_MOD_ACT_TRACE_ENABLE
            • OB_MOD_ACT_TRACE_DISABLE
            • OB_TENANT_TRACE_ENABLE
            • OB_TENANT_TRACE_DISABLE
          • DBMS_MVIEW_STAT
            • Overview of DBMS_MVIEW_STATS
            • PURGE_REFRESH_STATS
            • SET_MVREF_STATS_PARAMS
            • SET_SYSTEM_DEFAULT
          • DBMS_OUTPUT
            • Overview of DBMS_OUTPUT
            • DISABLE
            • ENABLE
            • GET_LINE
            • GET_LINES
            • NEW_LINE
            • PUT
            • PUT_LINE
          • DBMS_PLAN_CACHE
            • Overview of DBMS_PLAN_CACHE
            • PURGE
          • DBMS_PLSQL_CODE_COVERAGE
            • Overview
            • START_COVERAGE
            • STOP_COVERAGE
            • CREATE_COVERAGE_TABLES
          • DBMS_PARTITION
            • DBMS_PARTITION overview
            • MANAGE_DYNAMIC_PARTITION
          • DBMS_RANDOM
            • Overview of DBMS_RANDOM
            • INITIALIZE
            • NORMAL
            • RANDOM
            • SEED
            • STRING
            • TERMINATE
            • VALUE
          • DBMS_RESOURCE_MANAGER
            • Overview
            • CREATE_CONSUMER_GROUP
            • CREATE_PLAN
            • CREATE_PLAN_DIRECTIVE
            • COPY_PLAN
            • DELETE_CONSUMER_GROUP
            • DELETE_PLAN
            • DELETE_PLAN_DIRECTIVE
            • SET_CONSUMER_GROUP_MAPPING
            • UPDATE_PLAN_DIRECTIVE
          • DBMS_SCHEDULER
            • Overview of DBMS_SCHEDULER
            • CREATE_JOB
            • CREATE_JOB_CLASS
            • CREATE_PROGRAM
            • DEFINE_PROGRAM_ARGUMENT
            • DISABLE
            • DROP_JOB
            • DROP_JOB_CLASS
            • DROP_PROGRAM
            • ENABLE
            • GENERATE_JOB_NAME
            • PURGE_LOG
            • RUN_JOB
            • SET_ATTRIBUTE
            • SET_JOB_ARGUMENT_VALUE
            • STOP_JOB
          • DBMS_SESSION
            • Overview
            • CLEAR_ALL_CONTEXT
            • CLEAR_CONTEXT
            • CLEAR_IDENTIFIER
            • RESET_PACKAGE
            • SET_CONTEXT
            • SET_IDENTIFIER
            • SESSION_IS_ROLE_ENABLED
            • IS_ROLE_ENABLED
          • DBMS_SQL
            • Overview of DBMS_SQL
            • BIND_VARIABLE
            • CLOSE_CURSOR
            • COLUMN_VALUE
            • DEFINE_COLUMN
            • DEFINE_ARRAY
            • DESCRIBE_COLUMNS
            • EXECUTE
            • EXECUTE_AND_FETCH
            • FETCH_ROWS
            • IS_OPEN
            • LAST_ERROR_POSITION
            • OPEN_CURSOR
            • PARSE
            • VARIABLE_VALUE
          • 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_SYSTEM_STATS
            • DELETE_TABLE_PREFS
            • DROP_STAT_TABLE
            • EXPORT_COLUMN_STATS
            • EXPORT_INDEX_STATS
            • EXPORT_TABLE_STATS
            • EXPORT_SCHEMA_STATS
            • FLUSH_DATABASE_MONITORING_INFO
            • GATHER_INDEX_STATS
            • GATHER_TABLE_STATS
            • GATHER_SCHEMA_STATS
            • GATHER_SYSTEM_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_SYSTEM_STATS
            • SET_TABLE_PREFS
            • UNLOCK_PARTITION_STATS
            • UNLOCK_SCHEMA_STATS
            • UNLOCK_TABLE_STATS
            • COPY_TABLE_STATS
            • CANCEL_GATHER_STATS
          • DBMS_UDR
            • DBMS_UDR overview
            • CREATE_RULE
            • DISABLE_RULE
            • ENABLE_RULE
            • REMOVE_RULE
          • DBMS_UTILITY
            • Overview of DBMS_UTILITY
            • ACTIVE_INSTANCES
            • CURRENT_INSTANCE
            • DB_VERSION
            • FORMAT_CALL_STACK
            • FORMAT_ERROR_BACKTRACE
            • FORMAT_ERROR_STACK
            • GET_ENDIANNESS
            • GET_HASH_VALUE
            • GET_PARAMETER_VALUE
            • GET_SQL_HASH
            • GET_TIME
            • IS_BIT_SET
            • IS_CLUSTER_DATABASE
            • NAME_RESOLVE
            • NAME_TOKENIZE
            • OLD_CURRENT_SCHEMA
            • OLD_CURRENT_USER
            • PORT_STRING
            • TABLE_TO_COMMA
            • COMMA_TO_TABLE
          • DBMS_WORKLOAD_REPOSITORY
            • Overview of DBMS_WORKLOAD_REPOSITORY
            • ASH_REPORT
          • DBMS_XA
            • DBMS_XA overview
            • Constants of DBMS_XA
            • DBMS_XA_XID object type
            • DIST_TXN_SYNC
            • XA_COMMIT
            • XA_END
            • XA_FORGET
            • XA_GETLASTOER
            • XA_PREPARE
            • XA_RECOVER
            • XA_ROLLBACK
            • XA_SETTIMEOUT
            • XA_START
          • DBMS_XMLGEN
            • Overview of the DBMS_XMLGEN package
            • CONVERT
          • DBMS_PROFILER
            • Overview of DBMS_PROFILER
            • START_PROFILER
            • STOP_PROFILE
            • PAUSE_PROFILER
            • RESUME_PROFILER
            • FLUSH_DATA
            • GET_VERSION
            • INTERNAL_VERSION_CHECK
            • ROLLUP_UNIT
            • ROLLUP_RUN
            • OB_INIT_OBJECTS
            • OB_DROP_OBJECTS
          • DBMS_XPLAN
            • Overview of DBMS_XPLAN
            • DISPLAY_ACTIVE_SESSION_PLAN
            • DISPLAY_CURSOR
            • DISPLAY
            • DISABLE_OPT_TRACE
            • DISPLAY_SQL_PLAN_BASELINE
            • ENABLE_OPT_TRACE
            • SET_OPT_TRACE_PARAMETER
          • DBMS_XPROFILE
            • Overview of DBMS_XPROFILE
            • DISPLAY_PROFILE
          • DBMS_EXTERNAL_TABLE
            • Overview of DBMS_EXTERNAL_TABLE
            • AUTO_REFRESH_EXTERNAL_TABLE
          • DBMS_DDL
            • Overview of DBMS_DDL
            • WRAP
            • CREATE_WRAPPED
          • ODCIConst
            • Overview of ODCIConst
            • ODCIArgDesc.ArgType
            • ODCIEnv.CallProperty
            • ODCIEnv.Envflags
            • ODCIIndexAlter
            • ODCIIndexAlter parameter alter_option
            • ODCIIndexInfo.IndexInfoFlags
            • ODCIIndexInfo.IndexParaDegree
            • ODCIPredInfo.Flags
            • ODCIQueryInfo.Flags
            • ODCIStatsOptions.Flags
            • ODCIStatsOptions.Options
            • Return Status
            • ScnFlg
          • UTL_ENCODE
            • Overview of UTL_ENCODE
            • BASE64_DECODE
            • BASE64_ENCODE
          • UTL_FILE
            • Overview of UTL_FILE
            • FCLOSE
            • FFLUSH
            • FOPEN
            • FGETPOS
            • FREMOVE
            • FRENAME
            • FSEEK
            • NEW_LINE
            • GET_LINE
            • PUT
            • PUT_LINE
          • UTL_I18N
            • Overview of UTL_I18N
            • RAW_TO_CHAR
            • STRING_TO_RAW
          • UTL_RECOMP
            • Overview of UTL_RECOMP
            • RECOMP_PARALLEL
            • RECOMP_SERIAL
            • TRUNCATE_UTL_RECOMP_SKIP_LIST
            • POPULATE_UTL_RECOMP_SKIP_LIST
            • PARALLEL_SLAVE
          • UTL_RAW
            • Overview of UTL_RAW
            • BIT_AND
            • BIT_COMPLEMENT
            • BIT_OR
            • BIT_XOR
            • CAST_FROM_BINARY_DOUBLE
            • CAST_FROM_BINARY_FLOAT
            • CAST_FROM_BINARY_INTEGER
            • CAST_FROM_NUMBER
            • CAST_TO_BINARY_DOUBLE
            • CAST_TO_BINARY_FLOAT
            • CAST_TO_BINARY_INTEGER
            • CAST_TO_NUMBER
            • CAST_TO_RAW
            • CAST_TO_VARCHAR2
            • COMPARE
            • CONCAT
            • COPIES
            • LENGTH
            • REVERSE
            • SUBSTR
            • TRANSLATE
          • UTL_TCP
            • Overview of UTL_TCP
            • OPEN_CONNECTION
            • CLOSE_CONNECTION
            • CLOSE_ALL_CONNECTIONS
            • WRITE_LINE
            • WRITE_TEXT
            • WRITE_RAW
            • GET_LINE
            • GET_TEXT
          • UTL_SMTP
            • Overview of UTL_SMTP
            • OPEN_CONNECTION
            • CLOSE_CONNECTION
            • QUIT
            • AUTH
            • COMMAND
            • COMMAND_REPLIES
            • HELO
            • EHLO
            • MAIL
            • RCPT
            • OPEN_DATA
            • WRITE_DATA
            • WRITE_RAW_DATA
            • CLOSE_DATA
            • DATA
            • VRFY
            • HELP
            • NOOP
            • RSET
          • UTL_HTTP
            • Overview of UTL_HTTP
            • BEGIN_REQUEST
            • END_REQUEST
            • GET_RESPONSE
            • END_RESPONSE
            • READ_LINE
            • READ_RAW
            • READ_TEXT
            • WRITE_LINE
            • WRITE_RAW
            • WRITE_TEXT
            • SET_TRANSFER_TIMEOUT
            • GET_TRANSFER_TIMEOUT
          • ANYDATA TYPE
            • Overview of the ANYDATA type
            • BEGINCREATE static stored procedure
            • ENDCREATE member stored procedure
            • GET* member function
            • GETTYPE member function
            • GETTYPENAME member function
            • PIECEWISE member stored procedure
            • SET* member stored procedure
          • XMLType
            • Overview
            • CREATEXML
            • GETCLOBVAL
            • GETSTRINGVAL
            • TRANSFORM
            • XMLTYPE
            • EXISTSNODE
            • EXTRACT
        • PL reserved keywords
    • System views
      • Overview
      • Overview of system views
      • View changes in V3.x and V4.x
      • SYS tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_CKPT_HISTORY
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • CDB_INDEX_USAGE
          • oceanbase.CDB_INDEXES
          • CDB_MVIEW_LOGS
          • oceanbase.CDB_MVIEW_RUNNING_JOBS
          • CDB_MVIEWS
          • CDB_MVREF_CHANGE_STATS
          • CDB_MVREF_RUN_STATS
          • CDB_MVREF_STATS
          • CDB_MVREF_STATS_PARAMS
          • CDB_MVREF_STATS_SYS_DEFAULTS
          • CDB_MVREF_STMT_STATS
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.CDB_OB_AI_MODEL_ENDPOINTS
          • oceanbase.CDB_OB_AI_MODELS
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • CDB_OB_AUX_STATISTICS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BACKUP_VALIDATE_JOBS
          • oceanbase.CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_VALIDATE_TASKS
          • oceanbase.CDB_OB_BACKUP_VALIDATE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_CCL_RULES
          • oceanbase.CDB_OB_CS_REPLICA_STATS
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_TASKS
          • oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_KV_TTL_TASKS
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.CDB_OB_LS
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_RECOVER_TABLE_JOBS
          • oceanbase.CDB_OB_SERVICES
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_RSRC_DIRECTIVES
          • oceanbase.CDB_OB_SENSITIVE_COLUMNS
          • oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.CDB_OB_SENSITIVE_RULES
          • oceanbase.CDB_OB_SERVER_SPACE_USAGE
          • oceanbase.CDB_OB_SPACE_USAGE
          • oceanbase.CDB_OB_SS_SPACE_USAGE
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_STORAGE_IO_USAGE
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_TABLE_SPACE_USAGE
          • oceanbase.CDB_OB_TEMP_FILES
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TTL_TASKS
          • oceanbase.CDB_OB_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_USERS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASKS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.CDB_SUBPART_KEY_COLUMNS
          • oceanbase.CDB_SUBPARTITION_TEMPLATES
          • oceanbase.CDB_TAB_COL_STATISTICS
          • oceanbase.CDB_TAB_COLS
          • oceanbase.CDB_TAB_COLS_V$
          • oceanbase.CDB_TAB_PARTITIONS
          • oceanbase.CDB_TAB_SUBPARTITIONS
          • oceanbase.CDB_TABLES
          • oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.CDB_WR_CONTROL
          • oceanbase.CDB_WR_EVENT_NAME
          • oceanbase.CDB_WR_SNAPSHOT
          • oceanbase.CDB_WR_SQLSTAT
          • oceanbase.CDB_WR_SQLTEXT
          • oceanbase.CDB_WR_STATNAME
          • oceanbase.CDB_WR_SYS_TIME_MODEL
          • oceanbase.CDB_WR_SYSSTAT
          • oceanbase.CDB_WR_SYSTEM_EVENT
          • oceanbase.CDB_OB_EXTERNAL_RESOURCES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • DBA_MVREF_CHANGE_STATS
          • DBA_MVREF_RUN_STATS
          • DBA_MVREF_STATS
          • DBA_MVREF_STATS_PARAMS
          • DBA_MVREF_STATS_SYS_DEFAULTS
          • DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_ARBITRATION_SERVICE
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS
          • oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS
          • oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CLONE_HISTORY
          • oceanbase.DBA_OB_CLONE_PROGRESS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_SS_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • DBA_OB_TRUSTED_ROOT_CERTIFICATE
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OB_ZONE_STORAGE
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_IO_BENCHMARK
          • GV$OB_IO_CALIBRATION_STATUS
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SERVERS
          • GV$OB_SERVER_STORAGE
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$SQL_PLAN_MONITOR
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_SS_LOCAL_CACHE
          • GV$OB_SS_LOCAL_CACHE_DIAGNOSE
          • GV$OB_SS_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_REPLICA_INFO
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TENANT_RUNTIME_INFO
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • gv$tenant
          • gv$tenant_memstore_allocator_info
          • GV$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • GV$UNIT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$ENCRYPTED_TABLESPACES
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_IO_BENCHMARK
          • V$OB_HNSW_INDEX_INFO
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_IO_CALIBRATION_STATUS
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SERVERS
          • V$OB_SERVER_STORAGE
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SS_SSTABLES
          • V$OB_SSTABLES
          • V$OB_SS_LOCAL_CACHE
          • V$OB_SS_LOCAL_CACHE_DIAGNOSE
          • V$OB_SS_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_REPLICA_INFO
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TENANT_RUNTIME_INFO
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$RESTORE_POINT
          • V$RSRC_PLAN
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
          • V$OB_VECTOR_MEMORY
          • v$tenant_memstore_allocator_info
          • V$UNIT
      • MySQL tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.audit_log_filter
          • mysql.audit_log_user
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • DBA_MVREF_CHANGE_STATS
          • DBA_MVREF_RUN_STATS
          • DBA_MVREF_STATS
          • DBA_MVREF_STATS_PARAMS
          • DBA_MVREF_STATS_SYS_DEFAULTS
          • DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS
          • oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS
          • oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SENSITIVE_COLUMNS
          • oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.DBA_OB_SENSITIVE_RULES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SS_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLE_SPACE_USAGE
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_HNWS_INDEX_INFO
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_SS_LOCAL_CACHE
          • GV$OB_SS_LOCAL_CACHE_DIAGNOSE
          • GV$OB_SS_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_PLAN_MONITOR
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_HNWS_INDEX_INFO
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_RES_MGR_SYSSTAT
          • V$RSRC_PLAN
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SS_SSTABLES
          • V$OB_SSTABLES
          • V$OB_SS_LOCAL_CACHE
          • V$OB_SS_LOCAL_CACHE_DIAGNOSE
          • V$OB_SS_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$OB_VECTOR_MEMORY
          • V$RESTORE_POINT
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
      • Oracle tenant views
        • Dictionary views
          • ALL_ALL_TABLES
          • ALL_ARGUMENTS
          • ALL_COL_COMMENTS
          • ALL_COL_PRIVS
          • ALL_COLL_TYPES
          • ALL_CONS_COLUMNS
          • ALL_CONSTRAINTS
          • ALL_DB_LINKS
          • ALL_DEF_AUDIT_OPTS
          • ALL_DEPENDENCIES
          • ALL_DIRECTORIES
          • ALL_ERRORS
          • ALL_IND_COLUMNS
          • ALL_IND_EXPRESSIONS
          • ALL_IND_PARTITIONS
          • ALL_IND_STATISTICS
          • ALL_IND_SUBPARTITIONS
          • ALL_INDEXES
          • ALL_METHOD_PARAMS
          • ALL_MVIEW_LOGS
          • ALL_MVIEWS
          • ALL_OB_EXTERNAL_TABLE_FILES
          • ALL_OBJECTS
          • ALL_PART_COL_STATISTICS
          • ALL_PART_HISTOGRAMS
          • ALL_PART_INDEXES
          • ALL_PLSQL_TYPES
          • ALL_PLSQL_COLL_TYPES
          • ALL_PLSQL_TYPE_ATTRS
          • ALL_PART_KEY_COLUMNS
          • ALL_PART_TABLES
          • ALL_POLICIES
          • ALL_POLICY_CONTEXTS
          • ALL_POLICY_GROUPS
          • ALL_PROCEDURES
          • ALL_PROFILES
          • ALL_SCHEDULER_JOB_ARGS
          • ALL_SCHEDULER_PROGRAM_ARGS
          • ALL_SCHEDULER_WINDOWS
          • ALL_SEC_RELEVANT_COLS
          • ALL_SEQUENCES
          • ALL_SOURCE
          • ALL_SUBPART_COL_STATISTICS
          • ALL_SUBPART_HISTOGRAMS
          • ALL_SUBPART_KEY_COLUMNS
          • ALL_SUBPARTITION_TEMPLATES
          • ALL_SYNONYMS
          • ALL_TAB_COL_STATISTICS
          • ALL_TAB_COLS
          • ALL_TAB_COLUMNS
          • ALL_TAB_COMMENTS
          • ALL_TAB_HISTOGRAMS
          • ALL_TAB_MODIFICATIONS
          • ALL_TAB_PARTITIONS
          • ALL_TAB_PRIVS
          • ALL_TAB_STATISTICS
          • ALL_TAB_STATS_HISTORY
          • ALL_TAB_SUBPARTITIONS
          • ALL_TABLES
          • ALL_TRIGGER_ORDERING
          • ALL_TRIGGERS
          • ALL_TYPE_ATTRS
          • ALL_TYPE_METHODS
          • ALL_TYPES
          • ALL_USERS
          • ALL_VIEWS
          • AUDIT_ACTIONS
          • DBA_ALL_TABLES
          • DBA_ARGUMENTS
          • DBA_AUDIT_EXISTS
          • DBA_AUDIT_OBJECT
          • DBA_AUDIT_SESSION
          • DBA_AUDIT_STATEMENT
          • DBA_AUDIT_TRAIL
          • DBA_COL_COMMENTS
          • DBA_COL_PRIVS
          • DBA_COLL_TYPES
          • DBA_CONS_COLUMNS
          • DBA_CONSTRAINTS
          • DBA_CONTEXT
          • DBA_DB_LINKS
          • DBA_DEPENDENCIES
          • DBA_DIRECTORIES
          • DBA_ERRORS
          • DBA_IND_COLUMNS
          • DBA_IND_EXPRESSIONS
          • DBA_IND_PARTITIONS
          • DBA_IND_STATISTICS
          • DBA_IND_SUBPARTITIONS
          • DBA_INDEX_USAGE
          • DBA_INDEXES
          • DBA_JOBS
          • DBA_JOBS_RUNNING
          • DBA_METHOD_PARAMS
          • DBA_MVIEW_DEPS
          • DBA_MVIEW_LOGS
          • DBA_MVIEW_RUNNING_JOBS
          • DBA_MVIEWS
          • DBA_MVREF_CHANGE_STATS
          • DBA_MVREF_RUN_STATS
          • DBA_MVREF_STATS
          • DBA_MVREF_STATS_PARAMS
          • DBA_MVREF_STATS_SYS_DEFAULTS
          • DBA_MVREF_STMT_STATS
          • DBA_OB_ACCESS_POINT
          • DBA_OB_ARCHIVE_DEST
          • DBA_OB_ARCHIVELOG
          • DBA_OB_ARCHIVELOG_PIECE_FILES
          • DBA_OB_ARCHIVELOG_SUMMARY
          • DBA_OB_AUX_STATISTICS
          • DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • DBA_OB_BACKUP_DELETE_JOBS
          • DBA_OB_BACKUP_DELETE_POLICY
          • DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • DBA_OB_BACKUP_DELETE_TASKS
          • DBA_OB_BACKUP_JOB_HISTORY
          • DBA_OB_BACKUP_JOBS
          • DBA_OB_BACKUP_PARAMETER
          • DBA_OB_BACKUP_SET_FILES
          • DBA_OB_BACKUP_STORAGE_INFO
          • DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • DBA_OB_BACKUP_TASK_HISTORY
          • DBA_OB_BACKUP_TASKS
          • DBA_OB_BACKUP_VALIDATE_JOBS
          • DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
          • DBA_OB_BACKUP_VALIDATE_TASKS
          • DBA_OB_BACKUP_VALIDATE_TASK_HISTORY
          • DBA_OB_BALANCE_JOB_HISTORY
          • DBA_OB_BALANCE_JOBS
          • DBA_OB_BALANCE_TASK_HISTORY
          • DBA_OB_BALANCE_TASKS
          • DBA_OB_CONCURRENT_LIMIT_SQL
          • DBA_OB_CS_REPLICA_STATS
          • DBA_OB_CCL_RULES
          • DBA_OB_DATA_DICTIONARY_IN_LOG
          • DBA_OB_DATABASE_PRIVILEGE
          • DBA_OB_DATABASES
          • DBA_OB_DEADLOCK_EVENT_HISTORY
          • DBA_OB_DYNAMIC_PARTITION_TABLES
          • DBA_OB_EXTERNAL_TABLE_FILES
          • DBA_OB_FORMAT_OUTLINES
          • DBA_OB_FREEZE_INFO
          • DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • DBA_OB_IMPORT_TABLE_JOBS
          • DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • DBA_OB_IMPORT_TABLE_TASKS
          • DBA_OB_LOG_RESTORE_SOURCE
          • DBA_OB_LS
          • DBA_OB_LS_ARB_REPLICA_TASKS
          • DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • DBA_OB_LS_HISTORY
          • DBA_OB_LS_LOCATIONS
          • DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • DBA_OB_SENSITIVE_COLUMNS
          • DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • DBA_OB_SENSITIVE_RULES
          • DBA_OB_SERVICES
          • DBA_OB_LS_REPLICA_TASKS
          • DBA_OB_LS_REPLICA_TASK_HISTORY
          • DBA_OB_MAJOR_COMPACTION
          • DBA_OB_OBJECT_BALANCE_WEIGHT
          • DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • DBA_OB_OUTLINES
          • DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • DBA_OB_RECOVER_TABLE_JOBS
          • DBA_OB_RESTORE_HISTORY
          • DBA_OB_RESTORE_PROGRESS
          • DBA_OB_RSRC_IO_DIRECTIVES
          • DBA_OB_RSRC_DIRECTIVES
          • DBA_OB_SPATIAL_COLUMNS
          • oceanbase.DBA_OB_SS_SPACE_USAGE
          • DBA_OB_STORAGE_IO_USAGE
          • DBA_OB_SYS_VARIABLES
          • DBA_OB_TABLE_LOCATIONS
          • DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • DBA_OB_TABLE_STAT_STALE_INFO
          • DBA_OB_TABLEGROUP_PARTITIONS
          • DBA_OB_TABLEGROUP_SUBPARTITIONS
          • DBA_OB_TABLEGROUP_TABLES
          • DBA_OB_TABLEGROUPS
          • DBA_OB_TABLET_REPLICAS
          • DBA_OB_TABLET_TO_LS
          • DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • DBA_OB_TENANT_EVENT_HISTORY
          • DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • DBA_OB_TEMP_FILES
          • DBA_OB_TENANTS
          • DBA_OB_TRANSFER_PARTITION_TASKS
          • DBA_PLSQL_TYPES
          • DBA_PLSQL_COLL_TYPES
          • DBA_PLSQL_TYPE_ATTRS
          • DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • DBA_OB_TRANSFER_TASK_HISTORY
          • DBA_OB_TRANSFER_TASKS
          • DBA_OB_TTL_TASKS
          • DBA_OB_TTL_TASK_HISTORY
          • DBA_OB_USER_DEFINED_RULES
          • DBA_OB_ZONE_MAJOR_COMPACTION
          • DBA_OBJ_AUDIT_OPTS
          • DBA_OBJECTS
          • DBA_PART_COL_STATISTICS
          • DBA_PART_HISTOGRAMS
          • DBA_PART_INDEXES
          • DBA_PART_KEY_COLUMNS
          • DBA_PART_TABLES
          • DBA_POLICIES
          • DBA_POLICY_CONTEXTS
          • DBA_POLICY_GROUPS
          • DBA_PROCEDURES
          • DBA_PROFILES
          • DBA_RECYCLEBIN
          • DBA_ROLE_PRIVS
          • DBA_ROLES
          • DBA_RSRC_CONSUMER_GROUPS
          • DBA_RSRC_GROUP_MAPPINGS
          • DBA_RSRC_PLAN_DIRECTIVES
          • DBA_RSRC_PLANS
          • DBA_SCHEDULER_JOB_ARGS
          • DBA_SCHEDULER_JOB_RUN_DETAILS
          • DBA_SCHEDULER_JOBS
          • DBA_SCHEDULER_PROGRAM
          • DBA_SCHEDULER_PROGRAM_ARGS
          • DBA_SCHEDULER_WINDOWS
          • DBA_SEC_RELEVANT_COLS
          • DBA_SEGMENTS
          • DBA_SEQUENCES
          • DBA_SOURCE
          • DBA_SQL_MANAGEMENT_CONFIG
          • DBA_SQL_PLAN_BASELINES
          • DBA_STMT_AUDIT_OPTS
          • DBA_SUBPART_COL_STATISTICS
          • DBA_SUBPART_HISTOGRAMS
          • DBA_SUBPART_KEY_COLUMNS
          • DBA_SUBPARTITION_TEMPLATES
          • DBA_SYNONYMS
          • DBA_SYS_PRIVS
          • DBA_TAB_COL_STATISTICS
          • DBA_TAB_COLS
          • DBA_TAB_COLUMNS
          • DBA_TAB_COMMENTS
          • DBA_TAB_HISTOGRAMS
          • DBA_TAB_MODIFICATIONS
          • DBA_TAB_PARTITIONS
          • DBA_TAB_PRIVS
          • DBA_TAB_STATISTICS
          • DBA_TAB_STATS_HISTORY
          • DBA_TAB_SUBPARTITIONS
          • DBA_TABLES
          • DBA_TABLESPACES
          • DBA_OB_TABLE_SPACE_USAGE
          • DBA_TRIGGER_ORDERING
          • DBA_TRIGGERS
          • DBA_TYPE_ATTRS
          • DBA_TYPE_METHODS
          • DBA_TYPES
          • DBA_USERS
          • DBA_VIEWS
          • DBA_WR_ACTIVE_SESSION_HISTORY
          • DBA_WR_CONTROL
          • DBA_WR_EVENT_NAME
          • DBA_WR_SNAPSHOT
          • DBA_WR_SQLSTAT
          • DBA_WR_SQLTEXT
          • DBA_WR_STATNAME
          • DBA_WR_SYS_TIME_MODEL
          • DBA_WR_SYSSTAT
          • DBA_WR_SYSTEM_EVENT
          • DBMS_LOCK_ALLOCATED
          • DICT
          • DICTIONARY
          • NLS_DATABASE_PARAMETERS
          • NLS_INSTANCE_PARAMETERS
          • NLS_SESSION_PARAMETERS
          • PROXY_USERS
          • ROLE_ROLE_PRIVS
          • ROLE_SYS_PRIVS
          • ROLE_TAB_PRIVS
          • STMT_AUDIT_OPTION_MAP
          • TENANT_VIRTUAL_GLOBAL_VARIABLE
          • TENANT_VIRTUAL_SESSION_VARIABLE
          • USER_ALL_TABLES
          • USER_ARGUMENTS
          • USER_AUDIT_OBJECT
          • USER_AUDIT_SESSION
          • USER_AUDIT_STATEMENT
          • USER_AUDIT_TRAIL
          • USER_COL_COMMENTS
          • USER_COL_PRIVS
          • USER_COLL_TYPES
          • USER_CONS_COLUMNS
          • USER_CONSTRAINTS
          • USER_DB_LINKS
          • USER_DEPENDENCIES
          • USER_ERRORS
          • USER_IND_COLUMNS
          • USER_IND_EXPRESSIONS
          • USER_IND_PARTITIONS
          • USER_IND_STATISTICS
          • USER_IND_SUBPARTITIONS
          • USER_INDEXES
          • USER_PLSQL_TYPES
          • USER_PLSQL_COLL_TYPES
          • USER_PLSQL_TYPE_ATTRS
          • USER_JOBS
          • USER_MVIEW_LOGS
          • USER_MVIEWS
          • USER_MVREF_CHANGE_STATS
          • USER_MVREF_RUN_STATS
          • USER_MVREF_STATS
          • USER_MVREF_STATS_PARAMS
          • USER_MVREF_STATS_SYS_DEFAULTS
          • USER_MVREF_STMT_STATS
          • USER_OBJECTS
          • USER_PART_COL_STATISTICS
          • USER_PART_HISTOGRAMS
          • USER_PART_INDEXES
          • USER_PART_KEY_COLUMNS
          • USER_PART_TABLES
          • USER_POLICIES
          • USER_POLICY_CONTEXTS
          • USER_POLICY_GROUPS
          • USER_PROCEDURES
          • USER_PROFILES
          • USER_RECYCLEBIN
          • USER_ROLE_PRIVS
          • USER_SCHEDULER_JOB_ARGS
          • USER_SCHEDULER_PROGRAM_ARGS
          • USER_SEC_RELEVANT_COLS
          • USER_SEGMENTS
          • USER_SEQUENCES
          • USER_SOURCE
          • USER_SUBPART_COL_STATISTICS
          • USER_SUBPART_HISTOGRAMS
          • USER_SUBPART_KEY_COLUMNS
          • USER_SUBPARTITION_TEMPLATES
          • USER_SYNONYMS
          • USER_SYS_PRIVS
          • USER_TAB_COL_STATISTICS
          • USER_TAB_COLS
          • USER_TAB_COLUMNS
          • USER_TAB_COMMENTS
          • USER_TAB_HISTOGRAMS
          • USER_TAB_MODIFICATIONS
          • USER_TAB_PARTITIONS
          • USER_TAB_PRIVS
          • USER_TAB_STATISTICS
          • USER_TAB_STATS_HISTORY
          • USER_TAB_SUBPARTITIONS
          • USER_TABLES
          • USER_TABLESPACES
          • USER_TRIGGER_ORDERING
          • USER_TRIGGERS
          • USER_TYPE_ATTRS
          • USER_TYPE_METHODS
          • USER_TYPES
          • USER_USERS
          • USER_VIEWS
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DBLINK
          • GV$DML_STATS
          • GV$GLOBAL_TRANSACTION
          • GV$INSTANCE
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GLOBAL_TRANSACTION
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_KVCACHE
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PL_CACHE_OBJECT
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_SS_LOCAL_CACHE
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_RESULT_CACHE_OBJECTS
          • GV$OPEN_CURSOR
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_PLAN_MONITOR
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_LOCKS
          • GV$OB_THREAD
          • V$ACTIVE_SESSION_HISTORY
          • V$DBLINK
          • V$DML_STATS
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$EVENT_NAME
          • V$GLOBAL_TRANSACTION
          • V$GLOBALCONTEXT
          • V$INSTANCE
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$NLS_PARAMETERS
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GLOBAL_TRANSACTION
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_KVCACHE
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMSTORE_INFO
          • V$OB_NIC_INFO
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_PARAMETERS
          • V$OB_PL_CACHE_OBJECT
          • V$OB_PROCESSLIST
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_RESULT_CACHE_OBJECTS
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SS_LOCAL_CACHE
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$OPEN_CURSOR
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$RSRC_PLAN
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$OB_SS_SSTABLES
          • V$OB_SSTABLES
          • V$RESTORE_POINT
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_TENANT_MEMORY
          • V$TIMEZONE_NAMES
          • V$VERSION
          • V$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_LOCKS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_THREAD
      • Overview of metrics
      • Common wait events
    • Parameters and system variables
      • Overview of configuration parameters and system variables
      • Changes in V3.x and V4.x configuration items and system variables
      • Parameters
        • Overview
        • Cluster-level parameters
          • alert_log_level
          • all_cluster_list
          • all_server_list
          • arbitration_degradation_policy
          • auto_broadcast_location_cache_rate_limit
          • auto_leader_switch_interval
          • auto_refresh_location_cache_rate_limit
          • autoinc_cache_refresh_interval
          • async_ps_cursor_max_count
          • backup_backup_dest
          • backup_backup_dest_option
          • backup_concurrency
          • backup_dest
          • backup_dest_option
          • 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
          • system_protected_sys_variables
          • system-protected-tenant-parameters
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_cache_priority
          • clog_disk_usage_limit_percentage
          • clog_disk_utilization_threshold
          • clog_expire_days
          • clog_io_isolation_mode
          • clog_sync_time_warn_threshold
          • clog_transport_compress_func
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • cpu_reserved
          • data_copy_concurrency
          • data_dir
          • data_disk_usage_limit_percentage
          • data_disk_write_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_maxsize
          • datafile_next
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress
          • default_compress_func
          • default_row_format
          • default_transport_compress_func
          • devname
          • diag_syslog_per_error_limit
          • disk_io_thread_count
          • dtl_buffer_size
          • election_blacklist_interval
          • election_cpu_quota
          • enable_asan_for_memory_context
          • enable_async_syslog
          • enable_auto_leader_switch
          • enable_auto_refresh_location_cache
          • enable_cgroup
          • enable_dblink
          • enable_ddl
          • enable_election_group
          • enable_global_background_resource_isolation
          • enable_global_freeze_trigger
          • enable_log_archive
          • enable_logservice
          • enable_major_freeze
          • enable_manual_merge
          • enable_merge_by_turn
          • enable_ob_error_msg_style
          • enable_ob_esi_process
          • 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_rootservice_standalone
          • enable_rpc_authentication_bypass
          • enable_separate_sys_clog
          • enable_smooth_leader_switch
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_table_ddl
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • enable_upgrade_mode
          • external_table_disk_cache_max_percentage
          • fast_recovery_concurrency
          • flush_log_at_trx_commit
          • fuse_row_cache_priority
          • gc_wait_archive
          • get_leader_candidate_rpc_timeout
          • global_background_cpu_quota
          • global_index_build_single_replica_timeout
          • global_major_freeze_residual_memory
          • global_write_halt_residual_memory
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • ignore_replica_checksum_error
          • ilog_index_expire_time
          • index_block_cache_priority
          • index_cache_priority
          • index_clog_cache_priority
          • index_info_block_cache_priority
          • internal_sql_execute_timeout
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • local_ip
          • location_cache_cpu_quota
          • location_cache_expire_time
          • location_cache_priority
          • 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
          • log_disk_percentage
          • log_disk_size
          • logservice_access_point
          • log_storage_warning_trigger_percentage
          • log_storage_warning_tolerance_time
          • ls_meta_table_check_interval
          • max_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
          • merger_warm_up_duration_time
          • micro_block_merge_verify_level
          • migrate_concurrency
          • migration_disable_time
          • min_observer_version
          • minor_deferred_gc_time
          • minor_freeze_times
          • minor_merge_concurrency
          • minor_warm_up_duration_time
          • multiblock_read_gap_size
          • multiblock_read_size
          • mysql_port
          • net_thread_count
          • ob_esi_io_concurrency
          • ob_esi_max_syslog_file_count
          • ob_esi_memory_limit
          • ob_esi_rpc_port
          • ob_esi_session_timeout
          • ob_esi_syslog_level
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • ob_startup_mode
          • ob_python_home
          • obconfig_url
          • observer_id
          • ob_storage_s3_url_encode_type
          • ob_enable_java_env
          • ob_enable_utl_tcp
          • ob_java_home
          • ob_java_connector_path
          • ob_java_opts
          • ob_enable_utl_http
          • ofs_list
          • opt_tab_stat_cache_priority
          • partition_table_check_interval
          • plan_cache_evict_interval
          • plan_cache_high_watermark
          • plan_cache_low_watermark
          • px_task_size
          • rebuild_replica_data_lag_threshold
          • recyclebin_object_expire_time
          • replica_safe_remove_time
          • resource_hard_limit
          • resource_soft_limit
          • restore_concurrency
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_memory_limit
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • row_purge_thread_count
          • rpc_client_authentication_method
          • rpc_port
          • rpc_server_authentication_method
          • rpc_timeout
          • schema_history_expire_time
          • schema_history_recycle_interval
          • server_balance_cpu_mem_tolerance_percent
          • server_balance_critical_disk_waterlevel
          • server_balance_disk_tolerance_percent
          • server_check_interval
          • server_cpu_quota_max
          • server_cpu_quota_min
          • server_data_copy_in_concurrency
          • server_data_copy_out_concurrency
          • server_permanent_offline_time
          • sql_audit_memory_limit
          • sql_login_thread_count
          • sql_net_thread_count
          • sql_protocol_min_tls_version
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • standby_fetch_log_bandwidth_limit
          • storage_meta_cache_priority
          • strict_check_os_params
          • switchover_process_thread_count
          • sync_io_thread_count
          • sys_bkgd_io_high_percentage
          • sys_bkgd_io_low_percentage
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • sys_cpu_limit_trigger
          • syslog_compress_func
          • syslog_disk_size
          • syslog_file_uncompressed_count
          • syslog_io_bandwidth_limit
          • syslog_level
          • system_cpu_quota
          • system_memory
          • system_trace_level
          • kv_transport_compress_func
          • tablet_ls_cache_priority
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • tablet_size
          • tcp_keepcnt
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_cpu_variation_per_server
          • tenant_groups
          • tenant_task_queue_size
          • token_reserved_percentage
          • trace_log_sampling_interval
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • trx_force_kill_threshold
          • trx_try_wait_lock_timeout
          • unit_balance_resource_weight
          • unit_gc_wait_time
          • use_large_pages
          • user_block_cache_priority
          • user_iort_up_percentage
          • user_row_cache_priority
          • user_tab_col_stat_cache_priority
          • virtual_table_location_cache_expire_time
          • wait_leader_batch_count
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • zone
          • zone_merge_concurrency
          • zone_merge_order
          • zone_merge_timeout
        • Tenant-level parameters
          • arbitration_timeout
          • archive_lag_target
          • audit_log_buffer_size
          • audit_log_compression
          • attach_shared_sstable_thread_score
          • audit_log_enable
          • audit_log_format
          • audit_log_max_size
          • audit_log_path
          • audit_log_prune_seconds
          • audit_log_query_sql
          • audit_log_rotate_on_size
          • audit_log_strategy
          • audit_sys_operations
          • audit_trail
          • auto_split_tablet_size
          • backup_data_file_size
          • balancer_idle_time
          • choose_migration_source_policy
          • clog_max_unconfirmed_log_count
          • clog_persistence_compress_func
          • compaction_dag_cnt_limit
          • compaction_high_thread_score
          • compaction_low_thread_score
          • compaction_mid_thread_score
          • compaction_schedule_tablet_batch_cnt
          • compatible
          • connection_control_failed_connections_threshold
          • connection_control_max_connection_delay
          • connection_control_min_connection_delay
          • cpu_quota_concurrency
          • ddl_thread_score
          • default_auto_increment_mode
          • default_delta_format
          • default_enable_extended_rowid
          • default_load_mode
          • default_micro_block_format_version
          • default_progressive_merge_num
          • default_skip_index_level
          • default_storage_cache_policy
          • default_table_merge_engine
          • default_table_organization
          • default_table_store_format
          • direct_load_allow_fallback
          • ddl_high_thread_score
          • document_ai_file_max_size
          • dump_data_dictionary_to_log_interval
          • enable_adaptive_plan_cache
          • enable_auto_split
          • enable_clog_persistence_compress
          • enable_database_sharding_none
          • enable_early_lock_release
          • enable_pl_rich_error_msg
          • enable_gts_standalone
          • enable_kv_group_commit
          • enable_kv_ttl
          • enable_lock_priority
          • enable_manual_storage_cache_policy
          • enable_mlog_auto_maintenance
          • enable_monotonic_weak_read
          • enable_mv_binlog_minimal_mode
          • enable_ls_leader_balance
          • enable_rebalance
          • enable_sql_extension
          • enable_transfer
          • enable_ttl
          • enable_user_defined_rewrite_rules
          • enable_window_compaction
          • external_kms_info
          • external_table_io_hole_size
          • external_table_io_range_size
          • external_table_csv_max_buffer_size
          • ob_vector_search_strategy
          • freeze_trigger_percentage
          • global_index_auto_split_policy
          • ha_high_thread_score
          • ha_low_thread_score
          • ha_mid_thread_score
          • inc_sstable_upload_thread_score
          • io_category_config
          • job_queue_processes
          • json_document_max_depth
          • kv_ttl_duty_duration
          • kv_group_commit_batch_size
          • kv_group_commit_rw_mode
          • kv_hbase_client_scanner_timeout_period
          • kv_ttl_delete_max_ops
          • kv_ttl_history_recycle_interval
          • load_data_diagnosis_log_compression
          • load_data_diagnosis_log_max_size
          • load_vector_index_on_follower
          • lob_enable_block_cache_threshold
          • log_archive_concurrency
          • log_disk_throttling_maximum_duration
          • log_disk_throttling_percentage
          • log_disk_utilization_limit_threshold
          • log_disk_utilization_threshold
          • log_restore_concurrency
          • log_storage_compress_all
          • log_storage_compress_func
          • log_transport_compress_all
          • log_transport_compress_func
          • ls_gc_delay_time
          • ls_scale_out_factor
          • major_compact_trigger
          • major_freeze_duty_time
          • max_partition_num
          • max_stale_time_for_weak_consistency
          • mds_compaction_high_thread_score
          • mds_compaction_mid_thread_score
          • mds_minor_compact_trigger
          • merger_check_interval
          • minor_compact_trigger
          • mlog_trim_interval
          • model_max_retries
          • model_request_timeout
          • ob_compaction_schedule_interval
          • ob_enable_batched_multi_statement
          • ob_encoding_granularity
          • ob_enable_java_udf
          • ob_enable_python_udf
          • ob_proxy_readonly_transaction_routing_policy
          • ob_query_switch_leader_retry_timeout
          • ob_ssl_invited_common_names
          • ob_vector_index_active_segment_max_size
          • ob_vector_index_merge_trigger_percentage
          • ob_vector_memory_limit_percentage
          • open_cursors
          • optimizer_index_cost_adj
          • partition_balance_schedule_interval
          • plsql_code_type
          • plsql_debug
          • plsql_optimize_level
          • plsql_v2_compatibility
          • px_node_policy
          • package_state_sync_max_size
          • px_target_high_watermark
          • px_target_low_watermark
          • px_target_workers_per_cpu
          • px_workers_per_cpu_quota
          • query_memory_limit_percentage
          • query_response_time_flush
          • query_response_time_range_base
          • query_response_time_stats
          • range_optimizer_max_mem_size
          • recover_table_concurrency
          • recover_table_dop
          • replica_parallel_migration_mode
          • result_cache_max_size
          • result_cache_max_result
          • rest_oauth2_credential_refresh_interval
          • rest_oauth2_credential_evict_time
          • ob_result_cache_evict_percentage
          • ob_deterministic_udf_cache_max_size
          • rpc_memory_limit_percentage
          • shared_log_retention
          • spill_compression_codec
          • sql_func_extension_mode
          • sql_work_area
          • standby_db_fetch_log_rpc_timeout
          • standby_db_preferred_upstream_log_region
          • sts_credential
          • storage_cache_clean_macro_interval
          • tde_method
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • temporary_file_max_disk_size
          • storage_rowsets_size
          • suspend_storage_cache_task
          • ttl_duty_time
          • ttl_thread_score
          • undo_retention
          • vector_index_memory_saving_mode
          • vector_index_optimize_duty_time
          • vector_index_optimize_duty_time
          • workarea_size_policy
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • zone_deploy_mode
      • System variables
        • Overview
        • Global variables
          • ap_query_cost_threshold
          • ap_query_route_policy
          • ap_query_replica_fallback
          • activate_all_roles_on_login
          • auto_increment_cache_size
          • auto_increment_increment
          • auto_increment_offset
          • autocommit
          • automatic_sp_privileges
          • binlog_row_image
          • block_encryption_mode
          • character_set_client
          • character_set_connection
          • cardinality_estimation_model
          • character_set_database
          • character_set_filesystem
          • character_set_results
          • character_set_server
          • character_set_system
          • collation_connection
          • collation_database
          • collation_server
          • connect_timeout
          • cte_max_recursion_depth
          • cursor_sharing
          • datadir
          • default_password_lifetime
          • default_storage_engine
          • div_precision_increment
          • error_on_overlap_time
          • event_scheduler
          • explicit_defaults_for_timestamp
          • ENABLE_OPTIMIZER_ROWGOAL
          • foreign_key_checks
          • group_concat_max_len
          • identity
          • init_connect
          • innodb_stats_persistent
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lc_time_names
          • log_row_value_options
          • long_query_time
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • mview_refresh_dop
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • 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_bnl_join_cache_size
          • ob_compatibility_mode
          • ob_compatibility_control
          • ob_compatibility_version
          • ob_create_table_strict_mode
          • ob_default_lob_inrow_threshold
          • ob_default_replica_num
          • ob_early_lock_release
          • ob_enable_ps_parameter_anonymous_block
          • ob_enable_pl_async_commit
          • ob_enable_aggregation_pushdown
          • ob_enable_blk_nestedloop_join
          • ob_enable_hash_group_by
          • ob_enable_index_direct_select
          • ob_enable_jit
          • ob_enable_pl_cache
          • ob_enable_plan_cache
          • ob_enable_rich_error_msg
          • ob_enable_sql_audit
          • ob_enable_transformation
          • ob_enable_transmission_checksum
          • ob_enable_truncate_flashback
          • ob_global_debug_sync
          • ob_log_level
          • ob_max_read_stale_time
          • ob_pl_block_timeout
          • ob_plan_cache_evict_high_percentage
          • ob_plan_cache_evict_low_percentage
          • ob_plan_cache_percentage
          • ob_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_table_access_policy
          • 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
          • ob_security_version
          • optimizer_dynamic_sampling
          • optimizer_features_enable
          • optimizer_use_sql_plan_baselines
          • parallel_degree_limit
          • parallel_degree_policy
          • parallel_max_servers
          • parallel_min_scan_time_threshold
          • parallel_servers_target
          • performance_schema
          • plugin_dir
          • plsql_ccflags
          • pid_file
          • query_cache_size
          • plsql_optimize_level
          • plsql_can_transform_sql_to_assign
          • port
          • query_cache_type
          • query_rewrite_enabled
          • query_rewrite_integrity
          • read_only
          • recyclebin
          • regexp_stack_limit
          • regexp_time_limit
          • resource_manager_plan
          • socket
          • runtime_bloom_filter_max_size
          • runtime_filter_max_in_num
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • secure_file_priv
          • server_uuid
          • sql_auto_is_null
          • sql_mode
          • sql_quote_show_create
          • sql_safe_updates
          • sql_select_limit
          • sql_throttle_current_priority
          • sql_throttle_network
          • sql_throttle_priority
          • sql_throttle_rt
          • SQL_TRANSPILER
          • sql_warnings
          • system_time_zone
          • time_zone
          • transaction_isolation
          • transaction_read_only
          • tx_isolation
          • tx_read_only
          • validate_password_check_user_name
          • validate_password_length
          • validate_password_mixed_case_count
          • validate_password_number_count
          • validate_password_policy
          • validate_password_special_char_count
          • version
          • version_comment
          • wait_timeout
        • Session-level variables
          • enable_sql_plan_monitor
          • is_result_accurate
          • last_insert_id
          • nls_language
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_hnsw_ef_search
          • ob_ivf_nprobes
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_sparse_drop_ratio_search
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • timestamp
          • tracefile_identifier
    • Error codes
      • MySQL-compatible mode
        • Overview
        • 0001 to 3999
        • 4000 to 4499
        • 4500 to 4999
        • 5000 to 5999
        • 6000 to 6999
        • 7000 to 7999
        • 8000 to 8999
        • 9000 ~ 9499
        • 9500 to 9999
        • 10000 to 12000
        • 22998, 30926, 38104, and 38105
      • Oracle-compatible mode
        • Overview
        • OBE-00000 ~ OBE-00999
        • OBE-01000 to OBE-01499
        • OBE-01500 to OBE-01999
        • OBE-02000 to OBE-04999
        • OBE-05000 to OBE-10000
        • OBE-10000 to OBE-19999
        • OBE-20000 to OBE-29999
        • OBE-30000 to OBE-49999
        • OBE-50000 to OBE-99999
        • PLS-00000 to PLS-00999
    • Performance tuning
      • Overview
      • 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
      • System tuning
        • OS parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU parameters
          • Network transmission parameters
          • Routing parameters on nodes
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
      • 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 an ASH report
          • Analyze an ASH report
      • SQL tuning
        • Execution process of SQL queries
        • SQL execution plans
          • Introduction to SQL execution plans
          • 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
          • Plan cache
          • Fast parameterization
          • Real-time execution plan display
          • SQL optimization practice with EXPLAIN
        • Distributed execution plans
          • Perform distributed execution and parallel queries
          • Generate a distributed plan
          • Schedule distributed execution plans
          • Manage distributed execution plans
          • Parallel execution enabling methods and their priority
          • Auto DOP
          • Execute parallel queries
          • Perform parameter tuning for a parallel query
          • Parallel DML
          • Parallel DDL
        • Parallel execution plans
          • Introduction to parallel execution
          • Classification and optimization of parallel execution
          • Set concurrent execution
            • Concurrency control and queuing
            • Set a DOP for parallel execution
            • Set parallel execution parameters
          • Parallel execution diagnostics
          • Parallel execution tuning tips
          • Quick start
        • 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
              • Manually collect statistics
              • 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
            • OceanBase statistics management practical guide
          • Query rewrite
            • Overview
            • Rule-based query rewrite
            • Cost-based query rewrite
          • Query optimization
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
            • Join algorithm
              • Overview
              • Join algorithms
              • Runtime filter
              • Join order
          • Manage execution plans
            • Optimizer hint
            • Plan binding
            • SPM plan management
        • Glossary
        • General issues in SQL tuning
    • Database proxy
      • OceanBase Database Proxy
      • Connection and routing
      • ODP
        • Overview
        • Manage ODP clusters
          • Create an ODP cluster
          • Manage ODP cluster parameters
          • Delete an ODP cluster
          • Upgrade all ODPs in an ODP cluster
          • Restart 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
      • Physical connections
      • Logical connection
        • Query all sessions
        • Query the details of a session
        • Query the metrics of a session
        • Query session variables
        • Terminate a server session
      • Route management
        • Table-based routing of ODP
        • LDC-based routing
        • ODP routing policy
          • Read/Write splitting
          • Follower-first read
          • Blocklist mechanism
          • Transaction routing
      • View tenant sessions
      • Terminate a tenant session
      • Set the maximum number of connections for a tenant
    • Drivers
      • ECOB
      • OBCI
      • OceanBase Connector/J
      • OceanBase Connector/C
      • OceanBase Connector/ODBC
    • Platforms
      • OMA
      • OMS
      • OCP
      • ODC
      • OAT
    • Components & tools
      • O&M management
        • obshell
          • Use cases
            • obshell management
              • Start or stop obshell
              • Upgrade obshell
            • cluster management
              • Deploy an OceanBase cluster
              • Deploy ODP
              • Take over an OceanBase cluster not deployed by obshell
              • Start an OceanBase cluster
              • Stop an OceanBase cluster
              • Use obshell to scale out an OceanBase cluster
              • Upgrade an OceanBase cluster
              • Initiate a cluster-level backup
            • Tenant management
              • Create a tenant
              • Initiate a tenant-level backup
              • Initiate tenant-level restore
              • Expand a tenant
            • Configure an OBServer node to start automatically on boot
          • obshell commands
            • Agent commands of obshell
            • Cluster commands of obshell
            • obshell unit commands
            • obshell resource pool commands
            • Tenant command group of obshell
            • Task commands of obshell
            • Backup commands in obshell
            • obshell restore command group
            • obshell recyclebin command group
          • obshell Dashboard
            • Tenant management
              • Session management
            • Performance monitoring
            • Manage inspection services
            • Manage credentials
          • API references
            • obshell API requests
            • Hybrid encryption for API operations
            • obshell management
              • AgentUpgradeCheck
              • UpgradeAgent
              • Set node password
              • QueryNodeStatus
            • cluster management
              • Add a node before cluster initialization
              • DeleteNodeBeforeClusterInitialization
              • SetClusterConfig
              • SetServerConfig
              • Initialize Cluster
              • StartCluster
              • StopCluster
              • ObUpgradeCheck
              • Upgrade OceanBase Database
              • Scale out a cluster
              • GetObInfo
            • ODP management
              • Deploy ODP
              • Start ODP
              • Stop ODP
              • Upload an ODP installation package
              • Upgrade ODP
              • Destroy ODP
            • Unit config management
              • Create a resource specification
              • Retrieve all resource specifications
              • Query the information of a specified resource specification
              • Delete a resource specification
            • Resource pool management
              • Get information about all resource pools
              • Delete a specified resource pool
            • Tenant management
              • Create a tenant
              • Query tenant information
              • Change the tenant password
              • Modify the access whitelist of a tenant
              • Modify the primary zone of a tenant
              • Modify tenant system variables
              • Modify tenant configurations
              • Rename a tenant
              • Create a user
              • Delete a user
              • Delete a tenant
              • Add a tenant replica
              • Modify a tenant replica
              • Delete a tenant replica
              • Lock a tenant
              • Unlock a tenant
              • Get an overview of all tenants
              • Query a system variable of a specified tenant
              • Fuzzy query tenant system variables
              • Query a tenant parameter
              • Fuzzy query tenant parameters
            • Session management
              • Query the session list of a tenant
              • Get tenant session details
              • Obtain tenant session statistics
              • Terminate a tenant session
              • Terminate a tenant session query
              • Query tenant deadlock history
            • Backup management
              • Set the backup configuration for a tenant
              • Set cluster-level backup configurations
              • Update the backup configuration of a tenant
              • Update the cluster-level backup configuration
              • Initiate a backup for a single tenant
              • Initiate a cluster-level backup
              • View information about a backup task for a tenant
              • View cluster-level backup tasks
              • Modify the backup status of a tenant
              • Modify the status of cluster-level backups
              • Modify the log archiving status of a tenant
              • Modify the log archiving status of a cluster
            • Restore management
              • Initiate tenant restore
              • View tenant recovery
              • Cancel tenant restore
            • Inspection service management
              • Trigger an inspection
              • Query inspection history
              • Obtain an inspection report
            • Recycle bin management
              • Query all tenant information in the recycle bin
              • Restore a tenant from the recycle bin
              • Clear a tenant from the recycle bin
            • Credential management
              • Create credentials
              • Obtain credentials
              • Update credentials
              • Delete a credential
              • Batch delete credentials
              • Query the credential list
              • Verify credentials
              • Batch verify credentials
              • Update the credential encryption key
            • Task management
              • OperateDag
              • GetDagDetails
              • GetNodeDetails
              • GetSubtaskDetails
              • QueryUnfinishedTasks
              • QueryUnfinishedAgentTasks
              • QueryUnfinishedObTasks
              • QueryLastObTask
              • QueryLastAgentTask
            • Other APIs
              • UploadPkg
              • GetPublicKey
          • SDK references
            • Python
              • Quick start
              • obshell management
                • Perform an agent upgrade check
                • Upgrade agents
                • Set node password
                • Query the status of a node
              • cluster management
                • Add a node before cluster initialization
                • Remove a node before cluster initialization
                • Set cluster-level configurations
                • Set server-level configurations
                • Initialize a cluster
                • Start a cluster
                • Stop a cluster
                • Perform an OceanBase Database upgrade check
                • Upgrade OceanBase Database
                • Scale out a cluster
                • Query the information about a cluster
                • Clean up obshell nodes in an uninitialized cluster
                • Create a cluster
              • ODP management
                • Deploy ODP
                • Start ODP
                • Stop ODP
                • Upload an ODP installation package
                • Upgrade ODP
                • Destroy ODP
              • Unit config management
                • Create a resource specification
                • Obtain information about all resource specifications
                • Query information about a specified resource unit
                • Delete a resource specification
              • Resource pool management
                • Get information about all resource pools
                • Delete a resource pool
              • Tenant management
                • Create a tenant
                • Query tenant information
                • Change the password of a tenant
                • Modify the access whitelist of a tenant
                • Modify the primary zone of a tenant
                • Modify tenant system variables
                • Modify tenant parameters
                • Rename a tenant
                • Create a user
                • Delete a user
                • Drop a tenant
                • Add a tenant replica
                • Modify a tenant replica
                • Delete a tenant replica
                • Lock a tenant
                • Unlock a tenant
                • Query the overview of all tenants
                • Query tenant system variables
                • Query tenant configuration items
              • Backup management
                • Configure the backup settings for a tenant
                • Configure cluster-level backup settings
                • Update the backup configuration of a tenant
                • Update cluster-level backup configuration
                • Initiate a backup for a single tenant
                • Initiate a cluster-level backup
                • View a backup task of a tenant
                • View cluster-level tenant backup tasks
                • Modify the backup status of a tenant
                • Modify the status of cluster-level backups
                • Change the log archiving status of a tenant
                • Modify the log archiving status of a cluster
              • Restore management
                • Restore a single tenant
                • View tenant recovery
                • Cancel tenant restoration
              • Recycle bin management
                • Get information about all tenants in the recycle bin
                • Restore a tenant from the recycle bin
                • Purge a tenant from the recycle bin
              • Task management
                • Operate a task
                • Obtain the information about a task
                • Obtain the information about a node
                • Obtain the information about a subtask
                • Query all unfinished tasks
                • Query unfinished agent tasks
                • Query unfinished OceanBase cluster tasks
                • Query the last O&M task in an OceanBase cluster
                • Query the last O&M task of an obshell node
              • Other APIs
                • Upload an RPM package
            • GO
              • Quick Start with obshell-sdk-go
              • obshell management
                • Perform an agent upgrade check
                • Upgrade agents
                • Query the status of a node
              • cluster management
                • Add a node before cluster initialization
                • Remove a node before cluster initialization
                • Set cluster-level configurations
                • Set server-level configurations
                • Initialize a cluster
                • Start a cluster
                • Stop a cluster
                • Perform an OceanBase Database upgrade check
                • Upgrade OceanBase Database
                • Scale out a cluster
                • Query the information about a cluster
                • Clean up obshell nodes in an uninitialized cluster
                • Create a cluster
              • Unit config management
                • Create a resource unit configuration
                • Query all resource specifications
                • Query the specifications of a specified resource
                • Drop a resource unit configuration
              • Resource pool management
                • Get information about all resource pools
                • Drop a resource pool
              • Tenant management
                • Create a tenant
                • Query tenant information
                • Change a tenant password
                • Modify the tenant access whitelist
                • Modify the primary zone of a tenant
                • Modify tenant system variables
                • Modify tenant parameters
                • Rename a tenant
                • Drop a tenant
                • Add a tenant replica
                • Modify a tenant replica
                • Delete a tenant replica
                • Lock a tenant
                • Unlock a tenant
                • Query the overview of all tenants
                • Query tenant system variables
                • Query tenant configuration items
              • Backup management
                • Set the backup configuration for a tenant
                • Set the cluster-level backup configuration
                • Update the backup configuration for a tenant
                • Update the cluster-level backup configuration
                • Initiate a backup for a single tenant
                • Initiate a cluster-level backup
                • View a backup task for a tenant
                • View cluster-level tenant backup tasks
                • Modify the backup status of a tenant
                • Modify the status of a cluster-level backup
                • Change the log archiving status of a tenant
                • Modify the status of cluster-level log archiving
              • Restore management
                • Initiate a restore for a single tenant
                • View tenant recovery
                • Cancel tenant restore
              • Recycle bin management
                • Get information about all tenants in the recycle bin
                • Restore a tenant from the recycle bin
                • Purge tenants from the recycle bin
              • Task management
                • Operate a task
                • Obtain the information about a task
                • Obtain the information about a node
                • Obtain the information about a subtask
                • Query all unfinished tasks
                • Query unfinished agent tasks
                • Query unfinished OceanBase cluster tasks
                • Query the last O&M task in an OceanBase cluster
                • Query the last O&M task of an obshell node
              • Other APIs
                • Upload an RPM package
          • Release notes
            • V4.4
              • OceanBase Shell V4.4.0.0 for local clusters
            • V4.3
              • OceanBase Shell V4.3.2.1
              • OceanBase Shell V4.3.2.0
              • OceanBase Shell V4.3.1.0 for local clusters
        • obd
        • ob_admin
          • Overview
          • clog
            • log_tool
            • Format of clogs
            • Transaction logs
          • Backup and restore
            • dump_backup
            • test_io_device
            • io_adapter_benchmark
          • dumpsst
        • ob-operator
        • ob_error
      • Monitoring and diagnostics
        • obdiag
        • sql_diagnoser
          • Overview
          • Install and use SQL diagnoser sql_diagnoser
            • Install sql_diagnoser
            • Use sql_diagnoser
          • sql_diagnoser parameters
            • Built-in diagnostic items
            • Diagnostic rule expression
            • API operations
            • Diagnostic items of SQL review
      • Log analysis
        • oblogminer
          • Overview
          • Install oblogminer
          • Command-line options
          • Examples
          • FAQ
      • Data integration
        • obloader and obdumper
        • oblogproxy
        • obcdc
          • OceanBase Binlog Service
          • obcdc parameters
            • Sample configuration file
            • General obcdc parameters
            • obcdc parameters
          • obcdc development instructions
          • obcdc_tailf
          • Throttling
          • obcdc allowlist and blocklist
          • Incremental direct load in obcdc
          • FAQ
      • Stress testing tools
        • mysqltest
          • Use obd.sh to run mysqltest
          • Use of cases
            • Add a test case
            • Test case writing conventions
            • General test case writing commands
    • OceanBase plugin
      • Overview of OceanBase plugin
      • Tokenizer plugin
      • MySQL external table plugin
  • FAQ
    • Products
    • SQL FAQ
    • Deployment FAQ
    • Cluster management
    • High availability
    • FAQ about columnstores
  • Release Notes
    • Version number guidelines
    • OceanBase Database Enterprise Edition
      • V4.6
        • OceanBase Database Enterprise Edition V4.6.0
      • V4.5
        • OceanBase Database Enterprise Edition V4.5.0
      • V4.4
        • OceanBase Database Enterprise Edition V4.4.2
      • V4.3
        • OceanBase Database Enterprise Edition V4.3.5
        • OceanBase Database Enterprise Edition V4.3.3
        • OceanBase Database Enterprise Edition V4.3.2
        • OceanBase Database Enterprise Edition V4.3.1
        • OceanBase Database Enterprise Edition V4.3.0
      • 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.2
        • OceanBase Database Enterprise Edition V3.1.1
      • 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.5
        • OceanBase Database Community Edition V4.5.0
      • V4.4
        • OceanBase Database Community Edition V4.4.2
      • V4.3
        • OceanBase Database Community Edition V4.3.5
        • OceanBase Database Community Edition V4.3.3
        • OceanBase Database Community Edition V4.3.2
        • OceanBase Database Community Edition V4.3.1
        • OceanBase Database Community Edition V4.3.0
      • 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
      • V4.0
        • OceanBase Database Community Edition V4.0.0
      • V3.1
        • OceanBase Database Community Edition V3.1.5
        • OceanBase Database Community Edition V3.1.4
        • OceanBase Database Community Edition V3.1.3
        • OceanBase Database Community Edition V3.1.2
        • OceanBase Database Community Edition V3.1.1
  • Glossary

Download PDF

What's New Overview Architecture Overview of Oracle compatibility SQL data types Built-in functions System views Compatibility with MySQL Limitations Quick start with OceanBase Database Community Edition Before you begin Basic SQL operations (MySQL mode) Basic SQL operations (Oracle mode) Build a Python application Build a Java application Build a C application Build a Go application Create a Java sample application Create a C application Try out operational OLAP Try out parallel import and data compression Try out the multi-tenant feature Overview HA deployment solutions for OceanBase clusters Deployment process Deploy OceanBase Database Java SDK Clear an OceanBase cluster Recommended configurations Overview Upgrade an arbitration service Upgrade an OceanBase cluster Check the status after the upgrade Upgrade OceanBase Database with obd Overview 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 DBCAT to migrate schemas from a MySQL database to OceanBase Database Use DataX to migrate table data from a MySQL database to OceanBase Database Use CloudCanal to migrate data from a MySQL database to OceanBase Database Use Canal to synchronize data from a MySQL database to OceanBase Database Use Flink CDC to synchronize data from a MySQL database to OceanBase Database Use ChunJun to migrate 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 OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle 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 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 Use DataX to migrate CSV files to OceanBase Database Import data by using the LOAD DATA statement Import data from SQL files to OceanBase Database Use OMS to migrate data from an OceanBase tenant to another of the same type Use OMS to migrate data from an OceanBase tenant to another of the same type in active-active disaster recovery scenarios Use obloader & obdumper to migrate data between MySQL tenants in OceanBase Database Use obloader & obdumper to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database Use obloader & obdumper to migrate data between Oracle tenants in OceanBase Database Use obloader & obdumper to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database Migrate data between tables Migrate resource units Export data using the OUTFILE statement Overview of direct load Log in to an OceanBase tenant OverviewCluster parameters Tenant introduction Tenant capacity Tenant types User tenant introduction Tenant system variables Create a log stream Modify a log stream Replicas Traffic distribution Data distribution Overview Transfer Partition Cancel a partition transfer task Cancel a Balance Job GTS standalone application scenario High availability overview Flashback queries Overview Overview Experience physical backup and restore with simplified deployment
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogWhite PaperLive DemosTraining & CertificationTicket
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.6.0
iconOceanBase Database
SQL - V 4.6.0
Databases
  • OceanBase Database
  • OceanBase Cloud
  • OceanBase Tugraph
  • Interactive Tutorials
  • OceanBase Best Practices
Tools
  • OceanBase Cloud Platform
  • OceanBase Migration Service
  • OceanBase Developer Center
  • OceanBase Migration Assessment
  • OceanBase Admin Tool
  • OceanBase Loader and Dumper
  • OceanBase Deployer
  • Kubernetes operator for OceanBase
  • OceanBase Diagnostic Tool
  • OceanBase Binlog Service
Connectors and Middleware
  • OceanBase Database Proxy
  • Embedded SQL in C for OceanBase
  • OceanBase Call Interface
  • OceanBase Connector/C
  • OceanBase Connector/J
  • OceanBase Connector/ODBC
  • OceanBase Connector/NET
SQL
KV
  • V 4.6.0
  • 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

10000 to 12000

Last Updated:2026-06-23 06:38:39  Updated
Share
What is on this page
ERROR 10500 (HY000): incorrect route for obkv global index, client router should refresh.
ERROR 10501 (HY000): TTL feature is not enabled
ERROR 10502 (HY000): TTL column '%.*s' not exists
ERROR 10503 (HY000): Column type of '%.*s' is not supported for TTL definition
ERROR 10504 (HY000): TTL command is not allowed, current TTL status is '%s'
ERROR 10505 (HY000): No TTL task is running, please try trigger a new TTL task
ERROR 10506 (HY000): Cannot execute TTL task during tenant is restore
ERROR 10507 (HY000): Time to live of hbase table must be greater than 0
ERROR 10508 (HY000): MaxVersions of hbase table must be greater than 0
ERROR 10509 (HY000): Access denied, credential '%.*s' not match '%.*s'
ERROR 10510 (HY000): Rowkey column count not match, schema rowkey count is '%ld', input rowkey count is '%ld'
ERROR 10511 (HY000): Column type for '%.*s' not match, schema column type is '%.*s', input column type is '%.*s'
ERROR 10512 (HY000): Collation type for '%.*s' not match, schema collation type is '%.*s', input collation type is '%.*s'
ERROR 10513 (HY000): Scan range missing, input scan range cell count is '%ld', which should equal to rowkey count '%ld'
ERROR 10515 (HY000): Redis protocol parse error, the input redis string is: '%.*s'
ERROR 10516 (HY000): When invoking the Increment interface, only HBase cells with a length of 8 can be converted to int64_t. the current length of the HBase cell is '%d'
ERROR 10518 (HY000): Check failed in %.*s"
ERROR 10519 (HY000): '%.*s' is not disabled
ERROR 10520 (HY000): '%.*s' is not enabled
ERROR 10521 (HY000): namespace '%.*s' is not found
ERROR 10522 (HY000): table '%.*s' already exists
ERROR 10523 (HY000): table '%.*s' not found
ERROR 10650 (HY000): ODP process timeout
ERROR 11014 (HY000): Can't find FULLTEXT index matching the column list
ERROR 11015 (HY000): Can't update table '%s' while '%s' is being created.
ERROR 11018 (HY000): Invalid external file: %s
ERROR 11020 (HY000): HDFS: could not open file on hdfs
ERROR 11021 (HY000): HDFS: error reading the file on hdfs
ERROR 11032 (HY000): HDFS path message %s
ERROR 11042 (HY000): HDFS: malformed uri
ERROR 11043 (HY000): HDFS: invalid argument
ERROR 11044 (HY000): HDFS: not implementation
ERROR 11045 (HY000): HDFS error
ERROR 11046 (HY000): Invalid path: %.*s
ERROR 11047 (HY000): Column type mismatch between the file and the table: FileColumnType=%s TableColumnType=%s
ERROR 11049 (HY000): Exceed query memory limit (mem_limit=%ld, mem_hold=%ld), please check whether the query_memory_limit_percentage configuration item is reasonable.
ERROR 11050 (HY000): Odps driver throw exception: ExceptionMsg=%s
ERROR 11051 (HY000): Column type mismatch between the ODPS table and the OceanBase table: OdpsColumnType=%s TableColumnType=%s
ERROR 11052 (HY000): unexpected error for exteran odps table:%s
ERROR 11053 (HY000): unexpected error for jni
ERROR 11054 (HY000): class could not be found during jni operation
ERROR 11055 (HY000): method could not be found during jni operation
ERROR 11056 (HY000): jvm.so not found %s
ERROR 11057 (HY000): JNI env could not delete ref
ERROR 11058 (HY000): cur java home path %s
ERROR 11059 (HY000): JNI cound not ensure capacity
ERROR 11060 (HY000): field could not be found during jni operation
ERROR 11061 (HY000): object could not be found during jni operation
ERROR 11063 (HY000): missing format for external table
ERROR 11064 (HY000): missing access path for external table
ERROR 11065 (HY000): fail to read orc file, message: %s
ERROR 11076 (HY000): The plugin's version is incompatible with current server
ERROR 11077 (HY000): Failed to open library
ERROR 11078 (HY000): Plugin internal error
ERROR 11079 (HY000): Can't create catalog '%.*s'; catalog exists
ERROR 11080 (HY000): Catalog '%.*s' doesn't exist
ERROR 11081 (HY000): skip_header and parse_header cannot be used at the same time
ERROR 11082 (HY000): DDL operations on the internal catalog are not allowed
ERROR 11083 (HY000): Command denied to user '%.*s'@'%.*s' for catalog '%.*s'
ERROR 11085 (HY000): CCL rule '%.*s' already exists
ERROR 11086 (HY000): CCL rule '%.*s' doesn't exist
ERROR 11087 (HY000): SQL reach max ccl rule %s, concurrent num %ld
ERROR 11089 (HY000): Location is still in use
ERROR 11090 (HY000): Location access denied
ERROR 11091 (HY000): Can't create location '%.*s'; location exists
ERROR 11092 (HY000): location '%.*s' doesn't exist
ERROR 11093 (HY000): OBLogService rpc execute failed
ERROR 11094 (HY000): Sensitive rule '%.*s' exists
ERROR 11095 (HY000): Sensitive rule '%.*s' does not exist
ERROR 11096 (HY000): Sensitive column %.*s(%.*s) exists
ERROR 11097 (HY000): Sensitive column %.*s(%.*s) does not exist
ERROR 11098 (HY000): %.*s command denied to user '%.*s'@'%.*s' for sensitive rule '%.*s'
ERROR 11099 (HY000): Invalid sensitive rule name '%.*s'
ERROR 11100 (HY000): kerberos execution error
ERROR 11101 (HY000): HMS execution error
ERROR 11102 (HY000): HMS host: '%.*s' is invalid
ERROR 11103 (HY000): HMS port: '%.*s' is invalid
ERROR 11104 (HY000): HMS table location: '%.*s' is invalid
ERROR 11105 (HY000): HMS service: '%.*s' is invalid
ERROR 11106 (HY000): HMS service FQDN: '%.*s' is invalid
ERROR 11107 (HY000): HMS transport: '%.*s' is invalid
ERROR 11108 (HY000): HMS metastore: '%.*s' is invalid
ERROR 11109 (HY000): HMS partition error
ERROR 11110 (HY000): HMS database: '%.*s' not found
ERROR 11111 (HY000): HMS table: '%.*s' not found
ERROR 11112 (HY000): This ai model endpoint '%.*s' not found in the tenant
ERROR 11113 (HY000): This ai model endpoint '%.*s' is already exists
ERROR 11114 (HY000): The param '%.*s' is empty or null
ERROR 11115 (HY000): The param '%.*s' is invalid
ERROR 11116 (HY000): The value of param '%.*s' is invalid
ERROR 11117 (HY000): This type of param '%.*s' is invalid, should be %.*s
ERROR 11118 (HY000): This ai model '%.*s' not found in the tenant
ERROR 11119 (HY000): This ai model '%.*s' is already exists
ERROR 11120 (HY000): Got error during COMMIT: %s
ERROR 11121 (HY000): Table snapshot '%.*s' does not exist
ERROR 11122 (HY000): Bad http request: %s
ERROR 11123 (HY000): Unauthorized http request: %s
ERROR 11124 (HY000): Http request not found: %s
ERROR 11125 (HY000): Http server error: %s
ERROR 11126 (HY000): unit '%.*s' not recognized
ERROR 11127 (HY000): Privilege not allowed for sensitive rules

folded

Share

This range includes error codes related to OBProxy, OBSharding, OBKV, and the client.

ERROR 10500 (HY000): incorrect route for obkv global index, client router should refresh.

  • OceanBase error code: 10500

  • Cause: The route for the OBKV global index is incorrect. The client router needs to be refreshed.

  • Solution: Please verify your client connection and routing information.

Note

This error code is introduced in V4.3.0.

ERROR 10501 (HY000): TTL feature is not enabled

  • OceanBase error code: 10501

  • Cause: The TTL feature is not enabled.

  • Solution: Ensure that the TTL feature is correctly enabled.

Note

This error code is introduced in V4.2.2.

ERROR 10502 (HY000): TTL column '%.*s' not exists

  • OceanBase error code: 10502

  • Cause: The specified TTL column does not exist.

  • Solution: Please verify whether the specified TTL column exists in the database table.

Note

This error code is introduced in V4.2.2.

ERROR 10503 (HY000): Column type of '%.*s' is not supported for TTL definition

  • OceanBase error code: 10503

  • Cause: The specified column type is not supported for TTL definition.

  • Solution: Verify whether the specified column type is supported for TTL definition.

Note

This error code is introduced in V4.2.2.

ERROR 10504 (HY000): TTL command is not allowed, current TTL status is '%s'

  • OceanBase error code: 10504

  • Cause: The TTL command is not allowed because the current TTL status is a specific value.

  • Solution: Check whether the current status is as expected and switch the status by using an appropriate TTL command.

Note

This error code is introduced in V4.2.2.

ERROR 10505 (HY000): No TTL task is running, please try trigger a new TTL task

  • OceanBase error code: 10505

  • Cause: No TTL task is running. You need to try triggering a new one.

Note

This error code is introduced in V4.2.2.

ERROR 10506 (HY000): Cannot execute TTL task during tenant is restore

  • OceanBase error code: 10506

  • Cause: TTL tasks cannot be executed during tenant restore.

Note

This error code is introduced in V4.2.2.

ERROR 10507 (HY000): Time to live of hbase table must be greater than 0

  • OceanBase error code: 10507

  • Cause: The Time To Live (TTL) of an HBase table must be greater than 0.

  • Solution: Check the KV_ATTRIBUTES attribute of the current table to ensure that the defined TimeToLive is greater than 0.

Note

This error code is introduced in V4.2.2.

ERROR 10508 (HY000): MaxVersions of hbase table must be greater than 0

  • OceanBase error code: 10508

  • Cause: The MaxVersions value of an HBase table must be greater than 0.

  • Solution: Check the KV_ATTRIBUTES attribute of the current table to ensure that the defined MaxVersions value is greater than 0.

Note

This error code is introduced in V4.2.2.

ERROR 10509 (HY000): Access denied, credential '%.*s' not match '%.*s'

  • OceanBase error code: 10509

  • Cause: Access is denied because the credentials '%.*s' do not match '%.*s'.

  • Solution: Enter the correct credentials again. Ensure the username and password are correct and no errors were made in the input.

Note

This error code is introduced in V4.3.0.

ERROR 10510 (HY000): Rowkey column count not match, schema rowkey count is '%ld', input rowkey count is '%ld'

  • OceanBase error code: 10510

  • Cause: The number of columns in the rowkey does not match the number of columns in the database table during the operation.

  • Solution: Make sure that the number of row key columns during operation is consistent with the actual number of row key columns in the table.

Note

This error code is introduced in V4.3.0.

ERROR 10511 (HY000): Column type for '%.*s' not match, schema column type is '%.*s', input column type is '%.*s'

  • OceanBase error code: 10511

  • Cause: The input column type does not match the column type of the database table. This may cause data conversion errors or prevent the operation from being executed correctly.

  • Solution: Ensure that the input column type matches the column type of the table during the operation.

Note

This error code is introduced in V4.3.0.

ERROR 10512 (HY000): Collation type for '%.*s' not match, schema collation type is '%.*s', input collation type is '%.*s'

  • OceanBase error code: 10512

  • Cause: The collation types do not match.

  • Solution: Ensure that the input collation type matches the table's collation type during the operation.

Note

This error code is introduced in V4.3.0.

ERROR 10513 (HY000): Scan range missing, input scan range cell count is '%ld', which should equal to rowkey count '%ld'

  • OceanBase error code: 10513

  • Cause: The number of columns in the scan range does not match the number of primary key columns in the table during a scan operation.

  • Solution: Ensure that the number of columns in the scan range equals the number of primary key columns during the scan operation.

Note

This error code is introduced in V4.3.0.

ERROR 10515 (HY000): Redis protocol parse error, the input redis string is: '%.*s'

  • OceanBase error code: 10515

  • Cause: Redis protocol parsing error.

  • Solution: The client may have sent a custom Redis command that is not supported by OceanBase Database, or the command format is incorrect.

Note

This error code is introduced in V4.3.1.

ERROR 10516 (HY000): When invoking the Increment interface, only HBase cells with a length of 8 can be converted to int64_t. the current length of the HBase cell is '%d'

  • OceanBase error code: 10516

  • Cause: When using the Increment API in OBKV-HBase, the value of the cell to be incremented or decremented must be an 8-byte long type (Java long/int64) in big-endian format (Big-Endian, meaning the high-order byte is placed first and the low-order byte is placed last). If the value is not an 8-byte long, the operation fails. Common causes include:

    • The incremental data written by the client is not an 8-byte long, such as strings, text, int32, etc., instead of being encoded as a long type.
    • The column previously had non-8-byte data written via Put or Append (such as strings, variable-length binary, etc.), causing the current value type to not be long.
  • Solution:

    • When the client writes incremental data, be sure to encode it as an 8-byte big-endian long (in Java, you can use org.apache.hadoop.hbase.util.Bytes.toBytes(long)).
    • If a cell already has data that is not a long, you can delete or overwrite it with a valid 8-byte long before performing an Increment operation.

ERROR 10518 (HY000): Check failed in %.*s"

  • OceanBase error code: 10518

  • Cause: When the rollbackWhenCheckFailed parameter of the OBKV checkAndInsertup interface is set to true, this error code is thrown if the check fails.

  • Solution: This error indicates a check failure. Handle it accordingly based on your business requirements, such as ignoring it or performing other necessary processing.

ERROR 10519 (HY000): '%.*s' is not disabled

  • OceanBase error code: 10519

  • Cause: The current table status is not DISABLED, so you cannot use the enableTable() or deleteTable() interface of HBase Admin.

  • Solution: Call the disableTable() interface of HBase Admin to set the table status to DISABLED, and then try again.

Note

This error code is introduced in V4.4.0.

ERROR 10520 (HY000): '%.*s' is not enabled

  • OceanBase error code: 10520

  • Cause: The current table is not in the ENABLED state, so the table cannot be accessed.

  • Solution: Call the enableTable() API of HBase Admin to set the table state to ENABLED, and then retry.

Note

This error code is introduced in V4.4.0.

ERROR 10521 (HY000): namespace '%.*s' is not found

  • OceanBase error code: 10521

  • Cause: The specified HBase namespace does not exist.

  • Solution: Create the corresponding HBase namespace in the OBKV-HBase database, and then retry.

Note

This error code is introduced in V4.4.0.

ERROR 10522 (HY000): table '%.*s' already exists

  • OceanBase error code: 10522

  • Cause: The specified HBase table already exists.

  • Solution: Verify whether the existing table meets your requirements. Otherwise, you can delete and recreate the HBase table you need.

Note

This error code is introduced in V4.4.0.

ERROR 10523 (HY000): table '%.*s' not found

  • OceanBase error code: 10523

  • Cause: The specified HBase table does not exist.

  • Solution: Create the corresponding HBase table.

Note

This error code is introduced in V4.4.0.

ERROR 10650 (HY000): ODP process timeout

  • OceanBase error code: 10650

  • Cause: The ODP process execution timed out.

  • Solution: Check whether the operation contains long-running steps, and increase the operation timeout.

Note

This error code is introduced in V4.3.0.

ERROR 11014 (HY000): Can't find FULLTEXT index matching the column list

  • OceanBase error code: 11014

  • Cause: No full-text index matching the query columns was found.

  • Solution: Verify whether the table has a full-text index and which columns it covers. Create a full-text index for the missing columns and make sure the query columns match the index columns.

ERROR 11015 (HY000): Can't update table '%s' while '%s' is being created.

  • OceanBase error code: 11015

  • Cause: The table cannot be updated while it is being created.

  • Solution: Wait until the table creation completes, and then retry.

ERROR 11018 (HY000): Invalid external file: %s

  • OceanBase error code: 11018

  • SQLSTATE: HY000

  • Cause: The specified external file cannot be read correctly.

  • Solution:

    • Verify that the file exists, the file path is correct, and the current user has access permissions for the file.

    • Check whether the file format or encoding matches.

    • Check whether the file content is corrupted or has format errors.

ERROR 11020 (HY000): HDFS: could not open file on hdfs

  • OceanBase error code: 11020

  • Cause:

    • The file may not exist or you may not have permission to access it.

    • The file open mode does not match.

  • Solution:

    • Verify that the file path is correct and the file actually exists on HDFS.

    • Check HDFS file permissions and make sure the current user has read or write permissions.

    • Verify that the HDFS namenode or datanode services are running properly.

ERROR 11021 (HY000): HDFS: error reading the file on hdfs

  • OceanBase error code: 11021

  • Cause: Failed to read the HDFS file.

  • Solution:

    • Verify that the HDFS datanode nodes are running properly and the network connection is normal.

    • Check HDFS logs (HDFS-related logs, not on the OceanBase Database server) to see whether there are corrupt blocks or unavailable replicas.

ERROR 11032 (HY000): HDFS path message %s

  • OceanBase error code: 11032

  • Cause: The HDFS path message %s error usually occurs in the following scenarios:

    1. In an HDFS environment with Kerberos authentication enabled, when you access an HDFS external table, if you do not have sufficient permissions to access it, error -11032 occurs.

    2. If Kerberos authentication is configured correctly but you still see HDFS: path not found, the external table path specified in the CREATE EXTERNAL TABLE statement may be incorrect and points to a non-existent path.

    3. If external table access works initially but error 11032 occurs after querying for a while, a file under the HDFS path of the external table may have a corrupt block. That is, the HDFS DataNode reports that the data block is corrupted and cannot be accessed, which triggers this error.

  • Solution:

    1. Verify that the Kerberos keytab and principal are valid and the corresponding user has access permissions for the HDFS cluster. Reconfigure external table permissions and set up Kerberos authentication.

    2. Verify that the corresponding HDFS path is correct and exists. Re-establish the HDFS path mapping for the external table.

    3. Report the issue to your operations team. After confirming the corrupt block situation, you can choose to repair the corrupt block or switch to another environment for further verification.

Note

This error code is introduced in V4.5.0.

ERROR 11042 (HY000): HDFS: malformed uri

  • OceanBase error code: 11042

  • Cause:

    • The URI is missing the hdfs:// prefix.

    • The URI is missing the path part. That is, there is no /path after hdfs://authority.

  • Solution:

    • Make sure the URI format is hdfs://<namenode>:<port>/<path>, which must include the complete scheme, authority, and path.

    • Check whether the spelling of the LOCATION field in the external table or backup configuration is correct.

ERROR 11043 (HY000): HDFS: invalid argument

  • OceanBase error code: 11043

  • Cause:

    • The HDFS URI format is incorrect.
    • The Kerberos authentication configuration is incorrect.
    • The HDFS client environment is not initialized or is invalid.
    • The HDFS connection parameters are invalid.
    • Failed to set HDFS configuration items.
  • Solution:

    • Check whether the HDFS URI format is correct and whether the HDFS-related configuration is complete.
    • Verify that the files required for Kerberos authentication (keytab, krb5.conf, ticket cache) exist and the paths are correct.
    • Check the network connectivity of the HDFS cluster and make sure the namenode is accessible.
    • Check whether the key=value format of custom HDFS configuration items is correct and make sure there are no empty keys or values.

ERROR 11044 (HY000): HDFS: not implementation

  • OceanBase error code: 11044

  • Cause: You are attempting to use a feature that HDFS has not implemented. The current HDFS storage backend does not support pwrite and append write operations.

ERROR 11045 (HY000): HDFS error

  • OceanBase error code: 11045

  • Cause:

    • Duplicate access. An already opened file may be opened again.

    • Operations such as delete, mkdir, and list are attempted before HDFS successfully establishes a connection.

    • File deletion failed. The file may not exist or you may not have sufficient permissions.

    • Directory creation failed.

    • Write failed.

    • Flush failed.

  • Solution:

    • Check HDFS file or directory permissions and make sure the current user has read, write, and delete permissions.

    • Verify that the target path exists and the format is correct.

    • Make sure the lifecycle management of HDFS components is correct to avoid duplicate access or operations before a connection is successfully established.

    • Check whether the HDFS cluster has sufficient disk space.

ERROR 11046 (HY000): Invalid path: %.*s

  • OceanBase error code: 11046

  • SQLSTATE: HY000

  • Cause:

    • The column name or path entered in the DDL does not match the spelling or case of the column name in the file (Parquet, ORC, Arrow, etc. are usually case-sensitive).

    • The nested structure path is incorrect. For example, you need to access addr.city, but the DDL uses addr_city or address.city.

    • Under the same external table, some files are missing the column.

    • Format symbol issues. For example, extra spaces, quotes before or after the column name, or escape errors.

  • Solution:

    • Verify that the data_access_path or EXTERNAL_FILE_COLUMN_PATTERN on external columns in the DDL statement actually exists in the file schema.

    • For nested types, use the actual hierarchical path separator in the file for an exact match.

    • If the schemas of files in different partitions are different, create separate external tables for the partitions with missing columns, or set a default value for the column to avoid directly mapping missing columns by path.

    • Modify the incorrect column definition and recreate the external table.

ERROR 11047 (HY000): Column type mismatch between the file and the table: FileColumnType=%s TableColumnType=%s

  • OceanBase error code: 11047

  • SQLSTATE: HY000

  • Cause: The column type in the file does not match the table definition.

  • Solution: Compare the file content with the table definition, identify the mismatched column types, and modify the table definition or file content.

ERROR 11049 (HY000): Exceed query memory limit (mem_limit=%ld, mem_hold=%ld), please check whether the query_memory_limit_percentage configuration item is reasonable.

  • OceanBase error code: 11049

  • Cause: The query memory exceeds the limit.

  • Solution: Check the value of the query_memory_limit_percentage configuration item and make sure the setting is reasonable.

ERROR 11050 (HY000): Odps driver throw exception: ExceptionMsg=%s

  • OceanBase error code: 11050

  • Cause: An ODPS driver exception occurred.

  • Solution:

    • Verify that the ODPS connection configuration is correct.

    • Check network connectivity and make sure the network connection is normal.

    • Verify that the ODPS table exists.

    • Check the ODPS table structure and permissions. Make sure the current user has Describe, Select, and project access permissions.

ERROR 11051 (HY000): Column type mismatch between the ODPS table and the OceanBase table: OdpsColumnType=%s TableColumnType=%s

  • OceanBase error code: 11051

  • Cause: The column data types of the ODPS table and the OceanBase external table definition do not match.

  • Solution: Check the actual structure of the ODPS table and the definition of the OceanBase external table, identify the mismatched columns and types, and then modify the OceanBase external table definition.

ERROR 11052 (HY000): unexpected error for exteran odps table:%s

  • OceanBase error code: 11052

  • Cause:

    • Network or connection interruption during the query.

    • ODPS server exception.

    • Incorrect data format in the ODPS table.

    • Resource limits on ODPS or OceanBase Database.

  • Solution:

    • Check network connectivity.

    • Check the ODPS service status.

    • Check the data format in the ODPS table for data encoding issues, unhandled special characters, or data corruption.

    • Check resource limits on ODPS or OceanBase Database, such as insufficient memory or computation limits.

ERROR 11053 (HY000): unexpected error for jni

  • OceanBase error code: 11053

  • Cause: A Java error exception occurred.

  • Solution: Check the error exception log context to identify the root cause and resolve it.

ERROR 11054 (HY000): class could not be found during jni operation

  • OceanBase error code: 11054

  • Cause: A class does not exist or cannot be found.

  • Solution: Check the current log to see which class cannot be found. Download and install the corresponding JAR package to the appropriate path, and restart OBServer.

ERROR 11055 (HY000): method could not be found during jni operation

  • OceanBase error code: 11055

  • Cause: A method in a class does not exist or cannot be found.

  • Solution: Check the current log to see which method of which class cannot be found. The corresponding JAR package may be missing, or a version mismatch may have caused the method to be missing. Download the corresponding JAR package to the appropriate path and restart OBServer.

ERROR 11056 (HY000): jvm.so not found %s

  • OceanBase error code: 11056

  • Cause: When creating or accessing external tables such as HDFS or ODPS in OceanBase Database, this error is triggered because JVM environment initialization failed.

  • Solution: Check whether the JVM runtime environment configuration is correct.

Note

This error code is introduced in V4.5.0.

ERROR 11057 (HY000): JNI env could not delete ref

  • OceanBase error code: 11057

  • Cause: Failed to delete a reference in the Java environment.

  • Solution: There may be a code logic error. This error does not exist in the current code logic because the corresponding logic has been removed. Contact technical support for assistance.

ERROR 11058 (HY000): cur java home path %s

  • OceanBase error code: 11058

  • Cause: The JAVA path is set incorrectly.

  • Solution: Configure the correct JAVA path.

Note

This error code is introduced in V4.5.0.

ERROR 11059 (HY000): JNI cound not ensure capacity

  • OceanBase error code: 11059

  • Cause: The maximum and minimum heap memory sizes set in ob_java_opts for Java startup are too small, or the machine does not have sufficient memory resources.

  • Solution: Check the machine memory resources, the memory size set for the current Java process, and the ob_java_opts environment variable settings.

ERROR 11060 (HY000): field could not be found during jni operation

  • OceanBase error code: 11060

  • Cause: A field in a class does not exist.

  • Solution: Update and replace the compatible JAR package. The JAR package is expected to have this field.

ERROR 11061 (HY000): object could not be found during jni operation

  • OceanBase error code: 11061

  • Cause: During the operation, a JNI-generated class object instance does not exist.

  • Solution: There is a code logic issue that caused this problem. Contact technical support for assistance.

ERROR 11063 (HY000): missing format for external table

  • OceanBase error code: 11063

  • Cause: When creating an external table, the file format is not specified or no valid format configuration appears in the DDL statement.

  • Solution:

    • Add a FORMAT clause in the CREATE EXTERNAL TABLE statement and specify a TYPE consistent with the actual file.

    • Verify that the TYPE is consistent with the actual file extension and content (for example, if the directory contains .parquet files, use PARQUET instead of CSV).

    • If you use CSV, add delimiter, encoding, and other parameters as needed to avoid query parsing exceptions after the table is created successfully.

ERROR 11064 (HY000): missing access path for external table

  • OceanBase error code: 11064

  • Cause: When creating an external table, the data access path is not specified. Usually, LOCATION is not configured, is empty, or is not correctly bound to a Location object.

  • Solution:

    • Add LOCATION in the DDL statement to point to the directory or URL where external data is actually stored.

    • Make sure the path is accessible to the OceanBase cluster (configure network, authentication, mounting, object storage AK/SK, etc. according to your environment).

    • If you use a Location object, make sure the object has been created and the current user has read permissions before referencing it on the external table.

    • We recommend that you use a protocol prefix agreed upon with relevant personnel (such as file://, oss://, hdfs://, etc., depending on the version supported).

ERROR 11065 (HY000): fail to read orc file, message: %s

  • OceanBase error code: 11065

  • Cause: Failed to read the ORC file.

  • Solution: Check the ORC file message: %s.

Note

This error code is introduced in V4.4.0.

ERROR 11076 (HY000): The plugin's version is incompatible with current server

  • OceanBase error code: 11076

  • Cause: The plugin to be loaded is incompatible with the current observer process.

  • Solution: Find a plugin compatible with the observer version on the node where the specific error occurred, upload it again, and retry the installation.

ERROR 11077 (HY000): Failed to open library

  • OceanBase error code: 11077

  • Cause: Failed to load the specified dynamic library plugin.

  • Solution: Check whether the plugin dynamic library to be loaded exists in the plugin_dir directory under the observer execution path on all nodes, and make sure the plugin dynamic library has read and execute permissions and that the dependent glibc version is not higher than the local glibc version.

ERROR 11078 (HY000): Plugin internal error

  • OceanBase error code: 11078

  • Cause: An internal error occurred. This is a defensive error when processing plugin-related functions.

  • Solution: This is an internal error code. Contact technical support for assistance.

ERROR 11079 (HY000): Can't create catalog '%.*s'; catalog exists

  • OceanBase error code: 11079

  • Cause: A catalog with the same name already exists.

  • Solution: Use the IF NOT EXISTS keyword or delete the old catalog and then recreate it.

ERROR 11080 (HY000): Catalog '%.*s' doesn't exist

  • OceanBase error code: 11080

  • Cause: The catalog to be queried has been deleted.

  • Solution: Create a new catalog.

ERROR 11081 (HY000): skip_header and parse_header cannot be used at the same time

  • OceanBase error code: 11081

  • Cause: PARSE_HEADER and SKIP_HEADER cannot be used at the same time because they conflict semantically.

  • Solution: When specifying attributes related to external file formats, do not use PARSE_HEADER and SKIP_HEADER at the same time.

ERROR 11082 (HY000): DDL operations on the internal catalog are not allowed

  • OceanBase error code: 11082

  • Cause: DDL operations on the internal catalog are not allowed.

  • Solution: Check the type of the catalog to be operated on.

ERROR 11083 (HY000): Command denied to user '%.*s'@'%.*s' for catalog '%.*s'

  • OceanBase error code: 11083

  • Cause: The user does not have operation permissions for the catalog.

  • Solution: Check whether the user has permissions for the catalog and grant the user the corresponding catalog operation permissions.

ERROR 11085 (HY000): CCL rule '%.*s' already exists

  • OceanBase error code: 11085

  • Cause: When creating a CCL rule, a rule with the same name already exists.

  • Solution: Use the IF NOT EXISTS keyword or delete the old rule and then recreate it.

ERROR 11086 (HY000): CCL rule '%.*s' doesn't exist

  • OceanBase error code: 11086

  • Cause: When modifying or deleting a CCL rule, the rule does not exist.

  • Solution: Use the IF EXISTS keyword or verify that the rule name is correct.

ERROR 11087 (HY000): SQL reach max ccl rule %s, concurrent num %ld

  • OceanBase error code: 11087

  • Cause: The SQL concurrency has reached the upper limit of the CCL rule.

  • Solution: Retry after the concurrency decreases, or increase the value of MAX_CONCURRENCY.

ERROR 11089 (HY000): Location is still in use

  • OceanBase error code: 11089

  • Cause: The Location object being accessed is still in use by external tables.

  • Solution: Check all external tables that depend on this Location object, verify that the dependencies have been removed, and then retry the operation.

ERROR 11090 (HY000): Location access denied

  • OceanBase error code: 11090

  • Cause: The specified Location object cannot be accessed.

  • Solution: Check the user's access permissions for the Location object. Use the GRANT READ ON LOCATION location_name TO user_name WITH GRANT OPTION; command to grant the user READ permissions.

ERROR 11091 (HY000): Can't create location '%.*s'; location exists

  • OceanBase error code: 11091

  • Cause: The specified Location object already exists and cannot be created.

  • Solution: Check whether the specified Location object already exists. Add the OR REPLACE keyword to replace the original Location object definition with a new one, or create a new Location object.

ERROR 11092 (HY000): location '%.*s' doesn't exist

  • OceanBase error code: 11092

  • Cause: The specified Location object does not exist.

  • Solution: Check whether the specified Location object exists and specify the correct Location object.

ERROR 11093 (HY000): OBLogService rpc execute failed

  • OceanBase error code: 11093

  • Cause: Log service RPC execution failed due to insufficient resources on the target node or a network failure.

  • Solution: Use trace_id to locate the target node logs first, and resolve the issue by combining resource monitoring and parameter adjustments.

Note

This error code is introduced in V4.4.0.

ERROR 11094 (HY000): Sensitive rule '%.*s' exists

  • OceanBase error code: 11094

  • Cause: A sensitive rule with the same name already exists. This usually occurs when adding a sensitive rule through a DDL statement and the new rule has the same name as an existing rule.

  • Solution: Check whether the specified sensitive rule name already exists and specify a name that does not exist.

ERROR 11095 (HY000): Sensitive rule '%.*s' does not exist

  • OceanBase error code: 11095

  • Cause: No sensitive rule with the specified name exists. This usually occurs when deleting a sensitive rule through a DDL statement and specifying a rule name that does not exist.

  • Solution: Check whether the entered sensitive rule name is correct and enter the correct sensitive rule name.

ERROR 11096 (HY000): Sensitive column %.*s(%.*s) exists

  • OceanBase error code: 11096

  • Cause: The column with the specified name is already a sensitive column. This usually occurs when adding or modifying a sensitive rule through a DDL statement and attempting to apply a sensitive rule to a column already covered by another sensitive rule.

  • Solution: Check whether the specified column is a sensitive column and choose an appropriate column to add the sensitive rule.

ERROR 11097 (HY000): Sensitive column %.*s(%.*s) does not exist

  • OceanBase error code: 11097

  • Cause: No sensitive column with the specified name exists. This usually occurs when modifying a sensitive rule through a DDL statement and attempting to remove a column that is not a sensitive column.

  • Solution: Check whether the specified sensitive column exists and enter the correct sensitive column name.

ERROR 11098 (HY000): %.*s command denied to user '%.*s'@'%.*s' for sensitive rule '%.*s'

  • OceanBase error code: 11098

  • Cause: The user does not have permission to execute the sensitive rule command '%.*s'. This usually occurs when a DML statement (such as INSERT, UPDATE, or REPLACE) accesses columns protected by sensitive rules.

  • Solution: Check user permissions. Use the GRANT PLAINACCESS ON SENSITIVE RULE '%.*s' TO '%.*s'@'%.*s' command to grant the user appropriate plain-text access permissions.

Note

This error code is introduced in V4.4.2.

ERROR 11099 (HY000): Invalid sensitive rule name '%.*s'

  • OceanBase error code: 11099

  • Cause: Invalid sensitive rule name.

  • Solution: Check whether the specified sensitive rule name is correct and enter the correct sensitive rule name.

ERROR 11100 (HY000): kerberos execution error

  • OceanBase error code: 11100

  • Cause: Kerberos execution error, which may be caused by incorrect configuration or invalid key files.

  • Solution: Check the Kerberos configuration file (such as krb5.conf) and key file paths, and make sure the permissions and content are correct.

Note

This error code is introduced in V4.4.1.

ERROR 11101 (HY000): HMS execution error

  • OceanBase error code: 11101

  • Cause: HMS execution error, which may be caused by service unavailability or incorrect configuration.

  • Solution: Verify the HMS service status, check whether connection parameters (such as address and port) are correct, and check HMS logs to troubleshoot the specific issue.

Note

This error code is introduced in V4.4.1.

ERROR 11102 (HY000): HMS host: '%.*s' is invalid

  • OceanBase error code: 11102

  • Cause: The HMS host is invalid. The host address format may be invalid or cannot be resolved.

  • Solution: Check the HMS IP address format and make sure the configuration is correct.

Note

This error code is introduced in V4.4.1.

ERROR 11103 (HY000): HMS port: '%.*s' is invalid

  • OceanBase error code: 11103

  • Cause: The HMS port is invalid.

  • Solution: Make sure the port number conforms to the specification and check whether firewall rules allow access to this port.

Note

This error code is introduced in V4.4.1.

ERROR 11104 (HY000): HMS table location: '%.*s' is invalid

  • OceanBase error code: 11104

  • Cause: The HMS table storage path is invalid.

  • Solution: Verify that the table path exists and make sure OceanBase Database has read/write permissions.

Note

This error code is introduced in V4.4.1.

ERROR 11105 (HY000): HMS service: '%.*s' is invalid

  • OceanBase error code: 11105

  • Cause: The HMS service is invalid.

  • Solution: Check whether the HMS service name matches the actual deployment and make sure the service has started properly.

Note

This error code is introduced in V4.4.1.

ERROR 11106 (HY000): HMS service FQDN: '%.*s' is invalid

  • OceanBase error code: 11106

  • Cause: The HMS service FQDN format is incorrect or cannot be resolved.

  • Solution: Verify the FQDN format and make sure DNS resolution works properly.

Note

This error code is introduced in V4.4.1.

ERROR 11107 (HY000): HMS transport: '%.*s' is invalid

  • OceanBase error code: 11107

  • Cause: The HMS transport is invalid.

  • Solution: Make sure the transport protocol is compatible with the HMS service.

Note

This error code is introduced in V4.4.1.

ERROR 11108 (HY000): HMS metastore: '%.*s' is invalid

  • OceanBase error code: 11108

  • Cause: Invalid HMS metastore.

  • Solution: Check the connection parameters of the HMS metadata database.

Note

This error code is introduced in V4.4.1.

ERROR 11109 (HY000): HMS partition error

  • OceanBase error code: 11109

  • Cause: HMS partition operation failed, which may be caused by partition field type mismatch or data conflicts.

  • Solution: Check the partition field definition and data content to make sure they comply with HMS metadata specifications.

Note

This error code is introduced in V4.4.1.

ERROR 11110 (HY000): HMS database: '%.*s' not found

  • OceanBase error code: 11110

  • Cause: The requested HMS database does not exist.

  • Solution: Make sure the database name is spelled correctly, or contact the administrator to create the target database.

Note

This error code is introduced in V4.4.1.

ERROR 11111 (HY000): HMS table: '%.*s' not found

  • OceanBase error code: 11111

  • Cause: The requested HMS table does not exist.

  • Solution: Check the table name spelling and database context, and make sure the table has been created correctly.

Note

This error code is introduced in V4.4.1.

ERROR 11112 (HY000): This ai model endpoint '%.*s' not found in the tenant

  • OceanBase error code: 11112

  • Cause: The AI model endpoint name entered by the user does not exist.

  • Solution: Query the DBA_OB_AI_MODEL_ENDPOINTS view to check whether a corresponding endpoint record exists. If not, use DBMS_AI_SERVICE.CREATE_AI_MODEL_ENDPOINT to create the corresponding endpoint record.

Note

This error code is introduced in V4.4.1.

ERROR 11113 (HY000): This ai model endpoint '%.*s' is already exists

  • OceanBase error code: 11113

  • Cause: The AI model endpoint name entered by the user already exists.

  • Solution: Use a different AI model endpoint name to create it.

Note

This error code is introduced in V4.4.1.

ERROR 11114 (HY000): The param '%.*s' is empty or null

  • OceanBase error code: 11114

  • Cause: The parameter of the DBMS_AI_SERVICE subprogram specified by the user cannot be empty or NULL.

  • Solution: Check whether the parameter of the DBMS_AI_SERVICE subprogram specified by the user is empty or NULL. Refer to the parameter descriptions in DBMS_AI_SERVICE subprogram overview.

Note

This error code is introduced in V4.4.1.

ERROR 11115 (HY000): The param '%.*s' is invalid

  • OceanBase error code: 11115

  • Cause: The parameter name of the DBMS_AI_SERVICE subprogram specified by the user does not meet the requirements.

  • Solution: Use a valid parameter name. Refer to the parameter descriptions in DBMS_AI_SERVICE subprogram overview.

Note

This error code is introduced in V4.4.1.

ERROR 11116 (HY000): The value of param '%.*s' is invalid

  • OceanBase error code: 11116

  • Cause: The parameter value of the DBMS_AI_SERVICE subprogram specified by the user does not meet the requirements.

  • Solution: Use a valid parameter value. Refer to the parameter descriptions in DBMS_AI_SERVICE subprogram overview.

Note

This error code is introduced in V4.4.1.

ERROR 11117 (HY000): This type of param '%.*s' is invalid, should be %.*s

  • OceanBase error code: 11117

  • Cause: The parameter type of the DBMS_AI_SERVICE subprogram specified by the user does not meet the requirements.

  • Solution: Use a valid parameter type. Refer to the parameter descriptions in DBMS_AI_SERVICE subprogram overview.

Note

This error code is introduced in V4.4.1.

ERROR 11118 (HY000): This ai model '%.*s' not found in the tenant

  • OceanBase error code: 11118

  • Cause: The AI model specified by the user does not exist.

  • Solution: Query the DBA_OB_AI_MODELS view to check whether a corresponding model record exists. If not, use DBMS_AI_SERVICE.CREATE_AI_MODEL to create the corresponding model record.

Note

This error code is introduced in V4.4.1.

ERROR 11119 (HY000): This ai model '%.*s' is already exists

  • OceanBase error code: 11119

  • Cause: The AI model specified by the user already exists.

  • Solution: Use a different AI model name to create it.

Note

This error code is introduced in V4.4.1.

ERROR 11120 (HY000): Got error during COMMIT: %s

  • OceanBase error code: 11120

  • Compatible MySQL error code: 1180

  • Cause: An error occurred during the commit phase of the transaction.

  • Solution: The key to resolving this issue is to identify the root cause through detailed logs. After obtaining the specific error information, we recommend that you seek official technical support for the most accurate solution.

Note

This error code is introduced in V4.4.1.

ERROR 11121 (HY000): Table snapshot '%.*s' does not exist

  • OceanBase error code: 11121

  • Cause: The table snapshot does not exist.

  • Solution: Verify whether the snapshot exists. If it does not exist, recreate the required snapshot.

Note

This error code is introduced in V4.5.0.

ERROR 11122 (HY000): Bad http request: %s

  • OceanBase error code: 11122

  • Cause: HTTP request error.

  • Solution: Check whether the HTTP request parameters are correct.

Note

This error code is introduced in V4.5.0.

ERROR 11123 (HY000): Unauthorized http request: %s

  • OceanBase error code: 11123

  • Cause: HTTP request authorization denied.

  • Solution: Check whether the HTTP request authentication information is set correctly.

Note

This error code is introduced in V4.5.0.

ERROR 11124 (HY000): Http request not found: %s

  • OceanBase error code: 11124

  • Cause: HTTP request not found.

  • Solution: Check whether the requested resource exists.

Note

This error code is introduced in V4.5.0.

ERROR 11125 (HY000): Http server error: %s

  • OceanBase error code: 11125

  • Cause: HTTP server error.

  • Solution: Check the status of the HTTP service being accessed.

Note

This error code is introduced in V4.5.0.

ERROR 11126 (HY000): unit '%.*s' not recognized

  • OceanBase error code: 11126

  • Cause: When calling a date truncation function (such as DATE_TRUNC or DATETRUNC), the time unit parameter passed in is not recognized.

  • Solution: Check the first parameter of the date truncation function in your SQL statement and make sure it is spelled correctly and is a valid time unit keyword supported by OceanBase Database.

Note

This error code is introduced in V4.5.0.

ERROR 11127 (HY000): Privilege not allowed for sensitive rules

  • OceanBase error code: 11127

  • Cause: An operation related to sensitive data rules was performed, but the permissions held are insufficient for this operation.

  • Solution: Confirm the permissions required for the operation and grant the corresponding permissions.

Note

This error code is introduced in V4.5.0.

Previous topic

9500 to 9999
Last

Next topic

22998, 30926, 38104, and 38105
Next
What is on this page
ERROR 10500 (HY000): incorrect route for obkv global index, client router should refresh.
ERROR 10501 (HY000): TTL feature is not enabled
ERROR 10502 (HY000): TTL column '%.*s' not exists
ERROR 10503 (HY000): Column type of '%.*s' is not supported for TTL definition
ERROR 10504 (HY000): TTL command is not allowed, current TTL status is '%s'
ERROR 10505 (HY000): No TTL task is running, please try trigger a new TTL task
ERROR 10506 (HY000): Cannot execute TTL task during tenant is restore
ERROR 10507 (HY000): Time to live of hbase table must be greater than 0
ERROR 10508 (HY000): MaxVersions of hbase table must be greater than 0
ERROR 10509 (HY000): Access denied, credential '%.*s' not match '%.*s'
ERROR 10510 (HY000): Rowkey column count not match, schema rowkey count is '%ld', input rowkey count is '%ld'
ERROR 10511 (HY000): Column type for '%.*s' not match, schema column type is '%.*s', input column type is '%.*s'
ERROR 10512 (HY000): Collation type for '%.*s' not match, schema collation type is '%.*s', input collation type is '%.*s'
ERROR 10513 (HY000): Scan range missing, input scan range cell count is '%ld', which should equal to rowkey count '%ld'
ERROR 10515 (HY000): Redis protocol parse error, the input redis string is: '%.*s'
ERROR 10516 (HY000): When invoking the Increment interface, only HBase cells with a length of 8 can be converted to int64_t. the current length of the HBase cell is '%d'
ERROR 10518 (HY000): Check failed in %.*s"
ERROR 10519 (HY000): '%.*s' is not disabled
ERROR 10520 (HY000): '%.*s' is not enabled
ERROR 10521 (HY000): namespace '%.*s' is not found
ERROR 10522 (HY000): table '%.*s' already exists
ERROR 10523 (HY000): table '%.*s' not found
ERROR 10650 (HY000): ODP process timeout
ERROR 11014 (HY000): Can't find FULLTEXT index matching the column list
ERROR 11015 (HY000): Can't update table '%s' while '%s' is being created.
ERROR 11018 (HY000): Invalid external file: %s
ERROR 11020 (HY000): HDFS: could not open file on hdfs
ERROR 11021 (HY000): HDFS: error reading the file on hdfs
ERROR 11032 (HY000): HDFS path message %s
ERROR 11042 (HY000): HDFS: malformed uri
ERROR 11043 (HY000): HDFS: invalid argument
ERROR 11044 (HY000): HDFS: not implementation
ERROR 11045 (HY000): HDFS error
ERROR 11046 (HY000): Invalid path: %.*s
ERROR 11047 (HY000): Column type mismatch between the file and the table: FileColumnType=%s TableColumnType=%s
ERROR 11049 (HY000): Exceed query memory limit (mem_limit=%ld, mem_hold=%ld), please check whether the query_memory_limit_percentage configuration item is reasonable.
ERROR 11050 (HY000): Odps driver throw exception: ExceptionMsg=%s
ERROR 11051 (HY000): Column type mismatch between the ODPS table and the OceanBase table: OdpsColumnType=%s TableColumnType=%s
ERROR 11052 (HY000): unexpected error for exteran odps table:%s
ERROR 11053 (HY000): unexpected error for jni
ERROR 11054 (HY000): class could not be found during jni operation
ERROR 11055 (HY000): method could not be found during jni operation
ERROR 11056 (HY000): jvm.so not found %s
ERROR 11057 (HY000): JNI env could not delete ref
ERROR 11058 (HY000): cur java home path %s
ERROR 11059 (HY000): JNI cound not ensure capacity
ERROR 11060 (HY000): field could not be found during jni operation
ERROR 11061 (HY000): object could not be found during jni operation
ERROR 11063 (HY000): missing format for external table
ERROR 11064 (HY000): missing access path for external table
ERROR 11065 (HY000): fail to read orc file, message: %s
ERROR 11076 (HY000): The plugin's version is incompatible with current server
ERROR 11077 (HY000): Failed to open library
ERROR 11078 (HY000): Plugin internal error
ERROR 11079 (HY000): Can't create catalog '%.*s'; catalog exists
ERROR 11080 (HY000): Catalog '%.*s' doesn't exist
ERROR 11081 (HY000): skip_header and parse_header cannot be used at the same time
ERROR 11082 (HY000): DDL operations on the internal catalog are not allowed
ERROR 11083 (HY000): Command denied to user '%.*s'@'%.*s' for catalog '%.*s'
ERROR 11085 (HY000): CCL rule '%.*s' already exists
ERROR 11086 (HY000): CCL rule '%.*s' doesn't exist
ERROR 11087 (HY000): SQL reach max ccl rule %s, concurrent num %ld
ERROR 11089 (HY000): Location is still in use
ERROR 11090 (HY000): Location access denied
ERROR 11091 (HY000): Can't create location '%.*s'; location exists
ERROR 11092 (HY000): location '%.*s' doesn't exist
ERROR 11093 (HY000): OBLogService rpc execute failed
ERROR 11094 (HY000): Sensitive rule '%.*s' exists
ERROR 11095 (HY000): Sensitive rule '%.*s' does not exist
ERROR 11096 (HY000): Sensitive column %.*s(%.*s) exists
ERROR 11097 (HY000): Sensitive column %.*s(%.*s) does not exist
ERROR 11098 (HY000): %.*s command denied to user '%.*s'@'%.*s' for sensitive rule '%.*s'
ERROR 11099 (HY000): Invalid sensitive rule name '%.*s'
ERROR 11100 (HY000): kerberos execution error
ERROR 11101 (HY000): HMS execution error
ERROR 11102 (HY000): HMS host: '%.*s' is invalid
ERROR 11103 (HY000): HMS port: '%.*s' is invalid
ERROR 11104 (HY000): HMS table location: '%.*s' is invalid
ERROR 11105 (HY000): HMS service: '%.*s' is invalid
ERROR 11106 (HY000): HMS service FQDN: '%.*s' is invalid
ERROR 11107 (HY000): HMS transport: '%.*s' is invalid
ERROR 11108 (HY000): HMS metastore: '%.*s' is invalid
ERROR 11109 (HY000): HMS partition error
ERROR 11110 (HY000): HMS database: '%.*s' not found
ERROR 11111 (HY000): HMS table: '%.*s' not found
ERROR 11112 (HY000): This ai model endpoint '%.*s' not found in the tenant
ERROR 11113 (HY000): This ai model endpoint '%.*s' is already exists
ERROR 11114 (HY000): The param '%.*s' is empty or null
ERROR 11115 (HY000): The param '%.*s' is invalid
ERROR 11116 (HY000): The value of param '%.*s' is invalid
ERROR 11117 (HY000): This type of param '%.*s' is invalid, should be %.*s
ERROR 11118 (HY000): This ai model '%.*s' not found in the tenant
ERROR 11119 (HY000): This ai model '%.*s' is already exists
ERROR 11120 (HY000): Got error during COMMIT: %s
ERROR 11121 (HY000): Table snapshot '%.*s' does not exist
ERROR 11122 (HY000): Bad http request: %s
ERROR 11123 (HY000): Unauthorized http request: %s
ERROR 11124 (HY000): Http request not found: %s
ERROR 11125 (HY000): Http server error: %s
ERROR 11126 (HY000): unit '%.*s' not recognized
ERROR 11127 (HY000): Privilege not allowed for sensitive rules