oceanbase

1
--disable_query_log
2
--disable_result_log
3
if ($TENANT == 'mysql') {
4
  let $use_spb_bk = query_get_value(select value from oceanbase.__tenant_virtual_session_variable where VARIABLE_NAME = 'optimizer_use_sql_plan_baselines',value, 1);
5
  let $cap_spb_bk = query_get_value(select value from oceanbase.__tenant_virtual_session_variable where VARIABLE_NAME = 'optimizer_capture_sql_plan_baselines',value, 1);
6
  set global optimizer_use_sql_plan_baselines = 'OFF';
7
  set global optimizer_capture_sql_plan_baselines = 'OFF';
8
  set session optimizer_use_sql_plan_baselines = 'OFF';
9
  set session optimizer_capture_sql_plan_baselines = 'OFF';
10
}
11
if ($TENANT == 'oracle') {
12
  let $use_spb_bk = query_get_value(select value from sys.TENANT_VIRTUAL_SESSION_VARIABLE where VARIABLE_NAME = 'optimizer_use_sql_plan_baselines',VALUE, 1);
13
  let $cap_spb_bk = query_get_value(select value from sys.TENANT_VIRTUAL_SESSION_VARIABLE where VARIABLE_NAME = 'optimizer_capture_sql_plan_baselines',VALUE, 1);
14
  set global optimizer_use_sql_plan_baselines = 'OFF';
15
  set global optimizer_capture_sql_plan_baselines = 'OFF';
16
  set session optimizer_use_sql_plan_baselines = 'OFF';
17
  set session optimizer_capture_sql_plan_baselines = 'OFF';
18
}
19
--enable_result_log
20
--enable_query_log
21