Analyze SQL statements|V4.2.4| docs|Distributed Database

OceanBase Developer Center

V4.2.4

Overview
- What is ODC?
- Features
- Architecture
- Limitations
- ODC console
Quick Start
- Client ODC
  - Overview
  - Install Client ODC
  - Use Client ODC
- Web ODC
  - Overview
  - Deploy Web ODC
  - Use Web ODC
Data Source Management
- Create a data source
- Data sources and project collaboration
- Database O&M
  - Session management
  - Global variable management
  - Recycle bin management
SQL Development
- Write and execute SQL statements
- Perform PL compilation and debugging
- Use the command-line window
- Edit and export the result set of an SQL statement
- Analyze SQL statements
- Generate test data
- Database objects
  - Table objects
    - Overview
    - Create a table
    - Table list
    - Manage table attributes
    - Manage table data
  - View objects
    - Overview
    - Create a view
    - Manage views
  - Function objects
    - Overview
    - Create a function
    - Manage functions
  - Stored procedure objects
    - Overview
    - Create a stored procedure
    - Manage stored procedures
  - Sequence objects
    - Overview
    - Create a sequence
    - Manage sequences
  - Package objects
    - Overview
    - Create a program package
    - Manage program packages
  - Trigger objects
    - Overview
    - Create a trigger
    - Manage triggers
  - Type objects
    - Overview
    - Create a type
    - Manage types
  - Synonym objects
    - Overview
    - Create a synonym
    - Manage synonyms
Import and Export
- Import schemas and data
- Export schemas and data
Database Change Management
- User Permission Management
  - Users and roles
  - Automatic authorization
- Project collaboration management
- Risk levels, risk identification rules, and approval processes
- SQL check specifications
- SQL window specification
- Database change management
- Lock-free schema changes
- Synchronize shadow tables
- Schema comparison
- Message notification management
Data Lifecycle Management
- Archive data
- Clean up data
- Partitioning Plan Management
  - Manage partitioning plans
  - Set partitioning strategies
  - Examples
- SQL plan task
Data Desensitization and Auditing
- Desensitize data
- Operation records
System Integration
- Login integration
- Approval integration
- SQL approval integration
Deployment Guide
- Deployment overview
- Preparations before deployment
- Deploy ODC in single-node mode
- Deploy ODC in high-availability mode
- Deployment verification
Upgrade Guide
- Preparations before upgrade
- Update single-node ODC
- Update high-avaliability ODC
- Upgrade verification
- Rollback after upgrade failed
Troubleshooting
- ODC troubleshooting process
- Collect Message
  - View the runtime environment and version information
  - View web ODC logs
  - View client ODC logs
  - View end-to-end ODC-related logs
  - View ODC MetaDB data
  - Query the index status in OceanBase Database V4.x
  - Query the index status in OceanBase Database V1.4.x to V3.2.x
  - Collect JVM runtime information
  - Use tcpdump to capture packets
- Common Troubleshooting
  - Deployment Upgrade
    - Web ODC cannot be accessed after startup
  - Database Connection
    - Access denied in a connection trial or test
    - Connection is refused in a connection trial or test
    - Connection times out
    - `Connection reset` is reported for a time-consuming statement
    - `socket write error` or `closed by server` is reported for a connection
  - SQL Execution
    - Disconnection during SQL execution
    - `Over tenant memory limits` is reported during SQL execution
    - `Unknown thread id` is returned during SQL execution
    - `timeout` errors returned during SQL execution
    - `OutOfMemoryError` is returned during SQL execution
    - Incomplete result columns for the SELECT statement
    - Garbled Chinese characters in the SQL execution result set
    - Garbled Chinese data is returned for query of data in GBK encoding
  - PL Object
    - Debugging is not supported for invalid PL objects
    - `JSONException` is reported during PL debugging
    - Garbled variable values in debugging
    - Failed to view PL objects or garbled characters are returned
    - PL objects cannot be executed or an execution error is returned
    - ODC issues during PL debugging
    - PL anonymous block cannot be debugged
    - Alert information of a PL object is unavailable
  - Import and Export
    - Garbled Chinese characters in an imported file in GBK encoding
    - Invalid ZIP package reported during file import
    - Time-type data exported from an Oracle tenant cannot be imported
    - Mismatched columns reported during the import of a single-table CSV file
    - Failed to export a result set in ODC to an Excel file
    - Incorrect display in Excel for a result set exported in CSV format
    - Incomplete data in batch export of multiple tables
    - `javax.crypto.BadPaddingException: Given final block not properly padded` is returned for a data import or export failure
  - Client ODC Problems
    - Client ODC startup failure / H2 Database corruption: Chuck not found
    - Garbled Chinese characters in the command-line window of ODC
    - Failed to install client ODC
    - Client ODC startup failure or no response
    - `Not a valid secret key` is returned for connection creation in client ODC
    - `User does not exist` returned for connection creation in client ODC
    - High memory usage of client ODC
    - Client ODC fails to be installed or start due to a port conflict
  - Front-end Page Exception
    - JavaScript exception is thrown on the ODC page
    - No response in browser after opening ODC
    - White screen in ODC
  - Account Password Problem
    - Forgot the admin account password in ODC V3.2.0 or later
    - Forgot an account password in ODC V2.4.1 to V3.1.3
    - Forgot an account password in ODC V2.4.0 or earlier
- FAQ
  - Installation of client ODC
  - Web ODC deployment and startup
  - FAQ
  - Command-line window
  - DDL statement display
Release Note
- V4.2
  - ODC V4.2.4
  - ODC V4.2.3
  - ODC V4.2.2
  - ODC V4.2.0
  - ODC V4.2.1
- V4.1
  - ODC V4.1.2
  - ODC V4.1.1
  - ODC V4.1.0
- V4.0
  - ODC V4.0.2
  - ODC V4.0.0
- V3.4
  - ODC V3.4.0
- V3.3
  - ODC V3.3.3
  - ODC V3.3.2
  - ODC V3.3.1
  - ODC V3.3.0
- V3.2
  - ODC V3.2.3
  - ODC V3.2.2
  - ODC V3.2.1
  - ODC V3.2.0