alter system set default_table_store_format = ‘column’ ; schema下调整
SET global NLS_DATE_FORMAT=‘YYYY-MM-DD HH24:MI:SS’;
SET global NLS_TIMESTAMP_FORMAT=‘YYYY-MM-DD HH24:MI:SS.FF’;
SET global NLS_TIMESTAMP_TZ_FORMAT=‘YYYY-MM-DD HH24:MI:SS.FF TZR TZD’;
set global ob_query_timeout=10800000000;
set global ob_trx_timeout=10000000000;
set global ob_sql_work_area_percentage=80;
alter system set ob_enable_batched_multi_statement=‘true’;
alter system set default_table_store_format = ‘column’ ;
alter system set _io_read_batch_size = ‘128k’;
alter system set _io_read_redundant_limit_percentage = 50;
– parallel_servers_target = max_cpu * server_num * 8
set global parallel_servers_target=10000;
set global collation_connection = utf8mb4_bin;
set global collation_database = utf8mb4_bin;
set global collation_server = utf8mb4_bin;
set global autocommit=1;
set global optimizer_use_sql_plan_baselines = true;
set global optimizer_capture_sql_plan_baselines = true;
alter system set ob_enable_batched_multi_statement=‘true’;