obclient(rd_read@woqu)[cprint]> SELECT -> CONCAT('select DBMS_XPLAN.DISPLAY_CURSOR(',CHAR(39),plan_id,CHAR(39),',',CHAR(39),'ADVANCED',CHAR(39),',',CHAR(39),svr_ip,CHAR(39),',',CHAR(39),svr_port,CHAR(39),',',CHAR(39),tenant_id,CHAR(39),')') sql_explain,query_sql -> FROM oceanbase.gv$ob_sql_audit WHERE query_sql LIKE '%test20250916%'; +-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | sql_explain | query_sql | +-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | select DBMS_XPLAN.DISPLAY_CURSOR('0','ADVANCED','172.17.172.84','2882','1002') | SELECT /test20250916/ b.set_name, c.station_name, ( SELECT nick_name FROM t_cust_reg f WHERE f.cust_id = a.cust_id LIMIT 1 ) nick_name, e.mobile, d.code_info, a.create_time, a.finish_time, a.state, a.err_msg, a.pay_time FROM t_cust_ops a, t_set b, t_station c, t_fault_code d, t_cust e WHERE a.set_id = b.set_id AND a.station_id = c.station_id AND a.fault_code = d.CODE AND a.cust_id = e.cust_id ORDER BY create_time DESC LIMIT 10,10 | | select DBMS_XPLAN.DISPLAY_CURSOR('511849','ADVANCED','172.17.172.84','2882','1002') | SELECT /*test20250916*/ b.set_name, c.station_name, ( SELECT nick_name FROM t_cust_reg f WHERE f.cust_id = a.cust_id LIMIT 1 ) nick_name, e.mobile, d.code_info, a.create_time, a.finish_time, a.state, a.err_msg, a.pay_time FROM t_cust_ops a, t_set b, t_station c, t_fault_code d, t_cust e WHERE a.set_id = b.set_id AND a.station_id = c.station_id AND a.fault_code = d.CODE AND a.cust_id = e.cust_id ORDER BY create_time DESC LIMIT 10,10 | | select DBMS_XPLAN.DISPLAY_CURSOR('0','ADVANCED','172.17.172.84','2882','1002') | select concat(‘select DBMS_XPLAN.DISPLAY_CURSOR(’,char(39),plan_id,char(39),’,’,char(39),‘ADVANCED’,char(39),’,’,char(39),svr_ip,char(39),’,’,char(39),svr_port,char(39),’,’,char(39),tenant_id,char(39),’)’) sql_explain, ,query_sql from oceanbase.gv$ob_sql_audit where query_sql like ‘%test20250916%’ | | select DBMS_XPLAN.DISPLAY_CURSOR('511948','ADVANCED','172.17.172.84','2882','1002') | select concat('select DBMS_XPLAN.DISPLAY_CURSOR(',char(39),plan_id,char(39),',',char(39),'ADVANCED',char(39),',',char(39),svr_ip,char(39),',',char(39),svr_port,char(39),',',char(39),tenant_id,char(39),')') sql_explain,query_sql from oceanbase.gv$ob_sql_audit where query_sql like '%test20250916%' LIMIT 0, 1000 | | select DBMS_XPLAN.DISPLAY_CURSOR('0','ADVANCED','172.17.172.84','2882','1002') | INSERT INTO PLAN_TABLE VALUES( '', CASE WHEN (SELECT MAX(PLAN_ID) FROM PLAN_TABLE) IS NULL THEN 0 ELSE (SELECT MAX(PLAN_ID) FROM PLAN_TABLE) END + 1, '2025-09-16 19:00:59.761', ' stmt_id:0, stmt_type:T_EXPLAIN stmt_id:1, SEL$1 stmt_id:2, SEL$2 > SEL$2F8A4177 > SEL$A0F2ABC8 ', 'LIMIT', '', '', '', '', '', 0, '', '', 0, 0, -1, 0, 1, 0, 1659047, 1000, 159, 1, ' /*+ */', '', '', 0, ' Plan Type: DISTRIBUTED Parameters: :0 => \'select DBMS_XPLAN.DISPLAY_CURSOR(\' :1 => 39 :2 => 39 :3 => \',\' :4 => 39 :5 => \'ADVANCED\' :6 => 39 :7 => \',\' :8 => 39 :9 => 39 :10 => \',\' :11 => 39 :12 => 39 :13 => \',\' :14 => 39 :15 => 39 :16 => \')\' :17 => \'%test20250916%\' :18 => 0 :19 => 1000 Note: Degree of Parallelisim is 1 because of table property Equal Parameter Constraints: :1 = :2 :1 = :4 :1 = :6 :1 = :8 :1 = :9 :1 = :11 :1 = :12 :1 = :14 :1 = :15 ', '', 0, 0, 0, '', '', '', 'output([concat(\'select DBMS_XPLAN.DISPLAY_CURSOR(\', cast(char(39, \'binary\'), VARCHAR(1048576)), cast(__all_virtual_sql_audit.plan_id, VARCHAR(1048576)), cast(char(39, \'binary\'), VARCHAR(1048576)), \',\', cast(char(39, \'binary\'), VARCHAR(1048576)), \'ADVANCED\', cast(char(39, \'binary\'), VARCHAR(1048576)), \',\', cast(char(39, \'binary\'), VARCHAR(1048576)), __all_virtual_sql_audit.svr_ip, cast(char(39, \'binary\'), VARCHAR(1048576)), \',\', cast(char(39, \'binary\'), VARCHAR(1048576)), cast(__all_virtual_sql_audit.svr_port, VARCHAR(1048576)), cast(char(39, \'binary\'), VARCHAR(1048576)), \',\', cast(char(39, \'binary\'), VARCHAR(1048576)), cast(__all_virtual_sql_audit.tenant_id, VARCHAR(1048576)), cast(char(39, \'binary\'), VARCHAR(1048576)), \')\')], [__all_virtual_sql_audit.query_sql])', 'limit(1000), offset(0)', 1659047, 'SEL$A0F2ABC8', ' /*+ BEGIN_OUTLINE_DATA FULL(@"SEL$A0F2ABC8" "oceanbase"."__all_virtual_sql_audit"@"SEL$2") PROJECT_PRUNE(@"SEL$2") MERGE(@"SEL$2F8A4177" < "SEL$1") OPTIMIZER_FEATURES_ENABLE(\'4.3.5.3\') END_OUTLINE_DATA */' ) | | select DBMS_XPLAN.DISPLAY_CURSOR('511952','ADVANCED','172.17.172.84','2882','1002') | EXPLAIN select concat('select DBMS_XPLAN.DISPLAY_CURSOR(',char(39),plan_id,char(39),',',char(39),'ADVANCED',char(39),',',char(39),svr_ip,char(39),',',char(39),svr_port,char(39),',',char(39),tenant_id,char(39),')') sql_explain,query_sql from oceanbase.gv$ob_sql_audit where query_sql like '%test20250916%' LIMIT 0, 1000 | | select DBMS_XPLAN.DISPLAY_CURSOR('0','ADVANCED','172.17.172.85','2882','1002') | select concat('select DBMS_XPLAN.DISPLAY_CURSOR(',char(39),plan_id,char(39),',',char(39),‘ADVANCED',char(39),',',char(39),svr_ip,char(39),',',char(39),svr_port,char(39),',',char(39),tenant_id,char(39),')') sql_explain,query_sql from oceanbase.gv$ob_sql_audit where query_sql like '%test20250916%'; LIMIT 0, 1000 | +-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 7 rows in set (0.617 sec) obclient(rd_read@woqu)[cprint]>