obdiag version: 3.7.2 observer version: 4.2.1.1 # ASH Report ---- Sample Begin: 2025-12-15 01:41:00 Sample End: 2025-12-15 01:51:00 ---------- Analysis Begin Time: 2025-12-15 01:41:00 Analysis End Time: 2025-12-15 01:50:52 Elapsed Time: 592 Num of Sample: 530 Num of Events: 530 Average Active Sessions: 0.90 ---- ## Top User Events: +----------------------------------------+--------------------+----------+---------+ | Event| WAIT_CLASS| EVENT_CNT| % Event| +----------------------------------------+--------------------+----------+---------+ | CPU + Wait for CPU| OTHER| 459| 86.60%| | default condition wait| CONCURRENCY| 1| 0.19%| | sleep wait| IDLE| 1| 0.19%| | io controller condition wait| CONCURRENCY| 5| 0.94%| | px loop condition wait| CONCURRENCY| 64| 12.08%| +----------------------------------------+--------------------+----------+---------+ ## Top Events P1/P2/P3 Value: +----------------------------------------+----------+------------+--------------------------------------------------+--------------------+--------------------+--------------------+ | Event| % Event| % Activity| Max P1/P2/P3| Parameter 1| Parameter 2| Parameter 3| +----------------------------------------+----------+------------+--------------------------------------------------+--------------------+--------------------+--------------------+ | CPU + Wait for CPU| 86.60%| 86.604%| 0, 0, 0| | | | | px loop condition wait| 12.08%| 12.075%| 140159578329776, 0, 0| address| | | | io controller condition wait| 0.94%| 0.943%| 139710512548512, 0, 0| address| | | | default condition wait| 0.19%| 0.189%| 140095904544776, 0, 0| address| | | | sleep wait| 0.19%| 0.189%| 500, 0, 0| sleep_interval| | | +----------------------------------------+----------+------------+--------------------------------------------------+--------------------+--------------------+--------------------+ ## Top Phase of Execution: +----------------------------------------+------------+--------------+----------------------------------------+ | Phase of Execution| % Activity| Sample Count| Avg Active Sessions| +----------------------------------------+------------+--------------+----------------------------------------+ | IN_SQL_EXECUTION| 87.736%| 465| 78.547%| | IN_STORAGE_READ| 40.566%| 215| 36.318%| | IN_PX_EXECUTION| 30.943%| 164| 27.703%| | IN_COMMITTING| 10.189%| 54| 9.122%| | IN_PLAN_CACHE| 2.075%| 11| 1.858%| | IN_STORAGE_WRITE| 1.509%| 8| 1.351%| | IN_SEQUENCE_LOAD| 0.755%| 4| 0.676%| | IN_PARSE| 0.377%| 2| 0.338%| | IN_PL_PARSE| 0.000%| 0| 0.000%| | IN_SQL_OPTIMIZE| 0.000%| 0| 0.000%| | IN_REMOTE_DAS_EXECUTION| 0.000%| 0| 0.000%| +----------------------------------------+------------+--------------+----------------------------------------+ ## Top SQL with Top Events - All events included. - Empty ''SQL Text'' if it is PL/SQL query +----------------------------------------+------------+-------------------------+----------------------------------------+------------+------------------------------------------------------------+ | SQL ID| PLAN ID| Sampled # of Executions| Event| % Event| SQL Text| +----------------------------------------+------------+-------------------------+----------------------------------------+------------+------------------------------------------------------------+ | E6817292C124582E5C084C7188576316| 5102| 33| CPU + Wait for CPU| 6.23%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | E6817292C124582E5C084C7188576316| 1101| 28| CPU + Wait for CPU| 5.28%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | E6817292C124582E5C084C7188576316| 1988986| 26| CPU + Wait for CPU| 4.91%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | 7D609596DF9F3484BEE4E449F484B04D| 5103| 25| CPU + Wait for CPU| 4.72%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 7D609596DF9F3484BEE4E449F484B04D| 1100| 22| CPU + Wait for CPU| 4.15%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 7D609596DF9F3484BEE4E449F484B04D| 2191903| 18| CPU + Wait for CPU| 3.40%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 554C40D9E5ADB74E7FA942CB071E342C| 5068154| 12| CPU + Wait for CPU| 2.26%| SELECT id,project_id,step_order,step_name,step_desc,st| | E6817292C124582E5C084C7188576316| 5102| 11| px loop condition wait| 2.08%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | E6817292C124582E5C084C7188576316| 1101| 11| px loop condition wait| 2.08%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | E6817292C124582E5C084C7188576316| 1988986| 11| px loop condition wait| 2.08%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | ADE90F182BFE5EC746BEB6DAF6276215| 2237| 11| CPU + Wait for CPU| 2.08%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ sq| | 7D609596DF9F3484BEE4E449F484B04D| 5103| 9| px loop condition wait| 1.70%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | ADE90F182BFE5EC746BEB6DAF6276215| 515| 9| CPU + Wait for CPU| 1.70%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ sq| | 2A2CFA54FC416AC5D72FE87CE7F7D5B3| 5068160| 9| CPU + Wait for CPU| 1.70%| SELECT id,project_id,step_order,step_name,step_desc,st| | 65D3F5BF2B8448B0CFDD69684B19BBEE| 5107| 9| CPU + Wait for CPU| 1.70%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ tim| | 7D609596DF9F3484BEE4E449F484B04D| 2191903| 8| px loop condition wait| 1.51%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 1D0BA376E273B9D622641124D8C59264| 636409| 8| CPU + Wait for CPU| 1.51%| | | 919309EA01B0C30F65761F710179DF09| 13677955| 8| CPU + Wait for CPU| 1.51%| UPDATE project SET extra_info='{\"accessObSource\":tru| | A9B1A27FE4D0E5F3D5AB759F190A0DE6| 524| 8| CPU + Wait for CPU| 1.51%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | 7D609596DF9F3484BEE4E449F484B04D| 1100| 7| px loop condition wait| 1.32%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | BA8656F6A0E2A31888B3A32E869F80EB| 637000| 7| CPU + Wait for CPU| 1.32%| UPDATE LogUserLogin_20251215 SET LogoutTime=FROM_UNIXTI| | 923D949AF30C198C39816EF7AFFF6975| 102| 6| CPU + Wait for CPU| 1.13%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ sql| | 0E89B7F8952D0FB89DE583330AC0909A| 1989017| 6| CPU + Wait for CPU| 1.13%| select t1.tenant_id, t1.database_name, t3.object_id as | | 65D3F5BF2B8448B0CFDD69684B19BBEE| 1989004| 6| CPU + Wait for CPU| 1.13%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ tim| | 4F1ADBA2D88CC0B8D6B410A36B879032| 2441| 6| CPU + Wait for CPU| 1.13%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | B2CEAB6B59E388615F9FB6CAE21E40FD| 636404| 6| CPU + Wait for CPU| 1.13%| insert into ops_lock (id, biz_id, type, holder, lock_ke| | 87A55C6C87D615DDEC102A529A35D895| 62738| 6| CPU + Wait for CPU| 1.13%| SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(5000000| | E0D9CA1D200CFCB40753A7C4836311F9| 613| 5| CPU + Wait for CPU| 0.94%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | A9B1A27FE4D0E5F3D5AB759F190A0DE6| 2302| 5| CPU + Wait for CPU| 0.94%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | CE24605B761C41943C6BA08A35ADE81F| 636438| 5| CPU + Wait for CPU| 0.94%| | | 464EAF546103E8BB2BD129A1B7A4D83C| 621770| 5| CPU + Wait for CPU| 0.94%| insert into heatbeat_sequence(id,gmt_created,gmt_modifi| | CD2615A9DBC9655E43585F52A0CB8C96| 13641538| 5| CPU + Wait for CPU| 0.94%| SELECT * FROM oms_connect_info ' ' WHERE id = 'c_6p0x| | 1CD6EBE44F821D58FBFA3314B97486F9| 443| 4| CPU + Wait for CPU| 0.75%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | 1589AE1DAD426F6B728EBA39B3316CA7| 5068170| 4| CPU + Wait for CPU| 0.75%| SELECT id,project_id,step_order,step_name,step_desc,st| | D5DB7F3A4850756FC46F5784940D3FF6| 13679141| 4| CPU + Wait for CPU| 0.75%| insert into heart_beat (id ,task_type' ,task_name ,tas| | 76140D276050A2AE4AB556A95998A9EC| 13677939| 4| CPU + Wait for CPU| 0.75%| SELECT id,type,worker_grade_id,name,owner,importance,st| | 1D0BA376E273B9D622641124D8C59264| 636438| 4| CPU + Wait for CPU| 0.75%| | | D7F4BE8008EF47CBFAD6A786CC252014| 5080| 4| CPU + Wait for CPU| 0.75%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */' | | 661F8B1C39FA18B9BE8DAC293DA563C2| 249| 4| CPU + Wait for CPU| 0.75%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ dis| | B2CEAB6B59E388615F9FB6CAE21E40FD| 636429| 4| CPU + Wait for CPU| 0.75%| insert into ops_lock (id, biz_id, type, holder, lock_ke| | D802E25B0F4DD243BB4113AC55C185D8| 5668| 3| CPU + Wait for CPU| 0.57%| SELECT tenant_id, MIN(unix_timestamp(`start_time`)*100| | AA29A293AB29D1DBF60FA8D7AA80F1D4| 5088884| 3| CPU + Wait for CPU| 0.57%| select uid,is_teacher,sys_pic_url,isdel,pic_url,addtime| | 4F1ADBA2D88CC0B8D6B410A36B879032| 525| 3| CPU + Wait for CPU| 0.57%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | 279A872E3A8B5946EC394A42CB37EB5B| 62745| 3| CPU + Wait for CPU| 0.57%| SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(5000000| | 541A86125E22C2FD8708EA4CF099091F| 285| 3| CPU + Wait for CPU| 0.57%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ ifn| | 3F6E5B862AA83BC02A91803A306DC91F| 498| 3| CPU + Wait for CPU| 0.57%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | B4E93D9C72559EA76E19FA6AD1EE3885| 13641546| 3| CPU + Wait for CPU| 0.57%| SELECT * FROM oms_connect_info WHERE id='c_6p0x0bjv960w| | E0D9CA1D200CFCB40753A7C4836311F9| 2748| 3| CPU + Wait for CPU| 0.57%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | 5E5C065BF37472A85B7A3F45B73E16F1| 2686| 3| CPU + Wait for CPU| 0.57%| SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM | | 76140D276050A2AE4AB556A95998A9EC| 13677939| 3| io controller condition wait| 0.57%| SELECT id,type,worker_grade_id,name,owner,importance,st| | 65D3F5BF2B8448B0CFDD69684B19BBEE| 289| 3| CPU + Wait for CPU| 0.57%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ tim| | 541A86125E22C2FD8708EA4CF099091F| 439| 3| CPU + Wait for CPU| 0.57%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ ifn| | EDB63B19291D5E73FE31F19A77CFD753| 5068163| 3| CPU + Wait for CPU| 0.57%| SELECT COUNT( 1 ) FROM oms_step ' ' WHERE project_id = | | 19A6DAA1FE8C8540A65B48C620C52D94| 5068148| 3| CPU + Wait for CPU| 0.57%| UPDATE oms_step SET step_progress=100,''step_info='{\"| | 07F3B3BA76387852D4A72139BE936D14| 507| 3| CPU + Wait for CPU| 0.57%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | AA29A293AB29D1DBF60FA8D7AA80F1D4| 631911| 2| CPU + Wait for CPU| 0.38%| select uid,is_teacher,sys_pic_url,isdel,pic_url,addtime| | B0BF9D6B046B5CA6261A814C99195485| 635702| 2| CPU + Wait for CPU| 0.38%| update crawler' SET err_msg = '[Tue Nov 11 | | 000AB74A68F9141C13784CCF4E6540AF| 62717| 2| CPU + Wait for CPU| 0.38%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ ' t| | A42720412F164B15DCCBCC20B9EDA498| 13677956| 2| io controller condition wait| 0.38%| select * from project' where' ' `| | 58F7C45900D0B9E6293F8AFD27DC4948| 636438| 2| CPU + Wait for CPU| 0.38%| delete from ops_lock where id=303974151| | 41203FBCC0CDC03EA8646593391B644B| 1819870| 2| CPU + Wait for CPU| 0.38%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | B6F2A13C4C81145FFAA2F2A5CF9587A9| 5657| 2| CPU + Wait for CPU| 0.38%| select /*+query_timeout(2000000)*/ a.svr_ip, a.svr_port| | DB9FE488781AF5A3DE810062B8A168AB| 2271| 2| CPU + Wait for CPU| 0.38%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ co| | FA38D44B8EE5668AF6A135937672DBE4| 605606| 2| CPU + Wait for CPU| 0.38%| select' ' id,job_id, job_name,job_type,j| | 0AABDC9A6D53CB2B2F96419FBC587D08| 13692040| 2| CPU + Wait for CPU| 0.38%| insert into heart_beat (id ,task_type' ,task_name ,tas| | 5E5C065BF37472A85B7A3F45B73E16F1| 336| 2| CPU + Wait for CPU| 0.38%| SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM | | 0DCDB999AC02EFF4DD0679F88C56167C| 636401| 2| CPU + Wait for CPU| 0.38%| | | D802E25B0F4DD243BB4113AC55C185D8| 5668| 2| px loop condition wait| 0.38%| SELECT tenant_id, MIN(unix_timestamp(`start_time`)*100| | 618928D0D81F6C0EBFAB094D496F7AF1| 250| 1| CPU + Wait for CPU| 0.19%| select /* MONITOR_AGENT */ con_id tenant_id, stat_id, v| | FBD5E474371E49B5A64B643292FF89FF| 13694598| 1| CPU + Wait for CPU| 0.19%| UPDATE shedlock SET lock_until = '2025-12-12 22:05:28.4| | 43BFCAA065A7ADA6269F5CD3EF991F70| 337| 1| CPU + Wait for CPU| 0.19%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ dis| | 4B7FCBC1BE76C00A751B55D0035752ED| 13692039| 1| CPU + Wait for CPU| 0.19%| insert into heart_beat (id ,task_type' ,task_name ,tas| | 52D800CE55A3494600F575225F58130C| 63132| 1| CPU + Wait for CPU| 0.19%| SELECT t1.con_id AS tenant_id,t1.owner AS database_name| | 541A86125E22C2FD8708EA4CF099091F| 1995| 1| CPU + Wait for CPU| 0.19%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ ifn| | BF5DA25F16BCFCDD1FAB3883B580ECD2| 63131| 1| CPU + Wait for CPU| 0.19%| SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(5000000| | 8E3144D3AA4A9C187036297DDE387E01| 587| 1| CPU + Wait for CPU| 0.19%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | 1D0BA376E273B9D622641124D8C59264| 13694598| 1| CPU + Wait for CPU| 0.19%| | | 32387A254FB2A63976A5E3E634B8974A| 5012283| 1| CPU + Wait for CPU| 0.19%| SELECT id,next_task,task_type,task_group,task_order,ta| | AE9840194553081963DF7A7E2D68532E| 571| 1| CPU + Wait for CPU| 0.19%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | 700306ABE228CC8053CB46D7FF32B24A| 631997| 1| CPU + Wait for CPU| 0.19%| select pic_url,sys_pic_url,addtime from eeo_monitor whe| | 82E31DE3F1707AB1E37C246C5C940E2E| 13687173| 1| CPU + Wait for CPU| 0.19%| insert into s_checkpoint' (id,gmt_created,gmt_modified| | AA29A293AB29D1DBF60FA8D7AA80F1D4| 13691626| 1| CPU + Wait for CPU| 0.19%| select uid,is_teacher,sys_pic_url,isdel,pic_url,addtime| | D950AAAD6DBD4DD227884EBFAC784569| 2362| 1| CPU + Wait for CPU| 0.19%| select /* MONITOR_AGENT */ tenant_id, cache_name, cache| | 41EC2A5E2CECB8B10A54925465252A3D| 637005| 1| CPU + Wait for CPU| 0.19%| INSERT INTO LogUserLogin_20251215(LoginTime,UID,Account| | 03DB26D4B0B5C8DFB3AA1C12851FFF6A| 13695916| 1| CPU + Wait for CPU| 0.19%| UPDATE LogUserLogin_20251214 SET LogoutTime=FROM_UNIXTI| | 1D0BA376E273B9D622641124D8C59264| 13694601| 1| CPU + Wait for CPU| 0.19%| | | 9A82289E109D10E13B35DD7BB371D94E| 62702| 1| CPU + Wait for CPU| 0.19%| select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ coun| | AE1E19B59F4CEB481A2F3D60F2123BF1| 4991314| 1| CPU + Wait for CPU| 0.19%| select count(*) from connector_task_v2 where status != | | 3FFFFF358B8A22EDCC0139B2E0C017D4| 13676825| 1| CPU + Wait for CPU| 0.19%| update host set gmt_modified=now(), congo_usage = 0,con| | 731F225ADBDFEA4D82ADB5B3B35F438B| 13691789| 1| CPU + Wait for CPU| 0.19%| SELECT pic_url,sys_pic_url,client_class_id,isdel,client| | ACCC145FBF86D4BA2E4914FBE502B33E| 1988962| 1| CPU + Wait for CPU| 0.19%| select tenant_id, table_name, table_id, tablet_id as `p| | 9D35F1FA62F77241835CDD51DB3ABACA| 13694359| 1| CPU + Wait for CPU| 0.19%| select `id`, `pic_url` from `eeo_monitor` where `school| | 18CA7FA39769A3F8B321688F40B03D2E| 13695951| 1| CPU + Wait for CPU| 0.19%| INSERT INTO `eeo_moderation_202512` (`app_id`,`source`,| | A6E7B773E6B160CAEF1E4572C36942B0| 0| 1| CPU + Wait for CPU| 0.19%| | | 3F9F402B79FF72762D24E80FB387B088| 5088464| 1| CPU + Wait for CPU| 0.19%| INSERT INTO `eeo_monitor` (`school_uid`,`client_class_i| | 5E5C065BF37472A85B7A3F45B73E16F1| 156718| 1| CPU + Wait for CPU| 0.19%| SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM | | 7E2E2FCADB4200A73400D4431368F19D| 9022| 1| CPU + Wait for CPU| 0.19%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | BBFA386EAB9BA7396CD414A09F1A204F| 637001| 1| CPU + Wait for CPU| 0.19%| INSERT INTO LogClassAttendance_20251215(ActionTime,UID,| | AE9840194553081963DF7A7E2D68532E| 33562| 1| CPU + Wait for CPU| 0.19%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ di| | 14FBAABC8D3C048B8CE7B15D62AAB926| 619311| 1| CPU + Wait for CPU| 0.19%| select' ' id, task_id, task_name, checkpoint, gmt, g| +----------------------------------------+------------+-------------------------+----------------------------------------+------------+------------------------------------------------------------+ ## Top SQL with Top Blocking Events - Empty result if no event other than On CPU sampled - Empty ''SQL Text'' if it is PL/SQL query +----------------------------------------+------------+-------------------------+----------------------------------------+------------+------------------------------------------------------------+ | SQL ID| PLAN ID| Sampled # of Executions| Event| % Event| SQL Text| +----------------------------------------+------------+-------------------------+----------------------------------------+------------+------------------------------------------------------------+ | E6817292C124582E5C084C7188576316| 5102| 11| px loop condition wait| 2.08%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | E6817292C124582E5C084C7188576316| 1988986| 11| px loop condition wait| 2.08%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | E6817292C124582E5C084C7188576316| 1101| 11| px loop condition wait| 2.08%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | 7D609596DF9F3484BEE4E449F484B04D| 5103| 9| px loop condition wait| 1.70%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 7D609596DF9F3484BEE4E449F484B04D| 2191903| 8| px loop condition wait| 1.51%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 7D609596DF9F3484BEE4E449F484B04D| 1100| 7| px loop condition wait| 1.32%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 76140D276050A2AE4AB556A95998A9EC| 13677939| 3| io controller condition wait| 0.57%| SELECT id,type,worker_grade_id,name,owner,importance,st| | D802E25B0F4DD243BB4113AC55C185D8| 5668| 2| px loop condition wait| 0.38%| SELECT tenant_id, MIN(unix_timestamp(`start_time`)*100| | A42720412F164B15DCCBCC20B9EDA498| 13677956| 2| io controller condition wait| 0.38%| select * from project' where' ' `| | 5E5C065BF37472A85B7A3F45B73E16F1| 336| 1| px loop condition wait| 0.19%| SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM | | 5E5C065BF37472A85B7A3F45B73E16F1| 156718| 1| px loop condition wait| 0.19%| SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM | | 1B78F9DBE5748F02C8157BD4EEEE0ADB| 5669| 1| px loop condition wait| 0.19%| SELECT SVR_IP, SVR_PORT, ZONE, CPU_CAPACITY, CPU_CAPACI| | 7D609596DF9F3484BEE4E449F484B04D| 2191903| 1| default condition wait| 0.19%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | 731F225ADBDFEA4D82ADB5B3B35F438B| 13691789| 1| px loop condition wait| 0.19%| SELECT pic_url,sys_pic_url,client_class_id,isdel,client| | 5E5C065BF37472A85B7A3F45B73E16F1| 2686| 1| px loop condition wait| 0.19%| SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM | | 363C1C29FAE7C291DC41D53CFECB88FD| 631924| 1| sleep wait| 0.19%| SELECT pic_url,sys_pic_url,client_class_id,isdel,client| +----------------------------------------+------------+-------------------------+----------------------------------------+------------+------------------------------------------------------------+ ## Complete List of SQL Text: SQL ID: E6817292C124582E5C084C7188576316 PLAN ID: 5102 SQL Text: SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (ash.event_no is null or ash.event_no = 0, 'ON_CPU', wait_class) waitclass, count(*) as cnt FROM oceanbase.v$active_session_history ash WHERE sample_time between now() - INTERVAL 1 SECOND and now() and (wait_class <> 'IDLE' or wait_class is null) and session_type = 'FOREGROUND' group by waitclass, tenant_id SQL ID: E6817292C124582E5C084C7188576316 PLAN ID: 1101 SQL Text: SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (ash.event_no is null or ash.event_no = 0, 'ON_CPU', wait_class) waitclass, count(*) as cnt FROM oceanbase.v$active_session_history ash WHERE sample_time between now() - INTERVAL 1 SECOND and now() and (wait_class <> 'IDLE' or wait_class is null) and session_type = 'BACKGROUND' group by waitclass, tenant_id SQL ID: E6817292C124582E5C084C7188576316 PLAN ID: 1988986 SQL Text: SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (ash.event_no is null or ash.event_no = 0, 'ON_CPU', wait_class) waitclass, count(*) as cnt FROM oceanbase.v$active_session_history ash WHERE sample_time between now() - INTERVAL 1 SECOND and now() and (wait_class <> 'IDLE' or wait_class is null) and session_type = 'FOREGROUND' group by waitclass, tenant_id SQL ID: 7D609596DF9F3484BEE4E449F484B04D PLAN ID: 5103 SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.v$active_session_history WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from oceanbase.V$OB_UNITS) t on ash.con_id = t.tenant_id group by tenant_id SQL ID: 7D609596DF9F3484BEE4E449F484B04D PLAN ID: 1100 SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.v$active_session_history WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from oceanbase.V$OB_UNITS) t on ash.con_id = t.tenant_id group by tenant_id SQL ID: 7D609596DF9F3484BEE4E449F484B04D PLAN ID: 2191903 SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.v$active_session_history WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from oceanbase.V$OB_UNITS) t on ash.con_id = t.tenant_id group by tenant_id SQL ID: 554C40D9E5ADB74E7FA942CB071E342C PLAN ID: 5068154 SQL Text: SELECT id,project_id,step_order,step_name,step_desc,step_status,step_progress,remaining_seconds,step_info,is_show,extra_info,start_time,finish_time,gmt_create,retry_count,gmt_modified,interactive FROM oms_step WHERE project_id = 'np_6p4758912eqo' AND step_status = 'RUNNING' ORDER BY step_order ASC for update SQL ID: E6817292C124582E5C084C7188576316 PLAN ID: 1101 SQL Text: SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (ash.event_no is null or ash.event_no = 0, 'ON_CPU', wait_class) waitclass, count(*) as cnt FROM oceanbase.v$active_session_history ash WHERE sample_time between now() - INTERVAL 1 SECOND and now() and (wait_class <> 'IDLE' or wait_class is null) and session_type = 'BACKGROUND' group by waitclass, tenant_id SQL ID: ADE90F182BFE5EC746BEB6DAF6276215 PLAN ID: 2237 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id = 'A8F837BDD713660089A86C7DB92364EF' SQL ID: E6817292C124582E5C084C7188576316 PLAN ID: 1988986 SQL Text: SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (ash.event_no is null or ash.event_no = 0, 'ON_CPU', wait_class) waitclass, count(*) as cnt FROM oceanbase.v$active_session_history ash WHERE sample_time between now() - INTERVAL 1 SECOND and now() and (wait_class <> 'IDLE' or wait_class is null) and session_type = 'FOREGROUND' group by waitclass, tenant_id SQL ID: E6817292C124582E5C084C7188576316 PLAN ID: 5102 SQL Text: SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (ash.event_no is null or ash.event_no = 0, 'ON_CPU', wait_class) waitclass, count(*) as cnt FROM oceanbase.v$active_session_history ash WHERE sample_time between now() - INTERVAL 1 SECOND and now() and (wait_class <> 'IDLE' or wait_class is null) and session_type = 'FOREGROUND' group by waitclass, tenant_id SQL ID: 2A2CFA54FC416AC5D72FE87CE7F7D5B3 PLAN ID: 5068160 SQL Text: SELECT id,project_id,step_order,step_name,step_desc,step_status,step_progress,remaining_seconds,step_info,is_show,extra_info,start_time,finish_time,gmt_create,retry_count,gmt_modified,interactive FROM oms_step WHERE project_id = 'np_6xj06vn8ghvk' AND step_status NOT IN ('FINISHED','MONITORING') ORDER BY step_order ASC for update SQL ID: 65D3F5BF2B8448B0CFDD69684B19BBEE PLAN ID: 5107 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ time_to_usec(now()) as collect_time, tenant_id, db_id, plan_id, outline_id, avg_exe_usec, slowest_exe_usec, slow_count, hit_count, executions, disk_reads, direct_writes, buffer_gets, application_wait_time, concurrency_wait_time, user_io_wait_time, rows_processed, elapsed_time, cpu_time, large_querys, delayed_large_querys, table_scan, timeout_count, time_to_usec(first_load_time) as first_load_time, sql_id, type, plan_hash, schema_version, 0 as merged_version, plan_size, outline_data, query_sql from V$OB_PLAN_CACHE_PLAN_STAT where (unix_timestamp(now()) - unix_timestamp(last_active_time)) < 24*3600 and tenant_id = 1 and plan_id > 0 and object_type = 'sql_plan' order by plan_id limit 4000 SQL ID: ADE90F182BFE5EC746BEB6DAF6276215 PLAN ID: 515 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id = '707AFBE6C4B3D0A4F19D0C5D28E26AB4' SQL ID: 7D609596DF9F3484BEE4E449F484B04D PLAN ID: 5103 SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.v$active_session_history WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from oceanbase.V$OB_UNITS) t on ash.con_id = t.tenant_id group by tenant_id SQL ID: 7D609596DF9F3484BEE4E449F484B04D PLAN ID: 2191903 SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.v$active_session_history WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from oceanbase.V$OB_UNITS) t on ash.con_id = t.tenant_id group by tenant_id SQL ID: A9B1A27FE4D0E5F3D5AB759F190A0DE6 PLAN ID: 524 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('1EAEFF53F37CF2EBFBF57CE46BA8D34B', '4EAF1689832BC42207826880E035F6CE', 'B8D6C23A5B6488FE9E3869401AF8AAC3') SQL ID: 919309EA01B0C30F65761F710179DF09 PLAN ID: 13677955 SQL Text: UPDATE project SET extra_info='{\"accessObSource\":true,\"delay\":1,\"delaySyncGmt\":1764165619,\"ignoreUnsupportDdl\":true,\"incrLogPullComponentCleared\":false,\"incrSyncComponentCleared\":false,\"logServiceStartCheckpoint\":1745829392,\"maxConnectorCount\":-1,\"monitoringIncr\":false,\"overwriteConfig\":false,\"runningProgress\":0,\"runningStep\":\"TRANSFER_APP_SWITCH\",\"sourceStoreKeptHour\":72,\"storeIncr\":false,\"subIds\":{},\"subtopics\":[\"OB_MYSQL_CE_np_6p0tey84opi8_6p0tfee40f40-1-0\"]}' WHERE id='np_6p0tey84opi8' SQL ID: BA8656F6A0E2A31888B3A32E869F80EB PLAN ID: 637000 SQL Text: UPDATE LogUserLogin_20251215 SET LogoutTime=FROM_UNIXTIME(1765728003),OnlineTimeLength=1,LogoutReason='Socket closed (6)' WHERE ClientID=73183725882502806 AND LoginTime=FROM_UNIXTIME(1765728002) SQL ID: 7D609596DF9F3484BEE4E449F484B04D PLAN ID: 1100 SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.v$active_session_history WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from oceanbase.V$OB_UNITS) t on ash.con_id = t.tenant_id group by tenant_id SQL ID: 923D949AF30C198C39816EF7AFFF6975 PLAN ID: 102 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.164' and svr_port = 2882 and sql_id = 'C91D99E17F8B664B81976EE88BF02B05' SQL ID: B2CEAB6B59E388615F9FB6CAE21E40FD PLAN ID: 636404 SQL Text: insert into ops_lock (id, biz_id, type, holder, lock_key, gmt_locked, gmt_refresh, gmt_create, gmt_modified, lock_status) values (NULL,'np_7857i99jxmu8', 'UpdateProjectExtraInfo', 'eeo-dst113', 'np_7857i99jxmu8UpdateProjectExtraInfo', now(),now(),now(),now(), 1) SQL ID: 87A55C6C87D615DDEC102A529A35D895 PLAN ID: 62738 SQL Text: SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ a.tenant_id,a.svr_ip,a.svr_port,sum(data_size) as data_size, sum(required_size) as required_size FROM CDB_OB_TABLE_LOCATIONS a LEFT JOIN (SELECT tenant_id,tablet_id,svr_ip,svr_port,data_size,required_size FROM __all_virtual_tablet_meta_table) b ON a.TENANT_ID = b.tenant_id AND a.tablet_id = b.tablet_id AND a.SVR_IP = b.SVR_IP AND a.SVR_PORT = b.SVR_PORT LEFT JOIN __all_virtual_table c ON a.TENANT_ID = c.TENANT_ID AND a.table_id = c.table_id group by a.tenant_id, a.svr_ip,a.svr_port SQL ID: 4F1ADBA2D88CC0B8D6B410A36B879032 PLAN ID: 2441 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('ECF14B1A6C7289EB831A5292614AEF94', '0C1EFF1812F9AB1D34FC7D14D37B1221') SQL ID: 65D3F5BF2B8448B0CFDD69684B19BBEE PLAN ID: 1989004 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ time_to_usec(now()) as collect_time, tenant_id, db_id, plan_id, outline_id, avg_exe_usec, slowest_exe_usec, slow_count, hit_count, executions, disk_reads, direct_writes, buffer_gets, application_wait_time, concurrency_wait_time, user_io_wait_time, rows_processed, elapsed_time, cpu_time, large_querys, delayed_large_querys, table_scan, timeout_count, time_to_usec(first_load_time) as first_load_time, sql_id, type, plan_hash, schema_version, 0 as merged_version, plan_size, outline_data, query_sql from V$OB_PLAN_CACHE_PLAN_STAT where (unix_timestamp(now()) - unix_timestamp(last_active_time)) < 24*3600 and tenant_id = 1 and plan_id > 0 and object_type = 'sql_plan' order by plan_id limit 4000 SQL ID: 0E89B7F8952D0FB89DE583330AC0909A PLAN ID: 1989017 SQL Text: select t1.tenant_id, t1.database_name, t3.object_id as database_id, sum(t2.data_size) as data_size, sum(t2.required_size) as required_size from (select tenant_id, database_name, table_id, tablet_id from cdb_ob_table_locations group by tenant_id, database_name, tablet_id) t1 left join (select tenant_id, tablet_id, svr_ip, svr_port, data_size, required_size from cdb_ob_tablet_replicas) t2 on t1.tenant_id = t2.tenant_id and t1.tablet_id = t2.tablet_id left join (select con_id, object_name ,object_id from CDB_OBJECTS where object_type = 'DATABASE') t3 on t1.tenant_id = t3.con_id and t1.database_name = t3.object_name group by t1.tenant_id, t1.database_name SQL ID: CD2615A9DBC9655E43585F52A0CB8C96 PLAN ID: 13641538 SQL Text: SELECT * FROM oms_connect_info WHERE id = 'c_6p0x0bjv960w' OR partner_id = 'c_6p0x0bjv960w' SQL ID: E0D9CA1D200CFCB40753A7C4836311F9 PLAN ID: 613 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('16F996F2F27930032410A70F41A5B077', '4256FE1A7BE0C815E4FF71116D462834', '2CB7972ABBE40991FDE22E76A1C92240', '0292E31C6B5BD347782CF7F6BCAAA204', '6B9C1E3E968FF97ABF3A1A990013DD2D') SQL ID: 464EAF546103E8BB2BD129A1B7A4D83C PLAN ID: 621770 SQL Text: insert into heatbeat_sequence(id,gmt_created,gmt_modified ) values (null,now(),now()) SQL ID: A9B1A27FE4D0E5F3D5AB759F190A0DE6 PLAN ID: 2302 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('5506F3D24FB42A19FAC30960B0D34F90', 'FF6F42B98EF9E8CA124A3B9D46BF41D6', '680BD5859F0E6A4B1D9A24046B5A3726') SQL ID: 661F8B1C39FA18B9BE8DAC293DA563C2 PLAN ID: 249 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.164' and svr_port = 2882 and sql_id in ('173F33DB2B78A480AD67AB6576C9FC7F', '173F33DB2B78A480AD67AB6576C9FC7F') SQL ID: B2CEAB6B59E388615F9FB6CAE21E40FD PLAN ID: 636429 SQL Text: insert into ops_lock (id, biz_id, type, holder, lock_key, gmt_locked, gmt_refresh, gmt_create, gmt_modified, lock_status) values (NULL,'np_6p0ugtywiggw', 'UpdateProjectExtraInfo', 'eeo-ddm014', 'np_6p0ugtywiggwUpdateProjectExtraInfo', now(),now(),now(),now(), 1) SQL ID: D5DB7F3A4850756FC46F5784940D3FF6 PLAN ID: 13679141 SQL Text: insert into heart_beat (id ,task_type ,task_name ,task_id ,host_ip ,version, gmt_created ,gmt_modified ) values (294199274,'supervisor','supervisor', null,'10.1.62.13',null,now(),now()) , (294199276,'crawler','10.1.62.13-7108:MYSQL_np_71cx1oq00zk0_71cx2ybiogtc-1-0:0000000087', 87,'10.1.62.13','5.7.11',now(),now()) , (294199278,'crawler','10.1.62.13-7106:OB_MYSQL_CE_np_6q5938afa2yo_6q593sprurr4-1-0:0000000033', 33,'10.1.62.13','/home/ds/store/store7106/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199280,'crawler','10.1.62.13-7100:OB_MYSQL_CE_np_6p0tey84opi8_6p0tfee40f40-1-0:0000000006', 6,'10.1.62.13','/home/ds/store/store7100/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199281,'crawler','10.1.62.13-7104:OB_MYSQL_CE_np_6p1dv7fpizuo_6p1dvi5qb7i8-1-0:0000000021', 21,'10.1.62.13','/home/ds/store/store7104/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199282,'crawler','10.1.62.13-7105:OB_MYSQL_CE_ten_1_6p4adfvxsxuo-1-0:0000000023', 23,'10.1.62.13','/home/ds/store/store7105/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199283,'crawler','10.1.62.13-7110:OB_MYSQL_CE_np_7a4ur73eo8e8_7a4uskylqxj4-1-0:0000000089', 89,'10.1.62.13','/home/ds/store/store7110/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199284,'crawler','10.1.62.13-7112:OB_MYSQL_CE_np_6re11l5d2pk0_6re123mna1y8-1-0:0000000063', 63,'10.1.62.13','/home/ds/store/store7112/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199285,'crawler','10.1.62.13-7103:MYSQL_np_6p0zl6lt3lq8_6p0zlkdpfyw0-1-0:0000000015', 15,'10.1.62.13','5.7.11',now(),now()) , (294199286,'crawler','10.1.62.13-7111:OB_MYSQL_CE_np_6rawxadzscww_6rawxsttophc-1-0:0000000058', 58,'10.1.62.13','/home/ds/store/store7111/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199287,'crawler','10.1.62.13-7102:MYSQL_np_6p0z0ikpebr4_6p0z0wte25i8-1-0:0000000014', 14,'10.1.62.13','5.7.11',now(),now()) , (294199288,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p0s8ld3mxs0-incr_trans-1-0:0000000007', 7,'10.1.62.13',null,now(),now()) , (294199289,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p0w2zi3dthc-incr_trans-1-0:0000000012', 12,'10.1.62.13',null,now(),now()) , (294199290,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p0y7nlnt5i8-incr_trans-1-0:0000000016', 16,'10.1.62.13',null,now(),now()) , (294199291,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p0yg0wsdq5c-incr_trans-1-0:0000000017', 17,'10.1.62.13',null,now(),now()) , (294199292,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p0z0ikpebr4-incr_trans-1-0:0000000019', 19,'10.1.62.13',null,now(),now()) , (294199293,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p17tl5j1qg0-incr_trans-1-0:0000000024', 24,'10.1.62.13',null,now(),now()) , (294199294,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p18u69klyps-incr_trans-1-0:0000000026', 26,'10.1.62.13',null,now(),now()) , (294199295,'CONNECTORTASKV2','10.1.62.13-9000:connector_v2:np_6p1eaz1desxs-incr_trans-1-0:00000 SQL ID: D7F4BE8008EF47CBFAD6A786CC252014 PLAN ID: 5080 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ svr_ip, sql_id, tenant_id, tenant_name, user_id, user_name, db_id, db_name, plan_id, trace_id, sid, client_ip, client_port, user_client_ip, request_time, request_id, elapsed_time, execute_time, total_wait_time_micro, wait_time_micro, get_plan_time, affected_rows, return_rows, partition_cnt, ret_code, (case when ret_code = 0 then 0 else 1 end) as fail_count, (case when ret_code = -4012 then 1 else 0 end) as ret_code_4012_count, (case when ret_code = -4013 then 1 else 0 end) as ret_code_4013_count, (case when ret_code = -5001 then 1 else 0 end) as ret_code_5001_count, (case when ret_code = -5024 then 1 else 0 end) as ret_code_5024_count, (case when ret_code = -5167 then 1 else 0 end) as ret_code_5167_count, (case when ret_code = -5217 then 1 else 0 end) as ret_code_5217_count, (case when ret_code = -6002 then 1 else 0 end) as ret_code_6002_count, event, p1, p2, p3, p1text, p2text, p3text, (case event when 'system internal wait' then wait_time_micro else 0 end) as event_0_wait_time, (case event when 'mysql response wait client' then wait_time_micro else 0 end) as event_1_wait_time, (case event when 'sync rpc' then wait_time_micro else 0 end) as event_2_wait_time, (case event when 'db file data read' then wait_time_micro else 0 end) as event_3_wait_time, total_waits, rpc_count, plan_type, (case when plan_type=1 then 1 else 0 end) as plan_type_local_count, (case when plan_type=2 then 1 else 0 end) as plan_type_remote_count, (case when plan_type=3 then 1 else 0 end) as plan_type_dist_count, is_inner_sql, is_executor_rpc, is_hit_plan, consistency_level, (case when is_inner_sql=1 then 1 else 0 end) as inner_sql_count, (case when is_executor_rpc = 1 then 1 else 0 end) as executor_rpc_count, (case when is_hit_plan=1 then 0 else 1 end) as miss_plan_count, (case consistency_level when 3 then 1 else 0 end) as consistency_level_strong, (case consistency_level when 2 then 1 else 0 end) as consistency_level_weak, net_time, net_wait_time, queue_time, decode_time, application_wait_time, concurrency_wait_time, user_io_wait_time, schedule_time, row_cache_hit, bloom_filter_cache_hit, block_cache_hit, disk_reads, retry_cnt, table_scan, memstore_read_row_count, ssstore_read_row_count, query_sql, 0 as block_index_cache_hit, expected_worker_count, used_worker_count, request_memory_used, tx_id as transaction_hash, effective_tenant_id, params_value, flt_trace_id, null as format_sql_id from `V$OB_SQL_AUDIT` where tenant_id = 1 and request_id >= 1286100035 limit 4000 SQL ID: 76140D276050A2AE4AB556A95998A9EC PLAN ID: 13677939 SQL Text: SELECT id,type,worker_grade_id,name,owner,importance,status,gmt_create,gmt_modified,gmt_start,gmt_finish,extra_info,source_endpoint_id,sink_endpoint_id,source_endpoint_type,sink_endpoint_type,source_conn_id,sink_conn_id,is_merging,is_modifying,is_sub_project,transfer_mapping,common_transfer_config,enable_struct_transfer,struct_transfer_config,enable_full_transfer,enable_full_verify,full_transfer_config,enable_incr_transfer,enable_incr_verify,enable_reverse_incr_transfer,incr_transfer_config,precheck_id FROM project WHERE id='np_6p0w2zi3dthc' SQL ID: 1589AE1DAD426F6B728EBA39B3316CA7 PLAN ID: 5068170 SQL Text: SELECT id,project_id,step_order,step_name,step_desc,step_status,step_progress,remaining_seconds,step_info,is_show,extra_info,start_time,finish_time,gmt_create,retry_count,gmt_modified,interactive FROM oms_step WHERE step_name = 'INDEX_TRANSFER' AND step_status = 'RUNNING' ORDER BY id ASC SQL ID: 1CD6EBE44F821D58FBFA3314B97486F9 PLAN ID: 443 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('7CA77EA16A2319EA4F33EA9D8F45208D', '6BD2379DDF3BAEF6AC7F5F65B4A51C07', '407BEE362267A3A661D2844BA1D2F97C', '5498EEFF455310CBD58875428B677011', '60D9BD7285B8D2D6AE89F7C622A3BE2E', '5D69E89D6CF3CE20D5B8DAE4FC2D2D67', '98ED3BDBFC48A1B1D67C212F5157066D') SQL ID: 07F3B3BA76387852D4A72139BE936D14 PLAN ID: 507 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('57726A3273E7A0F5F82E898A2B22E7BF', '580E62F091D800FC0EFBE2E8D552F506', '1DBFC0B2F9591A44F85EA9D6D30DBACD', '00D382BB08F517937DF0583AE76B153B') SQL ID: E0D9CA1D200CFCB40753A7C4836311F9 PLAN ID: 2748 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('15C627C1DD061180E4AA1553839015BE', '5909BF1DD11F996B311AF3BA48CFDDEA', '1EAEFF53F37CF2EBFBF57CE46BA8D34B', '4EAF1689832BC42207826880E035F6CE', 'B8D6C23A5B6488FE9E3869401AF8AAC3') SQL ID: 76140D276050A2AE4AB556A95998A9EC PLAN ID: 13677939 SQL Text: SELECT id,type,worker_grade_id,name,owner,importance,status,gmt_create,gmt_modified,gmt_start,gmt_finish,extra_info,source_endpoint_id,sink_endpoint_id,source_endpoint_type,sink_endpoint_type,source_conn_id,sink_conn_id,is_merging,is_modifying,is_sub_project,transfer_mapping,common_transfer_config,enable_struct_transfer,struct_transfer_config,enable_full_transfer,enable_full_verify,full_transfer_config,enable_incr_transfer,enable_incr_verify,enable_reverse_incr_transfer,incr_transfer_config,precheck_id FROM project WHERE id='np_6p0w2zi3dthc' SQL ID: AA29A293AB29D1DBF60FA8D7AA80F1D4 PLAN ID: 5088884 SQL Text: select uid,is_teacher,sys_pic_url,isdel,pic_url,addtime,client_id,device_id,device_name from eeo_monitor where client_class_id = 1005239531 and pic_group = 1765322218 order by addtime asc SQL ID: 4F1ADBA2D88CC0B8D6B410A36B879032 PLAN ID: 525 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('4D9975A73EFA33AFFDC770D2C43DE0DE', 'CE2ED79622A88B35B266821207D99DBC') SQL ID: 3F6E5B862AA83BC02A91803A306DC91F PLAN ID: 498 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('9978FD3DB0A66BD6D770DF10777ED9BE', '7C895CA99D111B696EE33230828BDCC2', 'C5D69910A0D14809BFE16B15FA624785', 'B76621FB57AA6CCAA9141702B6E0A49F', '61A8A4DD633AA532D1E3DA5138747532', '5AD869A78E3C36E3681D62BAAB07808F') SQL ID: 279A872E3A8B5946EC394A42CB37EB5B PLAN ID: 62745 SQL Text: SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ a.tenant_id,a.svr_ip,a.svr_port,SUM(data_size) AS data_size FROM cdb_ob_table_locations a JOIN (SELECT tenant_id,tablet_id,svr_ip,svr_port,data_size,required_size FROM __all_virtual_tablet_meta_table) b ON a.tenant_id = b.tenant_id AND a.tablet_id = b.tablet_id AND a.svr_ip = b.svr_ip AND a.svr_port = b.svr_port JOIN __all_virtual_table c ON a.tenant_id = c.tenant_id AND c.table_type = 5 AND a.table_id = c.table_id GROUP BY a.tenant_id,a.svr_ip,a.svr_port SQL ID: 541A86125E22C2FD8708EA4CF099091F PLAN ID: 285 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ ifnull(max(request_id), 0) max_request_id, ifnull(min(request_id), 0) min_request_id from (select request_id from `v$sql_plan_monitor` where (unix_timestamp(first_refresh_time) *1000000) >= 1752742127000000 and (unix_timestamp(first_refresh_time) *1000000) < 1752742187000000 and request_id > 0 and con_id = 1001 order by request_id limit 4000) t SQL ID: 65D3F5BF2B8448B0CFDD69684B19BBEE PLAN ID: 289 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ time_to_usec(now()) as collect_time, tenant_id, db_id, plan_id, outline_id, avg_exe_usec, slowest_exe_usec, slow_count, hit_count, executions, disk_reads, direct_writes, buffer_gets, application_wait_time, concurrency_wait_time, user_io_wait_time, rows_processed, elapsed_time, cpu_time, large_querys, delayed_large_querys, table_scan, timeout_count, time_to_usec(first_load_time) as first_load_time, sql_id, type, plan_hash, schema_version, 0 as merged_version, plan_size, outline_data, query_sql from V$OB_PLAN_CACHE_PLAN_STAT where (unix_timestamp(now()) - unix_timestamp(last_active_time)) < 24*3600 and tenant_id = 1002 and plan_id > 0 and object_type = 'sql_plan' order by plan_id limit 4000 SQL ID: 5E5C065BF37472A85B7A3F45B73E16F1 PLAN ID: 2686 SQL Text: SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM GV$OB_LOG_STAT WHERE tenant_id = 1002 AND ls_id = 1 ORDER BY tenant_id, ls_id, svr_ip, svr_port ASC SQL ID: 541A86125E22C2FD8708EA4CF099091F PLAN ID: 439 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ ifnull(max(request_id), 0) max_request_id, ifnull(min(request_id), 0) min_request_id from (select request_id from `v$sql_plan_monitor` where (unix_timestamp(first_refresh_time) *1000000) >= 1700229553000000 and (unix_timestamp(first_refresh_time) *1000000) < 1700229613000000 and request_id > 0 and con_id = 1001 order by request_id limit 4000) t SQL ID: EDB63B19291D5E73FE31F19A77CFD753 PLAN ID: 5068163 SQL Text: SELECT COUNT( 1 ) FROM oms_step WHERE project_id = 'np_6xj06vn8ghvk' AND step_status <> 'FINISHED' ORDER BY step_order ASC SQL ID: D802E25B0F4DD243BB4113AC55C185D8 PLAN ID: 5668 SQL Text: SELECT tenant_id, MIN(unix_timestamp(`start_time`)*1000000) AS min_start_time, MAX(unix_timestamp(`finish_time`)*1000000) AS max_finish_time, SUM(occupy_size) AS occupy_size, SUM(total_row_count) AS total_row_count, COUNT(1) AS tablet_count FROM GV$OB_TABLET_COMPACTION_HISTORY WHERE type = 'MINI_MERGE' AND unix_timestamp(`finish_time`)*1000000 > 1758048515000000 AND unix_timestamp(`finish_time`)*1000000 <= 1758050863000000 GROUP BY tenant_id; SQL ID: B4E93D9C72559EA76E19FA6AD1EE3885 PLAN ID: 13641546 SQL Text: SELECT * FROM oms_connect_info WHERE id='c_6p0x0bjv960w' SQL ID: 19A6DAA1FE8C8540A65B48C620C52D94 PLAN ID: 5068148 SQL Text: UPDATE oms_step SET step_progress=100, step_info='{\"checkpoint\":\"{\\\"OB_MYSQL_CE_ten_1_6p1eb0ns0fc0-1-0\\\":\\\"1764338487\\\"}\",\"gmt\":1764338488,\"incrTimestampCheckpoint\":1764338487}' WHERE id='s_6p3icsw32f41' SQL ID: D802E25B0F4DD243BB4113AC55C185D8 PLAN ID: 5668 SQL Text: SELECT tenant_id, MIN(unix_timestamp(`start_time`)*1000000) AS min_start_time, MAX(unix_timestamp(`finish_time`)*1000000) AS max_finish_time, SUM(occupy_size) AS occupy_size, SUM(total_row_count) AS total_row_count, COUNT(1) AS tablet_count FROM GV$OB_TABLET_COMPACTION_HISTORY WHERE type = 'MINI_MERGE' AND unix_timestamp(`finish_time`)*1000000 > 1758048515000000 AND unix_timestamp(`finish_time`)*1000000 <= 1758050863000000 GROUP BY tenant_id; SQL ID: 0AABDC9A6D53CB2B2F96419FBC587D08 PLAN ID: 13692040 SQL Text: insert into heart_beat (id ,task_type ,task_name ,task_id ,host_ip ,version, gmt_created ,gmt_modified ) values (3081860,'supervisor','supervisor', null,'10.1.251.112',null,now(),now()) , (3081861,'crawler','10.1.251.112-7100:OB_MYSQL_CE_ten_1_7857idt49krk-1-0:0000000003', 3,'10.1.251.112','/home/ds/store/store7100/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) ON DUPLICATE KEY UPDATE version = VALUES(version), gmt_modified= now() SQL ID: B6F2A13C4C81145FFAA2F2A5CF9587A9 PLAN ID: 5657 SQL Text: select /*+query_timeout(2000000)*/ a.svr_ip, a.svr_port, a.tenant_id, a.ls_id, a.role, nvl(b.weak_read_scn, 1) as weak_read_scn, nvl(b.migrate_status, 0) as migrate_status, nvl(b.tx_blocked, 0) as tx_blocked from oceanbase.__all_virtual_ls_meta_table a left join oceanbase.__all_virtual_ls_info b on a.svr_ip = b.svr_ip and a.svr_port = b.svr_port and a.tenant_id = b.tenant_id and a.ls_id = b.ls_id; SQL ID: B0BF9D6B046B5CA6261A814C99195485 PLAN ID: 635702 SQL Text: update crawler SET err_msg = '[Tue Nov 11 23:53:02 2025] DRC_500:Store OB_MYSQL_CE_np_75ocvd79fdfk_75ocxcucxx34-1-0.0000000088 started successfully\n', data_source = '1.1.1.1:1', gmt_modified = '2025-12-13 06:00:09', port = 17012, status = 0, user_data = '', name = '10.1.62.12-7106:OB_MYSQL_CE_np_75ocvd79fdfk_75ocxcucxx34-1-0:0000000088', gmt_modified=now() where name = '10.1.62.12-7106:OB_MYSQL_CE_np_75ocvd79fdfk_75ocxcucxx34-1-0:0000000088' ; SQL ID: 5E5C065BF37472A85B7A3F45B73E16F1 PLAN ID: 336 SQL Text: SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM GV$OB_LOG_STAT WHERE tenant_id = 1002 AND ls_id = 1 ORDER BY tenant_id, ls_id, svr_ip, svr_port ASC SQL ID: FA38D44B8EE5668AF6A135937672DBE4 PLAN ID: 605606 SQL Text: select id,job_id, job_name,job_type,job_version,`key_name`,`value`,scope,file_name,file_path,gmt_create,gmt_modified from connector_task_v2_config_job where job_id = 10 and `status` != -1 order by scope,id asc SQL ID: 41203FBCC0CDC03EA8646593391B644B PLAN ID: 1819870 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('363C1C29FAE7C291DC41D53CFECB88FD', '700306ABE228CC8053CB46D7FF32B24A', '56FEB17CED0B80C95C971A7F22FD656D', '6689648A7100C91463EF6CB8455CA25C', 'C57F3D6894A05C8A68FD65ECA51F2012', '48D34FDDEEC849368200B14BC128B120', '17FD41A818AC5F400FD1B9D005531385', '24F4672E2F0E2D8C9CFE61921502DEC4', 'C755B1B570070E107431C83F333AB777', 'E9E67E28B5B7CC31E67504B11A70EC3B', '445F28B7C9C144EE55ADB38265A3CE34', '30D0402D074223463288647D1E7CEBB7', 'FF541FD411EF84B105B4C5B4A8CE04FD', 'E829C3797C907E4DC21B86CDECC8C480', 'B9CCB1AADFE2B16BE59450D988407B0B', '2A2CFA54FC416AC5D72FE87CE7F7D5B3', '89D0F3171363AF8388EBBDB1D326F1A5', 'AE1E19B59F4CEB481A2F3D60F2123BF1', '4CAB412F519694C7B8623A4BDDE2CDA4') SQL ID: AA29A293AB29D1DBF60FA8D7AA80F1D4 PLAN ID: 631911 SQL Text: select uid,is_teacher,sys_pic_url,isdel,pic_url,addtime,client_id,device_id,device_name from eeo_monitor where client_class_id = 1004988305 and pic_group = 1765263031 order by addtime asc SQL ID: 58F7C45900D0B9E6293F8AFD27DC4948 PLAN ID: 636438 SQL Text: delete from ops_lock where id=303974151 SQL ID: A42720412F164B15DCCBCC20B9EDA498 PLAN ID: 13677956 SQL Text: select * from project where `status` != 'DELETED' AND status in ( 'RUNNING' , 'SUSPEND' , 'FAILED' ) SQL ID: DB9FE488781AF5A3DE810062B8A168AB PLAN ID: 2271 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id SQL ID: 000AB74A68F9141C13784CCF4E6540AF PLAN ID: 62717 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ tenant_id, 0 as tenant_id_xa, 'NULL' as trans_id, tx_id, ls_id, 'NULL' as 'partition', floor(unix_timestamp(ctx_create_time) *1000000) as ctx_create_time, session_id, participants, (case tx_type when 'DISTRIBUTED' then 2 when 'LOCAL' then 1 when 'UNDECIDED' then -1 else 0 end) as trans_type, (case action when 'START TASK' then 1 when 'END TASK' then 2 when 'COMMIT' then 3 when 'ABORT' then 4 when 'DIED' then 5 when 'END' then 6 else 0 end) as part_trans_action, -1 as sql_no, (pending_log_size + flushed_log_size) as log_size_byte, globalid from v$ob_transaction_participants where svr_ip = '10.1.43.161' and svr_port = 2882 SQL ID: 1B78F9DBE5748F02C8157BD4EEEE0ADB PLAN ID: 5669 SQL Text: SELECT SVR_IP, SVR_PORT, ZONE, CPU_CAPACITY, CPU_CAPACITY_MAX, CPU_ASSIGNED, CPU_ASSIGNED_MAX, MEM_CAPACITY, MEM_CAPACITY AS MEM_CAPACITY_MAX, MEM_ASSIGNED, MEM_ASSIGNED AS MEM_ASSIGNED_MAX, LOG_DISK_CAPACITY, LOG_DISK_ASSIGNED, LOG_DISK_IN_USE, DATA_DISK_CAPACITY, DATA_DISK_IN_USE FROM oceanbase.GV$OB_SERVERS SQL ID: E1079A872316CE723E8F39188EB30A12 PLAN ID: 1900112 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('71513ADC864560B3933BD76BBF9F8EB6', '554D8A363C6B1A2AB02323E1679D7528', '257F46D1ADDFD81AA9B34D064502D040', 'F37E55ACAD42F96375FFBC5E6A593C01', '936F64D6DFA95547E0CE5D506F6FFF3F', 'D38762995BAB84CA2DEFEF0746ED4184', '3622A4BA81540F910DCFF7D7D4B9695E', '5C4E697E17680ABD887D407E7BCEC6D6', 'C7B87AB3FC7E35A9870A32A7B41C7A41', '3BFD4AAA85D9FFF622186F3A58770B75', '09E392D03671DE169320F4DD07D1CCE4', '34DB6EAD283B79F80781CC1C5F51F933', 'C63C0A0DD054CF87C5D1B612FF185628', 'C7A3C9AD1640BBF80412D35F9F68E48E', '25996CF945272ABDA93FB4BF5B60AB6F', 'FCEA70A431EFF684FA7051A0CB21EBA0', '79C3CE2E36D52F87DEE03B5E4AD20FB2', 'CDC0CD706B6CDCBF8F72EA4E949E31CA', '847576B8D5820A25AF30C37D33B2A3FA', '2254F1B34BFC9BC86DB09D90D1B4486E', '8DC7F6DFB4B01337C87E22FB83060B7F', '363C1C29FAE7C291DC41D53CFECB88FD', '7CB27AB7076423BABBDECADEA6F264D7', '0069D08E124A596AB17FF94C2E485A6E', '059FA529214CCF480B8AE9E380F408EF', '095F2345F262D090A83FF1AC64CA8C76', '62DFB7024DCBED7E20D94826D6BBE2D2', '395A55D5FE1C200A05AB099E23D17CDD', 'C61B7EA23D376CE095A4B69D2637CCBB') SQL ID: 058277C2AE961BD3A1C607C6DC565CAB PLAN ID: 240225 SQL Text: SELECT tenant_id, name, value, gmt_create, gmt_modified FROM __all_virtual_sys_variable WHERE name = 'system_time_zone' SQL ID: DDF153DB64C2D48185C99B732CBCAA0A PLAN ID: 224 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.164' and svr_port = 2882 and sql_id in ('6EE2310B174E916664A8E07F0BE28965', '0914C45D0D3D09C1BC7DCCA77218CC71', '8C447179E0DD1CCC21228D85DA5EBA8C') SQL ID: 43BFCAA065A7ADA6269F5CD3EF991F70 PLAN ID: 337 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.164' and svr_port = 2882 and sql_id in ('4FAC5C7B309BE3663483CEB25E83788F', '87CF0314D2222245170319DA89084FE9', '5D4F31D5B6812FEA8D73500C2765C25C', '27C930D6E6FD6E71397C2429BA8F9800', '5E5C065BF37472A85B7A3F45B73E16F1', '5E5C065BF37472A85B7A3F45B73E16F1', '5E5C065BF37472A85B7A3F45B73E16F1', '646806885EB0820E98DDA8D56F90F6FD', '646806885EB0820E98DDA8D56F90F6FD', '23F67CF119E8B0B01425B8E222D0C7A3', '23F67CF119E8B0B01425B8E222D0C7A3', 'E6817292C124582E5C084C7188576316', 'E6817292C124582E5C084C7188576316') SQL ID: 5E5C065BF37472A85B7A3F45B73E16F1 PLAN ID: 336 SQL Text: SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM GV$OB_LOG_STAT WHERE tenant_id = 1002 AND ls_id = 1 ORDER BY tenant_id, ls_id, svr_ip, svr_port ASC SQL ID: 14FBAABC8D3C048B8CE7B15D62AAB926 PLAN ID: 619311 SQL Text: select id, task_id, task_name, checkpoint, gmt, gmt_create,gmt_modified from connector_task_v2_checkpoint where task_name = '10.1.62.12-9000:connector_v2:np_6p0tey84opi8-incr_trans-1-0:0000000008' limit 1 SQL ID: 3F6E5B862AA83BC02A91803A306DC91F PLAN ID: 2426 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('7C895CA99D111B696EE33230828BDCC2', 'C5D69910A0D14809BFE16B15FA624785', '9978FD3DB0A66BD6D770DF10777ED9BE', 'B76621FB57AA6CCAA9141702B6E0A49F', '57726A3273E7A0F5F82E898A2B22E7BF', '580E62F091D800FC0EFBE2E8D552F506') SQL ID: 77443A71E7BB3C4A9DE271DC4154DE21 PLAN ID: 5088482 SQL Text: SELECT pic_url,sys_pic_url,client_class_id,isdel,client_id,device_id,device_name FROM (SELECT id,pic_url,sys_pic_url,client_class_id,isdel,client_id,device_id,device_name FROM eeo_monitor WHERE client_class_id in ('1002992287','1003979499','1003175099','1003879191','1001944135','1001948299','1003733815','999089979','1000195843','1004201521','953033161','999071361','1004013159','999113337','1003144769','1003164923','1003174849','1003659411','1004162721','1000186073') ORDER BY id DESC limit 10000000000 ) AS t GROUP BY client_class_id SQL ID: EB42612376461DA9D20CC0DF9D46FEC6 PLAN ID: 62697 SQL Text: select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id as tenant_id, tenant_name, event_id, event as event_name, wait_class, total_waits, total_timeouts, time_waited * 10000 as time_waited_us from v$system_event join __all_tenant on v$system_event.con_id = __all_tenant.tenant_id and wait_class <> 'IDLE' and (con_id > 1000 or con_id = 1) SQL ID: 3FFFFF358B8A22EDCC0139B2E0C017D4 PLAN ID: 13676825 SQL Text: update host set gmt_modified=now(), congo_usage = 0,congo_book = 0,cpu_usage = 0.0,cpu_book = 0.0,jdbc_writer_usage = 16,jdbc_writer_book = 0,metaq_writer_usage = 0,metaq_writer_book = 0, full_check_book = 0, store_usage = 7,store_book = 0 ,full_check_usage = 0,ldc = null where ip='10.1.62.12' and version=88 SQL ID: FAB24109FC4A1FC372D0A08F70250395 PLAN ID: 603804 SQL Text: select * from `cluster_info` where region = 'default' limit 1 SQL ID: ACCC145FBF86D4BA2E4914FBE502B33E PLAN ID: 1988962 SQL Text: select tenant_id, table_name, table_id, tablet_id as `part_id`, (case when subpartition_name != 'NULL' then subpartition_name else partition_name end) as part_name from cdb_ob_table_locations SQL ID: 559B2646A0CA7E0CD777D4EA816C7970 PLAN ID: 1807 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('38FA58AA9AE9523560381669A2135C00', '057417C3C9767D5D83DDDFCE4FABDA08', 'B14C09E7AE18A2D25882E3E33DC29A3A', 'B69656B69C53700D745E3DF394DD0FCE', '948174BD6B672E4DAEA0BFF5934B5339', '9386EBAD8DAF170F1E7C1C4B09F3F7DB', 'F72EB1549BC0731037E110C24EF2EA77', 'B7A82826B215D5573AB71DC12BB259C0', '274915F01F00878D3F36E99D7176D4CC') SQL ID: 8E3144D3AA4A9C187036297DDE387E01 PLAN ID: 587 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('4256FE1A7BE0C815E4FF71116D462834', '2CB7972ABBE40991FDE22E76A1C92240', '0292E31C6B5BD347782CF7F6BCAAA204', '6B9C1E3E968FF97ABF3A1A990013DD2D', '139C4225F10C73D9C3C283D44CA5D68F', 'B7A6FA97FEC98C06F9586D23935AC4C6', 'BBA678D4053BE650E1C39BDC04BE99FE', 'E803A2D05DD5F4EDCF7A28783E1BB0B5') SQL ID: 9A82289E109D10E13B35DD7BB371D94E PLAN ID: 62702 SQL Text: select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ count(1) as cnt from __all_virtual_trans_stat where part_trans_action > 2 and ctx_create_time < date_sub(now(), interval 600 second) AND is_exiting != 1 and svr_ip = '10.1.43.161' and svr_port = 2882 AND trans_id NOT IN (SELECT trans_id FROM __all_virtual_global_transaction WHERE format_id <> -2 AND state = 3) SQL ID: 3F9F402B79FF72762D24E80FB387B088 PLAN ID: 5088464 SQL Text: INSERT INTO `eeo_monitor` (`school_uid`,`client_class_id`,`uid`,`is_teacher`,`pic_url`,`pic_type`,`pic_group`,`isdel`,`deltime`,`sys_pic_url`,`sys_isdel`,`sys_deltime`,`addTime`,`client_id`,`device_id`,`device_name`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) SQL ID: 3E420AC5574F4931A3554B94728BE040 PLAN ID: 602789 SQL Text: SELECT LAST_INSERT_ID() AS id SQL ID: 32387A254FB2A63976A5E3E634B8974A PLAN ID: 5012283 SQL Text: SELECT id,next_task,task_type,task_group,task_order,task_param,task_status,task_result,retry_count,max_retry_count,extra_info,gmt_create,gmt_modified FROM oms_task WHERE task_group = 's_6p0x0blt6bpf' AND task_order = '1' SQL ID: C09A3F58E144C206FB72B78FCA89E633 PLAN ID: 493 SQL Text: select (case when with_rootserver='YES' then 1 else 0 end) as with_rootserver from DBA_OB_SERVERS where svr_ip = '10.1.43.164' and svr_port = 2882 SQL ID: D7F4BE8008EF47CBFAD6A786CC252014 PLAN ID: 1988974 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ svr_ip, sql_id, tenant_id, tenant_name, user_id, user_name, db_id, db_name, plan_id, trace_id, sid, client_ip, client_port, user_client_ip, request_time, request_id, elapsed_time, execute_time, total_wait_time_micro, wait_time_micro, get_plan_time, affected_rows, return_rows, partition_cnt, ret_code, (case when ret_code = 0 then 0 else 1 end) as fail_count, (case when ret_code = -4012 then 1 else 0 end) as ret_code_4012_count, (case when ret_code = -4013 then 1 else 0 end) as ret_code_4013_count, (case when ret_code = -5001 then 1 else 0 end) as ret_code_5001_count, (case when ret_code = -5024 then 1 else 0 end) as ret_code_5024_count, (case when ret_code = -5167 then 1 else 0 end) as ret_code_5167_count, (case when ret_code = -5217 then 1 else 0 end) as ret_code_5217_count, (case when ret_code = -6002 then 1 else 0 end) as ret_code_6002_count, event, p1, p2, p3, p1text, p2text, p3text, (case event when 'system internal wait' then wait_time_micro else 0 end) as event_0_wait_time, (case event when 'mysql response wait client' then wait_time_micro else 0 end) as event_1_wait_time, (case event when 'sync rpc' then wait_time_micro else 0 end) as event_2_wait_time, (case event when 'db file data read' then wait_time_micro else 0 end) as event_3_wait_time, total_waits, rpc_count, plan_type, (case when plan_type=1 then 1 else 0 end) as plan_type_local_count, (case when plan_type=2 then 1 else 0 end) as plan_type_remote_count, (case when plan_type=3 then 1 else 0 end) as plan_type_dist_count, is_inner_sql, is_executor_rpc, is_hit_plan, consistency_level, (case when is_inner_sql=1 then 1 else 0 end) as inner_sql_count, (case when is_executor_rpc = 1 then 1 else 0 end) as executor_rpc_count, (case when is_hit_plan=1 then 0 else 1 end) as miss_plan_count, (case consistency_level when 3 then 1 else 0 end) as consistency_level_strong, (case consistency_level when 2 then 1 else 0 end) as consistency_level_weak, net_time, net_wait_time, queue_time, decode_time, application_wait_time, concurrency_wait_time, user_io_wait_time, schedule_time, row_cache_hit, bloom_filter_cache_hit, block_cache_hit, disk_reads, retry_cnt, table_scan, memstore_read_row_count, ssstore_read_row_count, query_sql, 0 as block_index_cache_hit, expected_worker_count, used_worker_count, request_memory_used, tx_id as transaction_hash, effective_tenant_id, params_value, flt_trace_id, null as format_sql_id from `V$OB_SQL_AUDIT` where tenant_id = 1 and request_id >= 3973904006 limit 4000 SQL ID: A457F30B5A761CF113D219BEC6BF2A06 PLAN ID: 13679140 SQL Text: insert into heart_beat (id ,task_type ,task_name ,task_id ,host_ip ,version, gmt_created ,gmt_modified ) values (294199254,'supervisor','supervisor', null,'10.1.62.12',null,now(),now()) , (294199255,'crawler','10.1.62.12-7106:OB_MYSQL_CE_np_75ocvd79fdfk_75ocxcucxx34-1-0:0000000088', 88,'10.1.62.12','/home/ds/store/store7106/lib64/reader/ob-ce-4.x-reader/libobcdc.so.4: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory\n5.7.11:',now(),now()) , (294199256,'crawler','10.1.62.12-7103:MYSQL_np_6p0y7nlnt5i8_6p0y842t78jk-1-0:0000000012', 12,'10.1.62.12','5.7.11',now(),now()) , (294199257,'crawler','10.1.62.12-7105:MYSQL_np_6p17tl5j1qg0_6p17u1iq2reo-1-0:0000000018', 18,'10.1.62.12','5.7.11',now(),now()) , (294199258,'crawler','10.1.62.12-7100:MYSQL_np_6p0s8ld3mxs0_6p0s91ue03ds-1-0:0000000005', 5,'10.1.62.12','5.7.11',now(),now()) , (294199259,'crawler','10.1.62.12-7102:MYSQL_np_6p0x0bkwpn7k_6p0x0svtdev4-1-0:0000000010', 10,'10.1.62.12','5.7.11',now(),now()) , (294199260,'crawler','10.1.62.12-7101:MYSQL_np_6p0x0bkwpn7k_6p0x0svtdev4-1-0:0000000009', 9,'10.1.62.12','5.7.11',now(),now()) , (294199261,'crawler','10.1.62.12-7104:MYSQL_np_6p10k2l2mi8w_6p10klubg3xc-1-0:0000000017', 17,'10.1.62.12','5.7.11',now(),now()) , (294199262,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p0rq9hpa7ts-incr_trans-1-0:0000000006', 6,'10.1.62.12',null,now(),now()) , (294199263,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p0tey84opi8-incr_trans-1-0:0000000008', 8,'10.1.62.12',null,now(),now()) , (294199264,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p0trgvh7xc0-incr_trans-1-0:0000000009', 9,'10.1.62.12',null,now(),now()) , (294199265,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p0uestckdk0-incr_trans-1-0:0000000010', 10,'10.1.62.12',null,now(),now()) , (294199266,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p0x0bkwpn7k-incr_trans-1-0:0000000013', 13,'10.1.62.12',null,now(),now()) , (294199267,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p0xsghhy3og-incr_trans-1-0:0000000015', 15,'10.1.62.12',null,now(),now()) , (294199268,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p0zl6lt3lq8-incr_trans-1-0:0000000021', 21,'10.1.62.12',null,now(),now()) , (294199269,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6p10k2l2mi8w-incr_trans-1-0:0000000023', 23,'10.1.62.12',null,now(),now()) , (294199270,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6r7qpr4oojkw-incr_trans-1-0:0000000082', 82,'10.1.62.12',null,now(),now()) , (294199271,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6ssixrush05c-incr_trans-1-0:0000000114', 114,'10.1.62.12',null,now(),now()) , (294199272,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6v5tzs9rjq1s-incr_trans-1-0:0000000136', 136,'10.1.62.12',null,now(),now()) , (294199273,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6xc6qanf9tpc-incr_trans-1-0:0000000139', 139,'10.1.62.12',null,now(),now()) , (294199275,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_6xj06vn8ghvk-incr_trans-1-0:0000000140', 140,'10.1.62.12',null,now(),now()) , (294199277,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_71cx1oq00zk0-incr_trans-1-0:0000000152', 152,'10.1.62.12',null,now(),now()) , (294199279,'CONNECTORTASKV2','10.1.62.12-9000:connector_v2:np_73kmvsq7q740-incr_trans-1-0:0000000153', 153,'10.1.62.12',null,now(),now()) ON DUPLICATE KEY UPDATE version = VALUES(version), gmt_modified= now() SQL ID: 5E5C065BF37472A85B7A3F45B73E16F1 PLAN ID: 156718 SQL Text: SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM GV$OB_LOG_STAT WHERE tenant_id = 1002 AND ls_id = 1 ORDER BY tenant_id, ls_id, svr_ip, svr_port ASC SQL ID: B326B5D4D62CA2218E7ED267E0C8E927 PLAN ID: 13679130 SQL Text: select id ,task_type ,task_name ,task_id ,host_ip ,version ,gmt_created ,gmt_modified from heart_beat where task_name = '10.1.62.14-9000:connector_v2:np_6p0k0v7yz6sg-incr_trans-1-0:0000000002' and task_type = 'CONNECTORTASKV2' order by gmt_created desc limit 1 SQL ID: BF5DA25F16BCFCDD1FAB3883B580ECD2 PLAN ID: 63131 SQL Text: SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ a.tenant_id,a.table_id,a.tablet_id,a.svr_ip,a.svr_port,c.data_table_id, data_size, required_size FROM CDB_OB_TABLE_LOCATIONS a LEFT JOIN (SELECT tenant_id,tablet_id,svr_ip,svr_port,data_size,required_size FROM __all_virtual_tablet_meta_table) b ON a.TENANT_ID = b.tenant_id AND a.tablet_id = b.tablet_id AND a.SVR_IP = b.SVR_IP AND a.SVR_PORT = b.SVR_PORT LEFT JOIN __all_virtual_table c ON a.TENANT_ID = c.TENANT_ID AND a.table_id = c.table_id SQL ID: 52D800CE55A3494600F575225F58130C PLAN ID: 63132 SQL Text: SELECT t1.con_id AS tenant_id,t1.owner AS database_name,t3.object_id AS database_id,t2.tablegroup_name,(CASE WHEN t4.object_id != 'NULL' THEN t4.object_id ELSE -1 END) AS tablegroup_id,t1.data_table_id,t1.table_name,t1.table_id,(CASE WHEN partitioned = 'NO' THEN 0 ELSE 1 END) AS part_level FROM (SELECT DISTINCT TABLE_NAME, TENANT_ID as con_id, DATABASE_NAME as OWNER, TABLE_ID, DATA_TABLE_ID, CASE WHEN PARTITION_NAME IS NULL or TABLE_ID = OBJECT_ID THEN 'NO' ELSE 'YES' END as partitioned FROM CDB_OB_TABLE_LOCATIONS group by SVR_IP, SVR_PORT, TENANT_ID, DATABASE_NAME, TABLE_NAME) t1 LEFT JOIN (SELECT tenant_id,tablegroup_name,OWNER,TABLE_NAME FROM cdb_ob_tablegroup_tables) t2 ON t1.con_id = t2.tenant_id AND t1.OWNER = t2.OWNER AND t1.TABLE_NAME = t2.TABLE_NAME LEFT JOIN (SELECT con_id,OWNER,object_name,object_id FROM CDB_OBJECTS WHERE object_type = 'database') t3 ON t1.con_id = t3.con_id AND t1.OWNER = t3.OWNER LEFT JOIN (SELECT con_id,OWNER,object_name,object_id FROM CDB_OBJECTS WHERE object_type = 'tablegroup') t4 ON t1.con_id = t4.con_id AND t2.tablegroup_name = t4.object_name SQL ID: AE1E19B59F4CEB481A2F3D60F2123BF1 PLAN ID: 4991314 SQL Text: select count(*) from connector_task_v2 where status != -1 and inner_task_type = 'incr_trans' and task_group in ( 'np_6p0xsghhy3og' ) SQL ID: FAB24109FC4A1FC372D0A08F70250395 PLAN ID: 497 SQL Text: select * from `cluster_info` where region = 'default' limit 1 SQL ID: D73B10625ABA94CCA8EAA7F1D07A36AA PLAN ID: 62701 SQL Text: SELECT MAX(timestampdiff(SECOND,ctx_create_time,CURRENT_TIMESTAMP)) as duration_seconds FROM __all_virtual_trans_stat WHERE part_trans_action <= 2 AND svr_ip = '10.1.43.161' AND svr_port = 2882 AND is_exiting != 1 AND timestampdiff(SECOND,ctx_create_time,CURRENT_TIMESTAMP) >= 30 HAVING duration_seconds IS NOT NULL SQL ID: D950AAAD6DBD4DD227884EBFAC784569 PLAN ID: 2362 SQL Text: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from V$OB_KVCACHE where svr_ip = '10.1.43.162' and svr_port = 2882 SQL ID: 5E5C065BF37472A85B7A3F45B73E16F1 PLAN ID: 2686 SQL Text: SELECT SVR_IP, SVR_PORT, ROLE, BEGIN_LSN, END_LSN FROM GV$OB_LOG_STAT WHERE tenant_id = 1002 AND ls_id = 1 ORDER BY tenant_id, ls_id, svr_ip, svr_port ASC SQL ID: AE9840194553081963DF7A7E2D68532E PLAN ID: 571 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.162' and svr_port = 2882 and sql_id in ('7C895CA99D111B696EE33230828BDCC2', 'C5D69910A0D14809BFE16B15FA624785', '57726A3273E7A0F5F82E898A2B22E7BF', '580E62F091D800FC0EFBE2E8D552F506', '9978FD3DB0A66BD6D770DF10777ED9BE', 'B76621FB57AA6CCAA9141702B6E0A49F', '1DBFC0B2F9591A44F85EA9D6D30DBACD', '00D382BB08F517937DF0583AE76B153B', '0D3625DDF2E42379F0E4326E7A68F293', 'A7A374FA64507EDBE60423F358F2793A') SQL ID: AE9840194553081963DF7A7E2D68532E PLAN ID: 33562 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('24F99F04BE210FFDF45AD14689C8F411', '079213A04FBFADF432DBF614B96CBFA0', '14E93F70D909EBF7CE53EE76BE550843', 'FE3BCC35423774BD0758B08819705FF1', 'A3AD99F5CEF1A2D961A933DE8C1581A8', '13453BEEAFBB605DB6716F1C09C02DA3', '4E652C54963ADF0C0155B0838CC3F9C2', 'F080ACED41F905BFA9553388365083F2', '3ED1377C4FB9DFB376B34717E00427F8', 'AD4CCCEE430EDC50CC9CBDC52C24827E') SQL ID: 7D609596DF9F3484BEE4E449F484B04D PLAN ID: 2191903 SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.v$active_session_history WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from oceanbase.V$OB_UNITS) t on ash.con_id = t.tenant_id group by tenant_id SQL ID: 9EF86F2CE6FBCD1D6126B49DA54631B5 PLAN ID: 619317 SQL Text: insert into connector_task_v2_checkpoint (id,task_id,task_name,checkpoint,gmt,gmt_create,gmt_modified) values (292818194,null,'10.1.62.14-9000:connector_v2:np_6p0is6tx5tz4-incr_trans-1-0:0000000001','{"OB_MYSQL_CE_np_6p0is6tx5tz4_6p0ispqjh6qo-1-0":"1764165629"}',1764165630,now(),now()) , (292818195,null,'10.1.62.14-9000:connector_v2:np_6p0k0v7yz6sg-incr_trans-1-0:0000000002','{"OB_MYSQL_CE_ten_1_6p0k14c04ixs-1-0":"1764165630"}',1764165631,now(),now()) , (292818196,null,'10.1.62.14-9000:connector_v2:np_6p0pj5o184qo-incr_trans-1-0:0000000004','{"OB_MYSQL_CE_ten_1_6p0k14c04ixs-1-0":"1764165629"}',1764165630,now(),now()) , (292818197,null,'10.1.62.14-9000:connector_v2:np_6p0qm4n8mydc-incr_trans-1-0:0000000005','{"OB_MYSQL_CE_ten_1_6p0qm8yostz4-1-0":"1764165630"}',1764165631,now(),now()) , (292818198,null,'10.1.62.14-9000:connector_v2:np_6p0ugtywiggw-incr_trans-1-0:0000000011','{"MYSQL_np_6p0ugtywiggw_6p0uh8b9iwf4-1-0":"1764165628"}',1764165628,now(),now()) , (292818199,null,'10.1.62.14-9000:connector_v2:np_6p0xogkc23og-incr_trans-1-0:0000000014','{"MYSQL_np_6p0xogkc23og_6p0xovcdew1s-1-0":"1764165629"}',1764165629,now(),now()) , (292818200,null,'10.1.62.14-9000:connector_v2:np_6p1dv7fpizuo-incr_trans-1-0:0000000027','{"OB_MYSQL_CE_np_6p1dv7fpizuo_6p1dvi5qb7i8-1-0":"1764165629"}',1764165629,now(),now()) , (292818201,null,'10.1.62.14-9000:connector_v2:np_6p4758912eqo-incr_trans-1-0:0000000033','{"OB_MYSQL_CE_ten_1_6p1eb0ns0fc0-1-0":"1764165627"}',1764165628,now(),now()) , (292818202,null,'10.1.62.14-9000:connector_v2:np_6p49enue1mv4-incr_trans-1-0:0000000036','{"OB_MYSQL_CE_ten_1_6p0qm8yostz4-1-0":"1764165628"}',1764165628,now(),now()) , (292818203,null,'10.1.62.14-9000:connector_v2:np_6p4b0stvpgkg-incr_trans-1-0:0000000038','{"OB_MYSQL_CE_ten_1_6p4adfvxsxuo-1-0":"1764165626"}',1764165627,now(),now()) , (292818204,null,'10.1.62.14-9000:connector_v2:np_6pzw1ugypssg-incr_trans-1-0:0000000045','{"OB_MYSQL_CE_ten_1_6p0qm8yostz4-1-0":"1764165628"}',1764165628,now(),now()) , (292818205,null,'10.1.62.14-9000:connector_v2:np_6qejboneu6e8-incr_trans-1-0:0000000051','{"OB_MYSQL_CE_ten_1_6p0qm8yostz4-1-0":"1764165631"}',1764165631,now(),now()) , (292818206,null,'10.1.62.14-9000:connector_v2:np_6rawxadzscww-incr_trans-1-0:0000000098','{"OB_MYSQL_CE_np_6rawxadzscww_6rawxsttophc-1-0":"1764165628"}',1764165628,now(),now()) , (292818207,null,'10.1.62.14-9000:connector_v2:np_6rdovcy051gg-incr_trans-1-0:0000000107','{"OB_MYSQL_CE_ten_1_6p0qm8yostz4-1-0":"1764165630"}',1764165631,now(),now()) , (292818208,null,'10.1.62.14-9000:connector_v2:np_6re11l5d2pk0-incr_trans-1-0:0000000108','{"OB_MYSQL_CE_np_6re11l5d2pk0_6re123mna1y8-1-0":"1764165628"}',1764165630,now(),now()) , (292818209,null,'10.1.62.14-9000:connector_v2:np_6y5lliomfyio-incr_trans-1-0:0000000141','{"OB_MYSQL_CE_ten_1_6y5llsm6rg68-1-0":"1764165630"}',1764165631,now(),now()) , (292818210,null,'10.1.62.14-9000:connector_v2:np_75ocvd79fdfk-incr_trans-1-0:0000000155','{"OB_MYSQL_CE_np_75ocvd79fdfk_75ocxcucxx34-1-0":"1764165627"}',1764165629,now(),now()) , (292818211,null,'10.1.62.14-9000:connector_v2:np_75ukjbg5ycyo-incr_trans-1-0:0000000156','{"OB_MYSQL_CE_ten_1_6p0qm8yostz4-1-0":"1764165630"}',1764165630,now(),now()) , (292818212,null,'10.1.62.14-9000:connector_v2:np_784rgpyzzk1s-incr_trans-1-0:0000000158','{"OB_MYSQL_CE_ten_1_6p1eb0ns0fc0-1-0":"1764165628"}',1764165629,now(),now()) ON DUPLICATE KEY UPDATE gmt_modified=now(), checkpoint=VALUES(checkpoint), gmt=VALUES(gmt) SQL ID: 1CD6EBE44F821D58FBFA3314B97486F9 PLAN ID: 2747 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = '10.1.43.161' and svr_port = 2882 and sql_id in ('D86DF6B70C588D8E5B44E96085498528', '18DD1ED57C3C49AAA4AEDBE94B152AC5', '16F996F2F27930032410A70F41A5B077', '4256FE1A7BE0C815E4FF71116D462834', '2CB7972ABBE40991FDE22E76A1C92240', '0292E31C6B5BD347782CF7F6BCAAA204', '6B9C1E3E968FF97ABF3A1A990013DD2D') ## Top Sessions: - ''# Samples Active'' shows the number of ASH samples in which the blocking session was found active. +--------------------+----------------------+----------------------------------------+------------+------------------------------+--------------------+------------------------------+ | Sid| % Activity| Event| Event Count| % Event| User| # Samples Active| +--------------------+----------------------+----------------------------------------+------------+------------------------------+--------------------+------------------------------+ | 3221811136| 0.94%| CPU + Wait for CPU| 5| 0.94%| ocp_monitor| 5/592[0.84%]| | 3221512745| 0.75%| CPU + Wait for CPU| 4| 0.75%| ocp_monitor| 4/592[0.68%]| | 3221777167| 0.75%| CPU + Wait for CPU| 4| 0.75%| ocp_monitor| 4/592[0.68%]| | 3221515317| 0.75%| CPU + Wait for CPU| 4| 0.75%| ocp_monitor| 4/592[0.68%]| | 3222499224| 0.75%| CPU + Wait for CPU| 4| 0.75%| ocp_monitor| 4/592[0.68%]| | 3221672200| 0.75%| CPU + Wait for CPU| 4| 0.75%| ocp_monitor| 4/592[0.68%]| | 3221939541| 0.75%| CPU + Wait for CPU| 4| 0.75%| ocp_monitor| 4/592[0.68%]| | 3222488866| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221489068| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221786284| 0.57%| px loop condition wait| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221879798| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221839972| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221667053| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3222397234| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3222436034| 0.57%| CPU + Wait for CPU| 3| 0.57%| | 3/592[0.51%]| | 3221798749| 0.57%| px loop condition wait| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221939146| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3222341953| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3222424609| 0.57%| CPU + Wait for CPU| 3| 0.57%| | 3/592[0.51%]| | 3221900719| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221988361| 0.57%| CPU + Wait for CPU| 3| 0.57%| ocp_monitor| 3/592[0.51%]| +--------------------+----------------------+----------------------------------------+------------+------------------------------+--------------------+------------------------------+ ## Top Blocking Sessions: - Blocking session activity percentages are calculated with respect to waits on latches and locks only. - ''# Samples Active'' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall time. +--------------------+----------------------+----------------------------------------+------------+------------------------------+--------------------+------------------------------+ | Blocking Sid| % Activity| Event Caused| Event Count| % Event| User| # Samples Active| +--------------------+----------------------+----------------------------------------+------------+------------------------------+--------------------+------------------------------+ | 3221798749| 0.57%| px loop condition wait| 3| 0.57%| ocp_monitor| 3/592[0.51%]| | 3221786284| 0.57%| px loop condition wait| 3| 0.57%| ocp_monitor| 3/592[0.51%]| +--------------------+----------------------+----------------------------------------+------------+------------------------------+--------------------+------------------------------+ ## Top latches: +----------------------------------------+--------------------+--------------------+ | Latch| Sampled Count| % Activity| +----------------------------------------+--------------------+--------------------+ +----------------------------------------+--------------------+--------------------+ ## Node Load: +----------------------------------------+--------------------+--------------------+--------------------+------------------------------+ | SVR IP| SVR PORT| Sampled Count| Idle Wait Count| Load| +----------------------------------------+--------------------+--------------------+--------------------+------------------------------+ | 10.1.43.164| 2882| 161| 1| 0.27| | 10.1.43.162| 2882| 188| 0| 0.32| | 10.1.43.161| 2882| 181| 0| 0.31| +----------------------------------------+--------------------+--------------------+--------------------+------------------------------+