我的书签
添加书签
移除书签本章将分篇介绍几种常用的数据迁移方法及工具：
数据迁移概述
- 开发者指南（Oracle 模式）
- 工作在全球化环境
- 连接 OceanBase 数据库
- 通过 OBClient 连接 OceanBase 数据库租户
- 通过 MySQL 客户端连接 MySQL 租户
- 通过 obclient 连接 OceanBase 租户
- 创建 OceanBase 示例数据库 TPCC
- 通过 MySQL 客户端连接 OceanBase 租户
- 通过 ODC 连接 OceanBase 数据库
- 查询表数据
- 通过 obclient 连接 OceanBase 租户
- 通过 obclient 探索 OceanBase Oracle 租户
- 创建 OceanBase 示例数据库 TPCC
- 通过 ODC 探索 OceanBase Oracle 租户
- 通过 obclient 探索 OceanBase MySQL 租户
- 通过 ODC 连接 OceanBase 数据库
- 查询表数据
- 向 OceanBase 迁移数据
- 附录
- 创建和管理数据库对象
- 关于 DML 语句和事务
- 构建可扩展的应用程序
- 前言
- SQL 调优指南
- 术语表
- 版本发布记录
- 管理员指南
- 开发者指南（MySQL 模式）
- 参考指南（MySQL 模式）
- 系统视图
- 字典视图
- information_schema.REFERENTIAL_CONSTRAINTS
- oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY
- information_schema.SCHEMA_PRIVILEGES
- information_schema.ENGINES
- information_schema.TABLE_PRIVILEGES
- oceanbase.CDB_OB_BACKUP_CLEAN_HISTORY
- information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
- mysql.time_zone
- information_schema.PARTITIONS
- information_schema.VIEWS
- information_schema.TABLE_CONSTRAINTS
- mysql.time_zone_name
- information_schema.COLUMNS
- oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB
- mysql.user
- mysql.help_keyword
- information_schema.GLOBAL_STATUS
- information_schema.PROCESSLIST
- oceanbase.CDB_CKPT_HISTORY
- information_schema.SESSION_VARIABLES
- oceanbase.CDB_OB_BACKUP_PROGRESS
- information_schema.GLOBAL_VARIABLES
- oceanbase.CDB_OB_BACKUP_VALIDATION_JOB
- oceanbase.CDB_OB_BACKUP_TASK_CLEAN_HISTORY
- information_schema.USER_RECYCLEBIN
- information_schema.CHARACTER_SETS
- mysql.help_relation
- oceanbase.CDB_OB_BACKUP_SET_EXPIRED
- information_schema.TABLES
- oceanbase.CDB_OB_BACKUP_VALIDATION_TASK_HISTORY
- information_schema.PARAMETERS
- oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK
- mysql.proc
- oceanbase.CDB_OB_BACKUP_VALIDATION_JOB_HISTORY
- information_schema.ROUTINES
- mysql.time_zone_transition
- oceanbase.CDB_OB_RESTORE_HISTORY
- information_schema.SCHEMATA
- information_schema.STATISTICS
- oceanbase.CDB_OB_BACKUP_SET_DETAILS
- mysql.time_zone_transition_type
- mysql.db
- oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY
- oceanbase.CDB_OB_BACKUP_ARCHIVELOG_PROGRESS
- information_schema.DBA_OUTLINES
- mysql.help_topic
- oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY
- oceanbase.CDB_OB_BACKUP_ARCHIVELOG_SUMMARY
- oceanbase.CDB_OB_RESTORE_PROGRESS
- oceanbase.CDB_OB_BACKUP_SET_OBSOLETE
- oceanbase.CDB_OB_BACKUP_JOB_DETAILS
- information_schema.USER_PRIVILEGES
- information_schema.COLLATIONS
- oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK
- information_schema.KEY_COLUMN_USAGE
- information_schema.SESSION_STATUS
- mysql.help_category
- 性能视图
- gv$memstore_info
- v$plan_cache_plan_stat
- gv$session_longops
- gv$outline
- gv$plan_cache_stat
- gv$sql_audit
- v$ob_cluster_stats
- gv$sysstat
- v$lock_wait_stat
- v$server_schema_info
- v$memstore_info
- v$sql_plan_monitor
- gv$tenant_px_worker_stat
- v$sysstat
- gv$sesstat
- gv$session_event
- gv$server_schema_info
- v$ob_timestamp_service
- v$session_longops
- v$tenant_px_worker_stat
- v$sql_monitor_statname
- v$partition_audit
- v$ob_sql_workarea_memory_info
- gv$tenant_memstore_allocator_info
- v$ob_standby_status
- gv$memstore
- v$sesstat
- v$encrypted_tables
- gv$minor_merge_info
- gv$sql_workarea
- gv$ob_trans_table_status
- v$lock
- v$ps_stat
- gv$obrpc_incoming
- v$sql
- v$ob_cluster_event_history
- gv$lock
- gv$latch
- gv$tenant
- v$sql_workarea_active
- gv$obrpc_outgoing
- v$partition
- gv$concurrent_limit_sql
- gv$server_memstore
- v$tenant_memstore_allocator_info
- v$plan_cache_stat
- v$statname
- gv$ps_stat
- gv$table
- v$ps_item_info
- v$encrypted_tablespaces
- gv$merge_info
- v$merge_info
- v$memory
- gv$plan_cache_plan_explain
- gv$lock_wait_stat
- gv$sql_plan_statistics
- gv$unit_load_balance_event_history
- v$sql_plan_statistics
- gv$ps_item_info
- gv$memory
- v$ob_trans_table_status
- v$obrpc_incoming
- v$system_event
- v$sstable
- gv$sql_plan_monitor
- gv$unit
- v$plan_cache_plan_explain
- v$sql_audit
- gv$system_event
- gv$database
- v$sql_workarea_histogram
- v$event_name
- gv$partition
- v$session_wait_history
- gv$sql
- v$ob_cluster_failover_info
- gv$sql_workarea_histogram
- v$session_event
- v$session_wait
- gv$partition_audit
- gv$ob_sql_workarea_memory_info
- gv$sstable
- v$latch
- gv$session_wait_history
- gv$plan_cache_plan_stat
- gv$session_wait
- v$memstore
- v$restore_point
- v$unit
- v$sql_workarea
- v$obrpc_outgoing
- v$ob_cluster
- 概述
- 字典视图
- 系统配置项
- multiblock_read_size
- rootservice_async_task_queue_size
- open_cursors
- zone
- rootservice_memory_limit
- sys_bkgd_migration_change_member_list_timeout
- builtin_db_data_verify_cycle
- unit_balance_resource_weight
- clog_persistence_compress_func
- large_query_worker_percentage
- sql_audit_queue_size
- rootservice_async_task_thread_count
- multiblock_read_gap_size
- index_cache_priority
- merge_thread_count
- enable_tcp_keepalive
- migrate_concurrency
- plsql_v2_compatibility
- index_info_block_cache_priority
- tablet_size
- election_cpu_quota
- balancer_timeout_check_interval
- enable_monotonic_weak_read
- global_write_halt_residual_memory
- cpu_quota_concurrency
- server_balance_cpu_mem_tolerance_percent
- datafile_disk_percentage
- default_row_format
- enable_merge_by_turn
- global_index_build_single_replica_timeout
- server_permanent_offline_time
- tableapi_transport_compress_func
- ob_enable_batched_multi_statement
- enable_unit_balance_resource_weight
- enable_pg
- partition_table_scan_batch_count
- server_data_copy_in_concurrency
- virtual_table_location_cache_expire_time
- enable_async_syslog
- max_kept_major_version_number
- clog_sync_time_warn_threshold
- cpu_count
- obconfig_url
- micro_block_merge_verify_level
- zone_merge_order
- backup_concurrency
- workarea_size_policy
- rpc_port
- bf_cache_miss_count_threshold
- cpu_reserved
- min_observer_version
- freeze_trigger_percentage
- ignore_replay_checksum_error
- enable_sql_audit
- enable_auto_leader_switch
- plan_cache_evict_interval
- log_archive_concurrency
- enable_sys_unit_standalone
- config_additional_dir
- enable_rereplication
- user_iort_up_percentage
- enable_early_lock_release
- location_cache_refresh_sql_timeout
- data_dir
- index_clog_cache_priority
- debug_sync_timeout
- backup_backupset_batch_count
- minor_merge_concurrency
- backup_log_archive_checkpoint_interval
- auto_delete_expired_backup
- server_data_copy_out_concurrency
- system_cpu_quota
- merger_switch_leader_duration_time
- sys_bkgd_io_low_percentage
- rpc_timeout
- tde_method
- enable_election_group
- minor_deferred_gc_time
- clog_disk_usage_limit_percentage
- memory_limit
- data_disk_usage_limit_percentage
- clog_max_unconfirmed_log_count
- fast_recovery_concurrency
- max_string_print_length
- log_restore_concurrency
- zone_merge_timeout
- enable_global_freeze_trigger
- datafile_size
- memstore_limit_percentage
- plsql_optimize_level
- sys_cpu_limit_trigger
- server_cpu_quota_max
- plan_cache_low_watermark
- rootservice_list
- auto_leader_switch_interval
- sys_bkgd_io_timeout
- cluster
- memory_chunk_cache_size
- server_balance_critical_disk_waterlevel
- backup_backup_archive_log_batch_count
- ob_ssl_invited_common_names
- max_syslog_file_count
- default_progressive_merge_num
- enable_log_archive
- location_cache_expire_time
- px_task_size
- memory_reserved
- server_cpu_quota_min
- syslog_io_bandwidth_limit
- tcp_keepidle
- force_refresh_location_cache_threshold
- 系统配置项概述
- merger_check_interval
- large_query_threshold
- backup_dest
- balancer_idle_time
- enable_rich_error_msg
- merger_warm_up_duration_time
- recyclebin_object_expire_time
- backup_net_limit
- use_large_pages
- tcp_keepcnt
- high_priority_net_thread_count
- backup_recovery_window
- internal_sql_execute_timeout
- enable_syslog_wf
- balancer_task_timeout
- writing_throttling_trigger_percentage
- system_memory
- leak_mod_to_check
- log_archive_batch_buffer_limit
- sql_work_area
- trace_log_sampling_interval
- plsql_code_type
- zone_merge_concurrency
- data_copy_concurrency
- trace_log_slow_query_watermark
- tenant_groups
- row_purge_thread_count
- weak_read_version_refresh_interval
- ob_event_history_recycle_interval
- minor_freeze_times
- plsql_debug
- clog_disk_utilization_threshold
- location_cache_refresh_min_interval
- location_cache_cpu_quota
- system_trace_level
- flush_log_at_trx_commit
- user_block_cache_priority
- ignore_replay_checksum_error
- force_refresh_location_cache_interval
- default_compress_func
- enable_manual_merge
- minor_warm_up_duration_time
- enable_separate_sys_clog
- backup_backupset_retry_interval
- workers_per_cpu_quota
- get_leader_candidate_rpc_timeout
- tenant_task_queue_size
- location_cache_refresh_rpc_timeout
- dead_socket_detection_timeout
- net_thread_count
- tcp_keepintvl
- enable_rootservice_standalone
- plsql_warnings
- plsql_ccflags
- trx_force_kill_threshold
- resource_hard_limit
- server_balance_disk_tolerance_percent
- max_px_worker_count
- balance_blacklist_failure_threshold
- major_compact_trigger
- mysql_port
- audit_sys_operations
- stack_size
- rebuild_replica_data_lag_threshold
- external_kms_info
- log_archive_checkpoint_interval
- trx_try_wait_lock_timeout
- ssl_client_authentication
- enable_smooth_leader_switch
- enable_ddl
- autoinc_cache_refresh_interval
- dtl_buffer_size
- balancer_emergency_percentage
- writing_throttling_maximum_duration
- sys_bkgd_io_high_percentage
- ilog_index_expire_time
- enable_rebalance
- merge_stat_sampling_ratio
- merger_completion_percentage
- syslog_level
- switchover_process_thread_count
- tenant_cpu_variation_per_server
- sys_bkgd_migration_retry_num
- ignore_replica_checksum_error
- default_compress
- enable_perf_event
- lease_time
- balance_blacklist_retry_interval
- replica_safe_remove_time
- px_workers_per_cpu_quota
- enable_record_trace_id
- location_refresh_thread_count
- plan_cache_high_watermark
- memory_limit_percentage
- balancer_log_interval
- rootservice_ready_check_interval
- enable_syslog_recycle
- devname
- disk_io_thread_count
- global_major_freeze_residual_memory
- election_blacklist_interval
- location_fetch_concurrency
- sys_bkgd_net_percentage
- audit_trail
- user_tab_col_stat_cache_priority
- enable_record_trace_log
- location_cache_priority
- clog_cache_priority
- backup_backup_archivelog_retry_interval
- clog_transport_compress_all
- enable_rebuild_on_purpose
- major_freeze_duty_time
- minor_compact_trigger
- resource_soft_limit
- restore_concurrency
- token_reserved_percentage
- balancer_tolerance_percentage
- clog_transport_compress_func
- enable_one_phase_commit
- cache_wash_threshold
- all_cluster_list
- schema_history_expire_time
- bf_cache_priority
- backup_backup_dest
- migration_disable_time
- partition_table_check_interval
- server_check_interval
- trx_2pc_retry_interval
- enable_sql_operator_dump
- wait_leader_batch_count
- cluster_id
- backup_region
- sql_audit_memory_limit
- fuse_row_cache_priority
- enable_upgrade_mode
- max_stale_time_for_weak_consistency
- enable_clog_persistence_compress
- ssl_external_kms_info
- server_temporary_offline_time
- enable_major_freeze
- user_row_cache_priority
- row_compaction_update_limit
- 预留关键字
- 系统变量
- ob_last_schema_version
- sql_mode
- max_sp_recursion_depth
- parallel_max_servers
- ob_enable_transformation
- ob_enable_index_direct_select
- validate_password_number_count
- character_set_filesystem
- optimizer_use_sql_plan_baselines
- auto_increment_offset
- timestamp
- ob_enable_jit
- query_cache_type
- ob_trace_info
- ob_global_debug_sync
- tx_read_only
- character_set_database
- autocommit
- ob_proxy_global_variables_version
- ob_enable_truncate_flashback
- ob_proxy_partition_hit
- ob_reserved_meta_memory_percentage
- error_on_overlap_time
- net_read_timeout
- ob_compatibility_mode
- sql_quote_show_create
- ob_trx_idle_timeout
- character_set_server
- ob_timestamp_service
- tracefile_identifier
- ob_enable_sql_audit
- connect_timeout
- sql_auto_is_null
- system_time_zone
- init_connect
- ob_plan_cache_percentage
- ob_proxy_set_trx_executed
- license
- ob_temp_tablespace_size_percentage
- group_concat_max_len
- auto_increment_increment
- ob_enable_transmission_checksum
- time_zone
- sql_warnings
- read_only
- auto_increment_cache_size
- validate_password_length
- plugin_dir
- transaction_read_only
- ob_enable_hash_group_by
- sql_throttle_current_priority
- sql_throttle_priority
- performance_schema
- identity
- ob_enable_blk_nestedloop_join
- sql_safe_updates
- ob_create_table_strict_mode
- collation_server
- validate_password_policy
- ob_enable_trace_log
- ob_sql_work_area_percentage
- net_write_timeout
- parallel_servers_target
- transaction_isolation
- character_set_system
- collation_connection
- ob_pl_block_timeout
- last_insert_id
- character_set_client
- undo_retention
- ob_plan_cache_evict_high_percentage
- ob_check_sys_variable
- ob_log_level
- version
- recyclebin
- datadir
- ob_enable_plan_cache
- ob_bnl_join_cache_size
- is_result_accurate
- max_user_connections
- lower_case_table_names
- ob_query_timeout
- div_precision_increment
- validate_password_check_user_name
- ob_sql_audit_percentage
- ob_trx_lock_timeout
- foreign_key_checks
- explicit_defaults_for_timestamp
- ob_capability_flag
- ob_plan_cache_evict_low_percentage
- sql_throttle_network
- ob_early_lock_release
- secure_file_priv
- collation_database
- validate_password_mixed_case_count
- optimizer_capture_sql_plan_baselines
- ob_tcp_invited_nodes
- ob_enable_aggregation_pushdown
- binlog_row_image
- interactive_timeout
- query_cache_size
- validate_password_special_char_count
- wait_timeout
- character_set_connection
- ob_org_cluster_id
- ob_stmt_parallel_degree
- block_encryption_mode
- ob_read_consistency
- ob_default_replica_num
- sql_select_limit
- net_buffer_length
- ob_trx_timeout
- 系统变量概述
- tx_isolation
- version_comment
- max_allowed_packet
- sql_throttle_rt
- ob_max_parallel_degree
- default_password_lifetime
- debug_sync
- ob_route_policy
- resource_manager_plan
- character_set_results
- 系统视图
- SQL 参考（Oracle 模式）
- 函数
- 聚合函数
- 函数概述
- 单行函数
- 空值相关函数
- 返回数字的字符串函数
- 通用比较函数
- 时间日期函数
- CURRENT_TIMESTAMP
- ADD_MONTHS
- TO_DSINTERVAL
- TRUNC (date)
- SYSTIMESTAMP
- SYSDATE
- EXTRACT（datetime）
- CURRENT_DATE
- LAST_DAY
- ROUND (date)
- TO_TIMESTAMP
- NEXT_DAY
- TO_CHAR (datetime)
- FROM_TZ
- LOCALTIMESTAMP
- SYS_EXTRACT_UTC
- SESSIONTIMEZONE
- TZ_OFFSET
- NUMTOYMINTERVAL
- TO_YMINTERVAL
- DBTIMEZONE
- MONTHS_BETWEEN
- NUMTODSINTERVAL
- TO_TIMESTAMP_TZ
- 返回字符串的字符串函数
- 转换函数
- 数字函数
- 编码解码函数
- 分析函数
- 条件
- 基本元素
- 运算符
- SQL 概述
- 查询和子查询
- SQL语句
- DML
- DCL
- DDL
- DROP TABLEGROUP
- ALTER SEQUENCE
- CREATE RESTORE POINT
- DROP SYNONYM
- CREATE OUTLINE
- ALTER USER
- DROP RESTORE POINT
- CREATE KEYSTORE
- CREATE SYNONYM
- RENAME
- ALTER OUTLINE
- DROP USER
- CREATE SEQUENCE
- TRUNCATE TABLE
- DROP INDEX
- DROP OUTLINE
- CREATE VIEW
- CREATE INDEX
- DROP TABLE
- CREATE USER
- ALTER KEYSTORE
- CREATE TABLE
- CREATE TABLESPACE
- DROP TABLESPACE
- ALTER SESSION
- DROP VIEW
- ALTER TABLE
- ALTER TABLEGROUP
- DROP SEQUENCE
- CREATE TABLEGROUP
- 伪列
- 表达式
- 函数
- 升级指南
- 快速入门
- 参考指南（Oracle 模式）
- 系统配置项
- enable_rereplication
- user_tab_col_stat_cache_priority
- lease_time
- ob_event_history_recycle_interval
- memory_reserved
- tcp_keepintvl
- rebuild_replica_data_lag_threshold
- sys_bkgd_io_low_percentage
- location_refresh_thread_count
- rootservice_async_task_queue_size
- plsql_ccflags
- election_cpu_quota
- auto_leader_switch_interval
- workarea_size_policy
- location_cache_refresh_sql_timeout
- backup_backup_dest
- system_cpu_quota
- server_data_copy_out_concurrency
- row_purge_thread_count
- server_permanent_offline_time
- max_string_print_length
- server_temporary_offline_time
- balancer_log_interval
- external_kms_info
- zone_merge_timeout
- sql_audit_queue_size
- cache_wash_threshold
- enable_upgrade_mode
- enable_one_phase_commit
- backup_dest
- enable_monotonic_weak_read
- high_priority_net_thread_count
- global_index_build_single_replica_timeout
- enable_ddl
- backup_backupset_batch_count
- server_balance_cpu_mem_tolerance_percent
- balancer_emergency_percentage
- debug_sync_timeout
- trx_try_wait_lock_timeout
- sys_bkgd_io_timeout
- writing_throttling_trigger_percentage
- log_archive_concurrency
- enable_merge_by_turn
- balancer_idle_time
- memory_limit_percentage
- rootservice_async_task_thread_count
- data_disk_usage_limit_percentage
- auto_delete_expired_backup
- server_cpu_quota_max
- trace_log_slow_query_watermark
- get_leader_candidate_rpc_timeout
- token_reserved_percentage
- rootservice_list
- global_write_halt_residual_memory
- ignore_replica_checksum_error
- minor_compact_trigger
- enable_clog_persistence_compress
- enable_sys_unit_standalone
- force_refresh_location_cache_threshold
- server_data_copy_in_concurrency
- minor_freeze_times
- large_query_worker_percentage
- all_cluster_list
- syslog_io_bandwidth_limit
- clog_disk_usage_limit_percentage
- merger_check_interval
- large_query_threshold
- merge_stat_sampling_ratio
- clog_disk_utilization_threshold
- tenant_groups
- max_px_worker_count
- index_info_block_cache_priority
- backup_net_limit
- partition_table_scan_batch_count
- location_cache_refresh_min_interval
- enable_syslog_recycle
- enable_early_lock_release
- recyclebin_object_expire_time
- bf_cache_priority
- clog_sync_time_warn_threshold
- sys_bkgd_net_percentage
- cluster
- user_iort_up_percentage
- user_block_cache_priority
- bf_cache_miss_count_threshold
- clog_persistence_compress_func
- resource_hard_limit
- datafile_size
- schema_history_expire_time
- clog_transport_compress_func
- ob_enable_batched_multi_statement
- trx_force_kill_threshold
- mysql_port
- obconfig_url
- location_cache_priority
- workers_per_cpu_quota
- builtin_db_data_verify_cycle
- plsql_warnings
- minor_warm_up_duration_time
- rpc_timeout
- sys_bkgd_io_high_percentage
- enable_sql_operator_dump
- trace_log_sampling_interval
- plan_cache_high_watermark
- net_thread_count
- plsql_debug
- flush_log_at_trx_commit
- default_progressive_merge_num
- location_cache_refresh_rpc_timeout
- sql_work_area
- multiblock_read_size
- sys_bkgd_migration_change_member_list_timeout
- major_freeze_duty_time
- system_memory
- max_syslog_file_count
- backup_backup_archivelog_retry_interval
- enable_rebuild_on_purpose
- plan_cache_evict_interval
- data_dir
- replica_safe_remove_time
- enable_smooth_leader_switch
- enable_record_trace_id
- rootservice_memory_limit
- global_major_freeze_residual_memory
- max_kept_major_version_number
- rootservice_ready_check_interval
- zone
- unit_balance_resource_weight
- memstore_limit_percentage
- minor_deferred_gc_time
- index_cache_priority
- log_archive_batch_buffer_limit
- plsql_v2_compatibility
- enable_separate_sys_clog
- system_trace_level
- enable_rich_error_msg
- tableapi_transport_compress_func
- px_task_size
- clog_max_unconfirmed_log_count
- clog_cache_priority
- ssl_client_authentication
- enable_async_syslog
- memory_limit
- location_cache_cpu_quota
- 系统配置项概述
- weak_read_version_refresh_interval
- dtl_buffer_size
- default_row_format
- enable_log_archive
- location_fetch_concurrency
- balancer_task_timeout
- writing_throttling_maximum_duration
- major_compact_trigger
- enable_auto_leader_switch
- clog_transport_compress_all
- ob_ssl_invited_common_names
- tcp_keepcnt
- balancer_tolerance_percentage
- enable_sql_audit
- audit_sys_operations
- election_blacklist_interval
- ignore_replay_checksum_error
- default_compress_func
- multiblock_read_gap_size
- row_compaction_update_limit
- force_refresh_location_cache_interval
- enable_perf_event
- memory_chunk_cache_size
- enable_tcp_keepalive
- plsql_optimize_level
- balancer_timeout_check_interval
- backup_log_archive_checkpoint_interval
- enable_unit_balance_resource_weight
- partition_table_check_interval
- zone_merge_concurrency
- disk_io_thread_count
- px_workers_per_cpu_quota
- fuse_row_cache_priority
- restore_concurrency
- zone_merge_order
- merge_thread_count
- ssl_external_kms_info
- enable_rootservice_standalone
- cluster_id
- ignore_replay_checksum_error
- cpu_quota_concurrency
- tenant_task_queue_size
- balance_blacklist_failure_threshold
- trx_2pc_retry_interval
- switchover_process_thread_count
- enable_syslog_wf
- enable_global_freeze_trigger
- resource_soft_limit
- internal_sql_execute_timeout
- merger_completion_percentage
- minor_merge_concurrency
- cpu_count
- server_balance_critical_disk_waterlevel
- enable_rebalance
- server_balance_disk_tolerance_percent
- tcp_keepidle
- balance_blacklist_retry_interval
- dead_socket_detection_timeout
- min_observer_version
- use_large_pages
- stack_size
- data_copy_concurrency
- enable_pg
- backup_backup_archive_log_batch_count
- tablet_size
- server_check_interval
- leak_mod_to_check
- devname
- enable_election_group
- syslog_level
- index_clog_cache_priority
- fast_recovery_concurrency
- server_cpu_quota_min
- rpc_port
- ilog_index_expire_time
- enable_record_trace_log
- log_restore_concurrency
- migration_disable_time
- micro_block_merge_verify_level
- wait_leader_batch_count
- config_additional_dir
- user_row_cache_priority
- sql_audit_memory_limit
- open_cursors
- autoinc_cache_refresh_interval
- backup_recovery_window
- enable_manual_merge
- backup_region
- enable_major_freeze
- audit_trail
- virtual_table_location_cache_expire_time
- sys_bkgd_migration_retry_num
- log_archive_checkpoint_interval
- sys_cpu_limit_trigger
- cpu_reserved
- plsql_code_type
- datafile_disk_percentage
- migrate_concurrency
- max_stale_time_for_weak_consistency
- freeze_trigger_percentage
- location_cache_expire_time
- tde_method
- plan_cache_low_watermark
- backup_backupset_retry_interval
- merger_warm_up_duration_time
- default_compress
- tenant_cpu_variation_per_server
- backup_concurrency
- merger_switch_leader_duration_time
- 预留关键字
- 系统变量
- ob_enable_transformation
- nls_calendar
- tx_read_only
- ob_enable_aggregation_pushdown
- ob_enable_sql_audit
- license
- parallel_max_servers
- character_set_results
- performance_schema
- read_only
- auto_increment_offset
- nls_nchar_conv_excp
- ob_temp_tablespace_size_percentage
- plugin_dir
- error_on_overlap_time
- ob_enable_index_direct_select
- ob_pl_block_timeout
- sql_throttle_network
- version_comment
- nls_length_semantics
- ob_enable_hash_group_by
- nls_territory
- query_cache_size
- ob_enable_truncate_flashback
- ob_max_parallel_degree
- lower_case_table_names
- ob_trx_timeout
- character_set_connection
- secure_file_priv
- 系统变量概述
- ob_last_schema_version
- net_write_timeout
- ob_read_consistency
- ob_sql_audit_percentage
- auto_increment_cache_size
- ob_plan_cache_evict_high_percentage
- nls_sort
- ob_enable_plan_cache
- ob_org_cluster_id
- sql_select_limit
- sql_throttle_rt
- ob_default_replica_num
- ob_plan_cache_percentage
- sql_auto_is_null
- ob_enable_jit
- net_read_timeout
- last_insert_id
- ob_trx_idle_timeout
- auto_increment_increment
- resource_manager_plan
- ob_sql_work_area_percentage
- div_precision_increment
- parallel_servers_target
- ob_proxy_global_variables_version
- nls_nchar_characterset
- sql_quote_show_create
- nls_characterset
- version
- datadir
- sql_warnings
- ob_stmt_parallel_degree
- query_cache_type
- ob_reserved_meta_memory_percentage
- time_zone
- ob_early_lock_release
- ob_global_debug_sync
- transaction_isolation
- ob_route_policy
- ob_proxy_set_trx_executed
- identity
- ob_capability_flag
- nls_dual_currency
- nls_comp
- ob_compatibility_mode
- autocommit
- wait_timeout
- ob_proxy_partition_hit
- net_buffer_length
- nls_iso_currency
- tx_isolation
- ob_plan_cache_evict_low_percentage
- ob_enable_trace_log
- nls_date_language
- ob_timestamp_service
- character_set_client
- nls_timestamp_format
- ob_enable_blk_nestedloop_join
- ob_trace_info
- max_sp_recursion_depth
- sql_throttle_priority
- ob_log_level
- sql_throttle_current_priority
- max_allowed_packet
- nls_language
- max_user_connections
- binlog_row_image
- debug_sync
- collation_connection
- connect_timeout
- ob_tcp_invited_nodes
- nls_numeric_characters
- optimizer_use_sql_plan_baselines
- nls_timestamp_tz_format
- foreign_key_checks
- undo_retention
- transaction_read_only
- system_time_zone
- tracefile_identifier
- nls_date_format
- ob_trx_lock_timeout
- timestamp
- ob_enable_transmission_checksum
- group_concat_max_len
- interactive_timeout
- ob_create_table_strict_mode
- recyclebin
- optimizer_capture_sql_plan_baselines
- is_result_accurate
- nls_currency
- character_set_filesystem
- character_set_system
- sql_mode
- ob_query_timeout
- init_connect
- ob_bnl_join_cache_size
- 系统视图
- 字典视图
- DBA_IND_COLUMNS
- USER_TAB_PARTITIONS
- USER_TABLES
- DBA_ROLES
- DBA_AUDIT_STATEMENT
- USER_COL_COMMENTS
- DBA_TABLES
- DBA_TAB_PARTITIONS
- DBA_AUDIT_TRAIL
- DBA_PROCEDURES
- ALL_VIEWS
- USER_PART_TABLES
- DBA_CONS_COLUMNS
- DBA_TAB_COLUMNS
- USER_TRIGGERS
- ALL_COL_PRIVS
- DBA_TAB_SUBPARTITIONS
- DBA_RSRC_PLANS
- USER_TYPES
- DBA_ERRORS
- USER_PART_INDEXES
- ALL_COLL_TYPES
- ALL_TAB_PRIVS
- ALL_SCHEDULER_JOB_ARGS
- ALL_SYNONYMS
- DICT
- USER_ARGUMENTS
- USER_OBJECTS
- USER_VIEWS
- DBA_SUBPARTITION_TEMPLATES
- DICTIONARY
- ALL_IND_PARTITIONS
- USER_PART_KEY_COLUMNS
- DBA_RECYCLEBIN
- DBA_SOURCE
- ALL_PROCEDURES
- DBA_OBJ_AUDIT_OPTS
- NLS_SESSION_PARAMETERS
- DBA_ROLE_PRIVS
- DBA_SYNONYMS
- DBA_TRIGGERS
- DBA_TABLESPACES
- USER_CONSTRAINTS
- DBA_SUBPART_KEY_COLUMNS
- USER_ERRORS
- USER_RECYCLEBIN
- USER_INDEXES
- USER_IND_EXPRESSIONS
- DBA_RSRC_CONSUMER_GROUPS
- ROLE_ROLE_PRIVS
- DBA_RSRC_GROUP_MAPPINGS
- ALL_SEQUENCES
- USER_AUDIT_OBJECT
- DBA_RSRC_PLAN_DIRECTIVES
- DBA_SEQUENCES
- DBA_PART_TABLES
- DBA_TYPE_ATTRS
- ALL_COL_COMMENTS
- USER_ALL_TABLES
- DBA_VIEWS
- DBA_ALL_TABLES
- DBA_AUDIT_EXISTS
- ALL_TYPE_ATTRS
- ALL_SUBPARTITION_TEMPLATES
- ALL_SUBPART_KEY_COLUMNS
- DBA_AUDIT_SESSION
- ALL_INDEXES
- DBA_ARGUMENTS
- NLS_INSTANCE_PARAMETERS
- ALL_TABLES
- USER_PROFILES
- USER_SUBPART_KEY_COLUMNS
- ALL_TYPE_METHODS
- ALL_IND_SUBPARTITIONS
- DBA_IND_PARTITIONS
- DBA_IND_EXPRESSIONS
- USER_TYPE_METHODS
- USER_SUBPARTITION_TEMPLATES
- DBA_USERS
- ALL_SOURCE
- USER_SEGMENTS
- DBA_SEGMENTS
- USER_AUDIT_STATEMENT
- DBA_SCHEDULER_JOB_ARGS
- DBA_PROFILES
- USER_SYNONYMS
- ALL_TAB_SUBPARTITIONS
- ALL_IND_EXPRESSIONS
- USER_TAB_SUBPARTITIONS
- ALL_TAB_PARTITIONS
- STMT_AUDIT_OPTION_MAP
- DBA_AUDIT_OBJECT
- ALL_METHOD_PARAMS
- ROLE_SYS_PRIVS
- DBA_METHOD_PARAMS
- DBA_DEPENDENCIES
- USER_IND_PARTITIONS
- USER_AUDIT_TRAIL
- ALL_TRIGGERS
- AUDIT_ACTIONS
- ALL_PROFILES
- NLS_DATABASE_PARAMETERS
- ALL_ALL_TABLES
- DBA_COLL_TYPES
- ALL_TAB_COLUMNS
- USER_COL_PRIVS
- USER_SYS_PRIVS
- ROLE_TAB_PRIVS
- DBA_STMT_AUDIT_OPTS
- ALL_SCHEDULER_PROGRAM_ARGS
- USER_TAB_COLUMNS
- DBA_PART_INDEXES
- USER_DEPENDENCIES
- DBA_TYPE_METHODS
- DBA_CONSTRAINTS
- USER_IND_COLUMNS
- DBA_TAB_PRIVS
- ALL_CONSTRAINTS
- ALL_ARGUMENTS
- DBA_SYS_PRIVS
- ALL_PART_TABLES
- USER_CONS_COLUMNS
- USER_PROCEDURES
- USER_TAB_COLS
- ALL_USERS
- DBA_TYPES
- ALL_DEPENDENCIES
- ALL_IND_COLUMNS
- ALL_PART_INDEXES
- USER_TAB_COMMENTS
- DBA_PART_KEY_COLUMNS
- ALL_PART_KEY_COLUMNS
- USER_SEQUENCES
- DBA_COL_COMMENTS
- DBA_SCHEDULER_PROGRAM_ARGS
- ALL_OBJECTS
- USER_COLL_TYPES
- ALL_TAB_COMMENTS
- DBA_IND_SUBPARTITIONS
- ALL_DEF_AUDIT_OPTS
- DBA_TAB_COMMENTS
- USER_AUDIT_SESSION
- ALL_ERRORS
- DBA_INDEXES
- ALL_TAB_COLS
- USER_SOURCE
- DBA_COL_PRIVS
- USER_TABLESPACES
- USER_TYPE_ATTRS
- DBA_OBJECTS
- USER_IND_SUBPARTITIONS
- ALL_CONS_COLUMNS
- DBA_TAB_COLS
- ALL_TYPES
- USER_ROLE_PRIVS
- 性能视图
- GV$OPEN_CURSOR
- V$SQL_AUDIT
- V$MEMORY
- GV$SYSTEM_EVENT
- GV$PLAN_CACHE_PLAN_STAT
- GV$SESSTAT
- GV$SESSION_WAIT_HISTORY
- V$PS_STAT
- GV$SSTABLE
- GV$SQL_WORKAREA_HISTOGRAM
- V$SYSTEM_EVENT
- V$PLAN_CACHE_PLAN_STAT
- GV$MEMSTORE
- V$ENCRYPTED_TABLESPACES
- V$NLS_PARAMETERS
- V$SESSION_WAIT_HISTORY
- V$SESSTAT
- V$OPEN_CURSOR
- GV$GLOBAL_TRANSACTION
- GV$SERVER_MEMSTORE
- V$LOCK
- V$MEMSTORE
- V$RESTORE_POINT
- GV$MEMSTORE_INFO
- GV$LOCK
- GV$OB_SQL_WORKAREA_MEMORY_INFO
- GV$OUTLINE
- V$PLAN_CACHE_PLAN_EXPLAIN
- V$GLOBAL_TRANSACTION
- GV$PS_ITEM_INFO
- GV$SYSSTAT
- V$SQL_WORKAREA
- V$SQL_WORKAREA_HISTOGRAM
- V$SYSSTAT
- V$PLAN_CACHE_STAT
- GV$SQL_WORKAREA
- V$ENCRYPTED_TABLES
- GV$SQL_WORKAREA_ACTIVE
- GV$INSTANCE
- V$INSTANCE
- V$SESSION_WAIT
- V$OB_SQL_WORKAREA_MEMORY_INFO
- GV$PLAN_CACHE_STAT
- V$RSRC_PLAN
- GV$MEMORY
- GV$SESSION_WAIT
- V$SQL_WORKAREA_ACTIVE
- GV$PLAN_CACHE_PLAN_EXPLAIN
- V$TIMEZONE_NAMES
- V$MEMSTORE_INFO
- V$VERSION
- V$PS_ITEM_INFO
- GV$CONCURRENT_LIMIT_SQL
- GV$SQL_AUDIT
- V$SQL_MONITOR_STATNAME
- V$SSTABLE
- GV$PS_STAT
- 字典视图
- 系统配置项
- PL 参考
- 集合与记录
- PL 系统包
- 动态 SQL
- 数据类型
- PL 标签安全包
- 流程控制
- 异常处理
- 游标
- 程序包
- 存储过程与函数
- PL 语言基础
- 什么是 PL
- 触发器
- 存储过程的 DDL 操作
- 附录
- 了解 OceanBase 数据库
- 部署 OceanBase 数据库
- OceanBase 数据库概览
- SQL 参考（MySQL 模式）
- 函数
- 查询和子查询
- 运算符
- SQL语句
- FLASHBACK TENANT
- ALTER TABLEGROUP
- CREATE TENANT
- DROP SYNONYM
- REVOKE
- CREATE RESTORE POINT
- TRANSACTION
- UPDATE
- RENAME TABLE
- DROP DATABASE
- SHOW RECYCLEBIN
- CREATE SYNONYM
- SELECT
- ALTER RESOURCE UNIT
- KILL
- INSERT
- PURGE RECYCLEBIN
- PURGE DATABASE
- ALTER SYSTEM
- SHOW GRANTS
- SESSION
- DROP INDEX
- CREATE RESOURCE POOL
- DROP TABLEGROUP
- CREATE TABLE
- EXPLAIN
- SET PASSWORD
- FLASHBACK TABLE
- DROP RESTORE POINT
- CREATE RESOURCE UNIT
- CREATE OUTLINE
- PURGE TABLE
- GRANT
- DROP TENANT
- CREATE USER
- ALTER TABLE
- ALTER TENANT
- DROP OUTLINE
- DROP RESOURCE UNIT
- SAVEPOINT
- CREATE INDEX
- CREATE DATABASE
- CREATE TABLEGROUP
- DROP USER
- PURGE INDEX
- ALTER USER
- DROP VIEW
- CREATE VIEW
- ALTER RESOURCE POOL
- PURGE TENANT
- ALTER DATABASE
- DROP TABLE
- FLASHBACK DATABASE
- RENAME USER
- DROP RESOURCE POOL
- TRUNCATE TABLE
- 通用语法
- REPLACE
- SCHEMA
- DELETE
- ALTER OUTLINE
- 基本元素
- 常见问题
暂无相关搜索结果！
本文档使用 BookStack 构建
