首批通过分布式安全可靠测评,为关键业务系统打造
gv$plan_cache_plan_stat 中的 PARAM_INFOS 的含义
更新时间:2023-12-29 07:21
本文介绍 OceanBase 数据库中 gv$plan_cache_plan_stat 视图中的列 PARAM_INFOS 的含义。
gv$plan_cache_plan_stat 视图中 PARAM_INFOS 记录执行计划被参数化后,所有被参数化参数的数据类型。
示例:
obclient> select * from __all_virtual_plan_stat where sql_id='C687888792EFB790B835F20833198FFF'\G;
输出内容如下:
*************************** 1. row ***************************
tenant_id: 1001
svr_ip: xx.xx.xx.xx
svr_port: 2882
plan_id: 2799550
sql_id: C687888792EFB790B835F20833198FFF
type: 1
is_bind_sensitive: 0
is_bind_aware: 0
statement: select coalesce(max(t.id), ?) as batch_id from BANANO_CORE.BATCH t where t.date_apply is not null and t.is_rollback = ?
query_sql: select coalesce(max(t.id), -1) as batch_id from BANANO_CORE.BATCH t where t.date_apply is not null and t.is_rollback = 0
special_params: null
param_infos: {1,0,0,-85,15},{1,0,0,-85,15}
sys_vars: 45,45,2151677954,2,4,1,0,0,32,3,1,0,1,1,0,10485760,1,1,0,1,BINARY,BINARY,AL32UTF8,AL16UTF16,BYTE,FALSE,1,100,64,200,0,13,NULL,1,1,1,1
plan_hash: 2014312352381708418
first_load_time: xxxx-xx-xx xx:xx:xx.xxxxx
schema_version: 1672231556980936
merged_version: 489
last_active_time: xxxx-xx-xx xx:xx:xx.xxxxx
avg_exe_usec: 338
slowest_exe_time: xxxx-xx-xx xx:xx:xx.xxxxx
slowest_exe_usec: 13126
slow_count: 0
hit_count: 131145
plan_size: 49216
executions: 131146
disk_reads: 0
direct_writes: 0
buffer_gets: -1633208874
application_wait_time: 0
concurrency_wait_time: 0
user_io_wait_time: 0
rows_processed: 0
elapsed_time: 44389484
cpu_time: 38879549
large_querys: 0
delayed_large_querys: 0
outline_version: 0
outline_id: -1
outline_data: /*+ BEGIN_OUTLINE_DATA FULL(@"SEL$2" "BANANO_CORE.T"@"SEL$2") END_OUTLINE_DATA*/
acs_sel_info:
table_scan: 1
db_id: 1100611139404827
evolution: 0
evo_executions: 0
evo_cpu_time: 0
timeout_count: 0
ps_stmt_id: -1
delayed_px_querys: 0
sessid: 0
temp_tables:
is_use_jit: 0
object_type: SQL_PLAN
enable_bf_cache: 1
bf_filter_cnt: 0
bf_access_cnt: 0
enable_row_cache: 1
row_cache_hit_cnt: 0
row_cache_miss_cnt: 0
enable_fuse_row_cache: 1
fuse_row_cache_hit_cnt: 0
fuse_row_cache_miss_cnt: 0
hints_info:
hints_all_worked: 1
pl_schema_id: 0
is_batched_multi_stmt: 0
1 row in set (0.04 sec)
适用版本
OceanBase 数据库 V2.x 和 V3.x 版本。