---
title: gv$plan_cache_plan_stat 中的 PARAM_INFOS 的含义-OceanBase数据库使用指南
description: 了解OceanBase数据库在实际应用中关于 gv$plan_cache_plan_stat 中的 PARAM_INFOS 的含义相关的常见问题和使用技巧，帮助您快速解决 gv$plan_cache_plan_stat 中的 PARAM_INFOS 的含义的难题。
---
切换语言

- 简体中文
- English

划线反馈

# gv$plan_cache_plan_stat 中的 PARAM_INFOS 的含义

更新时间：2023-12-29 07:21

适用版本： V2.2.x、V3.1.x、V3.2.x 内容类型：TechNote  

本文介绍 OceanBase 数据库中 gv$plan_cache_plan_stat 视图中的列 PARAM_INFOS 的含义。

gv$plan_cache_plan_stat 视图中 PARAM_INFOS 记录执行计划被参数化后，所有被参数化参数的数据类型。

示例:

```shell
obclient> select * from __all_virtual_plan_stat  where sql_id='C687888792EFB790B835F20833198FFF'\G;

```

输出内容如下:

```shell
*************************** 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 版本。

Previous

[如何通过脚本在字典视图中查询元数据](https://www.oceanbase.com/knowledge-base/oceanbase-database-20000001014)

Next

[OceanBase 数据库 V3.x 如何查询视图的列](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000340645) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线