obdiag version: 3.7.2 observer version: 4.2.5.5 ASH Report Cluster Name: eeoob012 Observer Version: OceanBase_CE 4.2.5.5 (105000032025071717-5a7fbc0449701109376a16260785c61c36989d8e) Operation System Info: Linux(4.14.141-2.el7.x86_64)_x86_64 User Input Begin Time: 2025-12-30 09:30:00 User Input End Time: 2025-12-30 10:30:00 Wr Analysis Begin Time: 2025-12-30 09:30:02 Wr Analysis End Time: 2025-12-30 10:29:59 Wr Data Source: oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY Elapsed Time: 3596 Wr Num of Sample: 7300 Average Active Sessions: 2.03 Top Active Tenants: - this section lists top active tenant information - Total Samples: num of records during ash report analysis time period - Wait Event Samples: num of records when session is on wait event - On CPU Samples: num of records when session is on cpu - Avg Active Sessions: average active sessions during ash report analysis time period - % Activity: activity(cpu + wait) percentage for given tenant - Equivalent Client Load: equivalent client average active sessions during ash report analysis time period +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | Tenant Name|Session Type| Total Samples| Wait Event Samples| On CPU Samples| Avg Active Sessions| % Activity| Equivalent Client Load| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | flowin| FOREGROUND| 5430| 1070| 4360| 1.51| 74.38%| 1.00| | sys| FOREGROUND| 1870| 400| 1470| 0.52| 25.62%| 0.97| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ Top Node Load: - this section lists top node measured by DB time - IP: OceanBase instance svr_ip - Port: OceanBase instance svr_port - Total Samples: num of records during ash report analysis time period - Wait Event Samples: num of records when session is on wait event - On CPU Samples: num of records when session is on cpu - Avg Active Sessions: average active sessions during ash report analysis time period - % Activity: activity(cpu + wait) percentage for given tenant - Equivalent Client Load: equivalent client average active sessions during ash report analysis time period +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | IP| Port|Session Type| Total Samples| Wait Event Samples| On CPU Samples| Avg Active Sessions| % Activity| Equivalent Client Load| +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | 10.1.43.153| 2882| FOREGROUND| 2710| 530| 2180| 0.75| 37.12%| 0.00| | 10.1.43.152| 2882| FOREGROUND| 2540| 480| 2060| 0.71| 34.80%| 0.00| | 10.1.43.151| 2882| FOREGROUND| 2050| 460| 1590| 0.57| 28.08%| 0.00| +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ Top Groups: - this section lists top resource consumer groups - Group Name: resource consumer group name - Group Samples: num of sampled session activity records in the current resource group - % Activity: activity percentage for given event resource group - Avg Active Sessions: average active sessions during ash report analysis time period +----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+ | Node| Group Name|Group Samples| % Activity| Program| % Program| Module| % Module| Action| % Action| Avg Active Sessions| +----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+ | 10.1.43.153:2882| cgroup//tenant_1002//OBCG_DEFAULT| 2050| 28.08%| UNDEFINED| 28.08%| UNDEFINED| 28.08%| UNDEFINED| 28.08%| 0.57| | | cgroup//tenant_0001//OBCG_DEFAULT| 660| 9.04%| UNDEFINED| 9.04%| UNDEFINED| 9.04%| UNDEFINED| 9.04%| 0.18| | 10.1.43.152:2882| cgroup//tenant_1002//OBCG_DEFAULT| 1930| 26.44%| UNDEFINED| 26.44%| UNDEFINED| 26.44%| UNDEFINED| 26.44%| 0.54| | | cgroup//tenant_0001//OBCG_DEFAULT| 610| 8.36%| UNDEFINED| 8.36%| UNDEFINED| 8.36%| UNDEFINED| 8.36%| 0.17| | 10.1.43.151:2882| cgroup//tenant_1002//OBCG_DEFAULT| 1450| 19.86%| UNDEFINED| 19.86%| UNDEFINED| 19.86%| UNDEFINED| 19.86%| 0.40| | | cgroup//tenant_0001//OBCG_DEFAULT| 600| 8.22%| UNDEFINED| 8.22%| UNDEFINED| 8.22%| UNDEFINED| 8.22%| 0.17| +----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+ +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ | Slot Begin Time| Slot Count| Action Key| Action Samples| % Activity| Avg Active Sessions| +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ Top Foreground DB Time: - This section lists top foreground db time categorized by event - Event Name: comprise wait event and on cpu event - Event Samples: num of sampled session activity records - % Activity: activity percentage for given event - Avg Active Sessions: average active sessions during ash report analysis time period +----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+--------------------+-----------+ | Node| Event Name| Wait Class|Event Samples| Avg Active Sessions| % Activity| +----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+--------------------+-----------+ | 10.1.43.153:2882| ON CPU| NULL| 2180| 0.61| 29.86%| | | | | 340| 0.10| 4.66%| | | | | 120| 0.03| 1.64%| | | | | 30| 0.01| 0.41%| | | | | 20| 0.01| 0.27%| | | | | 10| 0.00| 0.14%| | | | | 10| 0.00| 0.14%| | 10.1.43.152:2882| ON CPU| NULL| 2060| 0.57| 28.22%| | | | | 270| 0.07| 3.70%| | | | | 90| 0.03| 1.23%| | | | | 70| 0.02| 0.96%| | | | | 50| 0.01| 0.69%| | 10.1.43.151:2882| ON CPU| NULL| 1590| 0.44| 21.78%| | | | | 350| 0.10| 4.79%| | | | | 70| 0.02| 0.96%| | | | | 30| 0.01| 0.41%| | | | | 10| 0.00| 0.14%| +----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+--------------------+-----------+ Top Background DB Time: - this section lists top DB Time for background sessions - Program: process name for background sessions - Event Name: comprise wait event and on cpu event - Event Samples: num of sampled session activity records - % Activity: activity percentage for given event - Avg Active Sessions: average active sessions during ash report analysis time period +----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ | Node| Program| Module| Action| Event Name| Wait Class|Event Samples| % Activity| Avg Active Sessions| +----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ +----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ Top Sessions: - this section lists top Active Sessions with the largest wait event and SQL_ID - Session ID: user session id - % Activity: represents the load on the database caused by this session - Avg Active Sessions: average active sessions during ash report analysis time period - Event Name: comprise wait event and on cpu event - % Event: represents the activity load of the event on the database - % SQL ID: represents the activity load of the event on the database - Sql Executions: represents the execution count of the SQL_ID +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ | Node| Session ID| Program| % Activity| Avg Active Sessions| Event Name| Wait Class| % Event| SQL ID| Plan Hash| % SQL ID| Sql Executions| +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ | 10.1.43.151:2882| 3222496970| | 0.55%| 0.01| ON CPU| NULL| 0.55%| 35BF6604DD6AFB8D23AE0633C5AC8527| 0| 0.27%| 2| | 10.1.43.151:2882| 3222369521| | 0.41%| 0.01| ON CPU| NULL| 0.41%| 50B3BC5AE8BA9510F91CBDFAE02DAE58| 0| 0.27%| 2| | 10.1.43.151:2882| 3222419903| | 0.41%| 0.01| ON CPU| NULL| 0.41%| 35BF6604DD6AFB8D23AE0633C5AC8527| 0| 0.27%| 2| | 10.1.43.151:2882| 3222429107| | 0.41%| 0.01| ON CPU| NULL| 0.41%| 030572EB4329CBF0455B3394248CF702| 0| 0.14%| 1| | 10.1.43.151:2882| 3222479910| | 0.41%| 0.01| | | 0.41%| 55C3E17DD1242A38678CEB6F52A83FEE| 0| 0.41%| 3| | 10.1.43.151:2882| 3222501441| | 0.41%| 0.01| ON CPU| NULL| 0.41%| 661F8B1C39FA18B9BE8DAC293DA563C2| 0| 0.14%| 1| | 10.1.43.152:2882| 3222638830| | 0.41%| 0.01| ON CPU| NULL| 0.41%| 7FB434B0A0E107BC5B12D0E7DF6A3855| 0| 0.14%| 1| | 10.1.43.151:2882| 3222323269| | 0.27%| 0.01| ON CPU| NULL| 0.14%| 45E78F492D8BCE36FBDB8AC2C66836E8| 0| 0.14%| 1| | 10.1.43.151:2882| 3222394837| | 0.27%| 0.01| ON CPU| NULL| 0.27%| 35BF6604DD6AFB8D23AE0633C5AC8527| 0| 0.27%| 2| | 10.1.43.151:2882| 3222412357| | 0.27%| 0.01| ON CPU| NULL| 0.27%| 35BF6604DD6AFB8D23AE0633C5AC8527| 0| 0.27%| 2| | 10.1.43.152:2882| 3222665135| | 0.27%| 0.01| ON CPU| NULL| 0.27%| 65D3F5BF2B8448B0CFDD69684B19BBEE| 0| 0.14%| 1| | 10.1.43.152:2882| 3222788404| | 0.27%| 0.01| ON CPU| NULL| 0.27%| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 0| 0.14%| 1| | 10.1.43.153:2882| 3222813590| | 0.27%| 0.01| ON CPU| NULL| 0.14%| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 0| 0.14%| 1| | 10.1.43.153:2882| 3222901093| | 0.27%| 0.01| ON CPU| NULL| 0.27%| AB083679B928CF882A1E38A28C822ED4| 0| 0.14%| 1| | 10.1.43.153:2882| 3222901364| | 0.27%| 0.01| ON CPU| NULL| 0.27%| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 0| 0.14%| 1| +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ Top IO Bandwidth: - This section lists the top io bandwidth from the perspective of SQL and background tasks - Node: The IP address and port number of the observer - Program Module Action / SQL ID: Program Module Action represent the type of background tasks, which is only effective in background tasks. And SQL ID is only effective in foreground tasks - Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks. - IOPS: Average IO requests executed per second - IO Size: The total read or write size(MB) of background task or SQL - IO Bandwidth: Average IO size(MB) consumed per second - Type: read or write - Object ID: The tablet_id with the highest read or write bytes - % Object ID: The ratio of the tablet_id with the highest read or write bytes to the total bytes of tablet_ids in entire background task or SQL +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------+----------------+--------------------+--------------------+----------+------------+ | Node| Program Module Action / SQL ID| Plan Hash| Type| IOPS| IO Size(MB)| IO Bandwidth(MB/s)| Object ID| % Object ID| +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------+----------------+--------------------+--------------------+----------+------------+ +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------+----------------+--------------------+--------------------+----------+------------+ Top Blocking Sessions: - Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only. - '% Activity' represents the load on the database caused by a particular blocking session. - '# Avg Active Sessions' shows the number of ASH samples in which the blocking session was found active. +---------------------+--------------------+--------------------+----------------------------------------------------------------+---------------------+----------------------------------------+----------------------------------------------------------------+--------------------+--------------------+----------------------------------------+--------------------+ | Blocking Session ID| % Activity| Avg Active Sessions| Holder User| Holder TX ID| Holder SQL ID| Event Caused| % Event| XIDs| Top Waitting SQL ID| % SQL ID| +---------------------+--------------------+--------------------+----------------------------------------------------------------+---------------------+----------------------------------------+----------------------------------------------------------------+--------------------+--------------------+----------------------------------------+--------------------+ +---------------------+--------------------+--------------------+----------------------------------------------------------------+---------------------+----------------------------------------+----------------------------------------------------------------+--------------------+--------------------+----------------------------------------+--------------------+ Top Latchs: - this section lists top latches - Latch Wait Event: event that waiting for latch - Event Samples: num of sampled session activity records - % Activity: activity percentage for given event - Avg Active Sessions: average active sessions during ash report analysis time period +----------------------------------------------------------------+-------------+-----------+--------------------+ | Latch Wait Event|Event Samples| % Activity| Avg Active Sessions| +----------------------------------------------------------------+-------------+-----------+--------------------+ +----------------------------------------------------------------+-------------+-----------+--------------------+ Top DB Objects: - With respect to Application, Cluster, User I/O and buffer busy waits only. - Object ID: tablet_id of the database table. - Avg Active Sessions: average active sessions during ash report analysis time period. - % Activity:the load on the database caused by accessing the databsae object. - Execution Count:represents how many executions involve this object - Event:When accessing the object, the corresponding Top waiting events (up to 5 are printed). - % Event:The percentage of the corresponding Top wait events when accessing the object (up to 5 events are printed). - SQL ID:the SQL ID with the highest load when accessing the object and in the wait event. - %SQL ID/Module:The percentage of SQL ID or Module with the highest load in this wait event when accessing the object. - Object Name (Type/ Partition Name):the name and type/partition_name of the database object being accessed +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ | Node Address| Tenant ID| Object ID| Avg Active Sessions| % Activity| Execution Count| Event| % Event| SQL ID| %SQL ID/Module| Object Name (Type/Partition Name)| +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ Activity Over Time: - this section lists time slot information during the analysis period. - The numbers in parentheses represent the time (in seconds) that has passed since the beginning and end stages. - Slot Begin Time: current slot's begin time. current slot end with next slot begin time. - Event Name: comprise wait event and on cpu event. - Event Samples: num of sampled session activity records. - % Activity: activity percentage for given event. - Avg Active Sessions: average active sessions during ash report analysis time period. +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ | Slot Begin Time| Slot Count| Event Name| Wait Class|Event Samples| % Activity| Avg Active Sessions| +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ | 2025-12-30 09:30:02(+358s)| 590| ON CPU| NULL| 480| 81.36%| 1.34| | | | | | 110| 18.64%| 0.31| | 2025-12-30 09:36:00| 600| ON CPU| NULL| 500| 83.33%| 1.39| | | | | | 100| 16.67%| 0.28| | 2025-12-30 09:42:00| 660| ON CPU| NULL| 480| 72.73%| 1.33| | | | | | 180| 27.27%| 0.50| | 2025-12-30 09:48:00| 530| ON CPU| NULL| 430| 81.13%| 1.19| | | | | | 100| 18.87%| 0.28| | 2025-12-30 09:54:00| 780| ON CPU| NULL| 650| 83.33%| 1.81| | | | | | 130| 16.67%| 0.36| | 2025-12-30 10:00:00| 840| ON CPU| NULL| 620| 73.81%| 1.72| | | | | | 220| 26.19%| 0.61| | 2025-12-30 10:06:00| 780| ON CPU| NULL| 640| 82.05%| 1.78| | | | | | 140| 17.95%| 0.39| | 2025-12-30 10:12:00| 820| ON CPU| NULL| 650| 79.27%| 1.81| | | | | | 170| 20.73%| 0.47| | 2025-12-30 10:18:00| 820| ON CPU| NULL| 690| 84.15%| 1.92| | | | | | 130| 15.85%| 0.36| | 2025-12-30 10:24:00(+359s)| 880| ON CPU| NULL| 690| 78.41%| 1.92| | | | | | 190| 21.59%| 0.53| +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ Top Execution Phase: - this section lists top phases of execution, such as SQL, PL/SQL, STORAGE, etc. +------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+ |Session Type| Phase of Execution| Active Samples| % Activity| SQL_ID| % SQL_ID| +------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+ | FOREGROUND| IN_SQL_EXECUTION| 5620| 76.99%| E6817292C124582E5C084C7188576316| 11.92%| | | IN_STORAGE_READ| 1870| 25.62%| 35BF6604DD6AFB8D23AE0633C5AC8527| 3.70%| | | IN_PX_EXECUTION| 1570| 21.51%| E6817292C124582E5C084C7188576316| 8.63%| | | IN_COMMITTING| 1010| 13.84%| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 3.70%| | | IN_STORAGE_WRITE| 630| 8.63%| 098BAD61386BE331830503F854E8DB61| 2.33%| | | IN_PLAN_CACHE| 350| 4.79%| 095F2345F262D090A83FF1AC64CA8C76| 0.69%| | | IN_REMOTE_DAS_EXECUTION| 60| 0.82%| BD726868E1EF777297E6D256C939FEF6| 0.55%| | | IN_PARSE| 50| 0.69%| 2FD45F34AA6A412A55010FB665262699| 0.27%| +------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+ Top IO Events: - This section lists the top io event from the perspective of SQL and background tasks - Node: The IP address and port number of the observer - Program Module Action / SQL ID: Program Module Action represent the type of background tasks, which is only effective in background tasks. And SQL ID is only effective in foreground tasks - Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks - IO Event Samples: The total samples of io wait event during task execution. - %IO Event Samples: The proportion of total io wait event samples among all sampled points - Top Event: The top io wait event name. - IO Type: The type of io wait event. - % EVENT: activity percentage for the io wait event. - Enqueue Time: The total time(in seconds) spent queuing for I/O requests. - Device Time: The total time (in seconds) spent executing I/O requests on the device. - Callback Time: The total time (in seconds) spent executing callbacks for I/O requests. +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ | Node| Program Module Action / SQL ID| Plan Hash| IO Event Samples| %IO Event Samples| Top Event| IO Type| % EVENT| Enqueue Time(S)| Device Time(S)| Callback Time(S)| +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ Top SQL Statement Types: - this section lists top sql statement type. - SQL Statement Type: SQL statement types such as SELECT or UPDATE - Total Samples: num of records during ash report analysis time period - % Event: activity percentage of records when session is on wait event - % On CPU: activity percentage of records when session is on cpu - % Activity: activity(cpu + wait) percentage for given tenant - Node: the server address where the statement was executed +---------------------------------------------+---------------------+---------------------+---------------------+----------------------------------------------------------------+---------------------+---------------------+---------------------+ | SQL Statement Type| Total Samples| % Activity| Sampled Executions| Node| % Node| % On CPU| % Event| +---------------------------------------------+---------------------+---------------------+---------------------+----------------------------------------------------------------+---------------------+---------------------+---------------------+ | T_NONE| 7300| 100.00%| 265| 10.1.43.153:2882| 37.12%| 29.86%| 7.26%| | | | | | 10.1.43.152:2882| 34.80%| 28.22%| 6.58%| | | | | | 10.1.43.151:2882| 28.08%| 21.78%| 6.30%| +---------------------------------------------+---------------------+---------------------+---------------------+----------------------------------------------------------------+---------------------+---------------------+---------------------+ Top SQL with Top Events: - This Section lists the SQL statements that accounted for the highest percentages event. - Plan Hash: Numeric representation of the current SQL plan - Active Samples: num of samples for top current SQL - % Activity: activity percentage for given SQL ID - Sampled Executions: represents the number of times the current SQL execution has been sampled - Top Event: top event name for current SQL plan - % Event: activity percentage for current SQL plan - Top Operator/ExecPhase: top operator name or execution phase for current event - % Operator/ExecPhase: activity percentage for given operator +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ | SQL ID| Plan Hash| Active Samples| % Activity| Sampled Executions| Top Event| % Event| Top Operator/ExecPhase| % Operator/ExecPhase| SQL Text| +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ | E6817292C124582E5C084C7188576316| 0| 870| 11.92%| 86| ON CPU| 8.63%| UNDEFINED| 8.63%| SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (a| | | | | | | | 3.29%| UNDEFINED| 3.29%| | | A33DD674E9EC4DEE0C2F3E0640D7EBC4| 0| 480| 6.58%| 48| ON CPU| 5.75%| IN_COMMITTING| 3.70%| INSERT IGNORE INTO node(n_id, n_type, n_userId, n_colle| | | | | | | | 0.82%| UNDEFINED| 0.82%| | | 7D609596DF9F3484BEE4E449F484B04D| 0| 460| 6.30%| 46| ON CPU| 4.25%| UNDEFINED| 4.25%| SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COAL| | | | | | | | 2.06%| UNDEFINED| 2.06%| | | 54A8B0E0FCD6397C5706051E7CE315FD| 0| 340| 4.66%| 34| ON CPU| 2.33%| IN_SQL_EXECUTION| 1.64%| SELECT crq_request_id,crq_channel,crq_loop_flag,crq_age| | | | | | | | 1.92%| UNDEFINED| 1.92%| | | | | | | | | 0.27%| IN_SQL_EXECUTION| 0.27%| | | | | | | | | 0.14%| IN_SQL_EXECUTION| 0.14%| | | 2FD45F34AA6A412A55010FB665262699| 0| 320| 4.38%| 32| ON CPU| 4.25%| IN_COMMITTING| 3.15%| INSERT IGNORE INTO co_data_snapshot(cds_codataId, cds_v| | | | | | | | 0.14%| UNDEFINED| 0.14%| | | F898845B5825FBCD7C4CC8F67188DB9D| 0| 310| 4.25%| 31| ON CPU| 4.25%| IN_COMMITTING| 3.29%| INSERT IGNORE INTO collection_node_snapshot(' cn| | 098BAD61386BE331830503F854E8DB61| 0| 290| 3.97%| 29| ON CPU| 3.97%| UNDEFINED| 3.29%| INSERT IGNORE INTO node_reference(' nr_toCollect| | 35BF6604DD6AFB8D23AE0633C5AC8527| 0| 270| 3.70%| 27| ON CPU| 3.70%| UNDEFINED| 3.70%| SELECT ajq_id,ajq_channel,ajq_provider,ajq_type,ajq_ret| | 030572EB4329CBF0455B3394248CF702| 0| 260| 3.56%| 26| ON CPU| 3.42%| UNDEFINED| 2.06%| SELECT cns_data, cns_nodeVersion,cns_collectionVersion,| | | | | | | | 0.14%| UNDEFINED| 0.14%| | | AB083679B928CF882A1E38A28C822ED4| 0| 240| 3.29%| 24| | 1.78%| UNDEFINED| 1.78%| SELECT cds_version, cds_data FROM co_data_snapshot WHER| | | | | | | ON CPU| 1.51%| IN_SQL_EXECUTION| 0.96%| | | 285CAFF5C0BA6433FA3AC0E37219729C| 0| 180| 2.47%| 18| ON CPU| 1.23%| UNDEFINED| 0.41%| SELECT COUNT(*) as total FROM page_screenshot_queue' | | | | | | | | 0.55%| UNDEFINED| 0.55%| | | | | | | | | 0.41%| IN_PX_EXECUTION| 0.41%| | | | | | | | | 0.27%| IN_SQL_EXECUTION| 0.27%| | | 45E78F492D8BCE36FBDB8AC2C66836E8| 0| 150| 2.06%| 15| | 1.23%| UNDEFINED| 1.23%| SELECT psq_node_id, psq_collection_id, psq_collection_v| | | | | | | ON CPU| 0.82%| IN_SQL_EXECUTION| 0.14%| | | 5AD7FA60283581F9C84102E49CE12B06| 0| 150| 2.06%| 14| ON CPU| 1.23%| IN_SQL_EXECUTION| 0.82%| SELECT c_id, c_app, c_rootNode, c_status FROM collectio| | | | | | | | 0.82%| UNDEFINED| 0.82%| | | | 0| 140| 1.92%| 1| ON CPU| 1.92%| IN_SQL_EXECUTION| 0.27%| UNDEFINED| | BD726868E1EF777297E6D256C939FEF6| 0| 120| 1.64%| 12| ON CPU| 1.37%| IN_STORAGE_WRITE| 1.23%| REPLACE INTO node_relation(' nr_nodeId, nr_pare| | | | | | | | 0.27%| UNDEFINED| 0.27%| | | 2F7DB8BAE2DBBD7ED0456710D2D350C8| 0| 120| 1.64%| 12| ON CPU| 1.10%| IN_SQL_EXECUTION| 0.69%| SELECT nvcq_channel_id,nvcq_collection_id,nvcq_collecti| | | | | | | | 0.41%| UNDEFINED| 0.41%| | | | | | | | | 0.14%| IN_SQL_EXECUTION| 0.14%| | | F9912F51D0D693AB9CE1B147F090C0A7| 0| 120| 1.64%| 12| ON CPU| 1.64%| IN_SQL_EXECUTION| 1.10%| SELECT cns_data, cns_nodeVersion, cns_collectionVersion| | 55C3E17DD1242A38678CEB6F52A83FEE| 0| 110| 1.51%| 11| ON CPU| 0.82%| UNDEFINED| 0.55%| SELECT' br_id, br_group_id, br_type, br_expire_time, b| | | | | | | | 0.69%| UNDEFINED| 0.69%| | | 4856DCEDAB4C1494C749283B3F2371D0| 0| 100| 1.37%| 10| ON CPU| 1.37%| UNDEFINED| 0.69%| SELECT nr_fromCollectionId, nr_fromNodeId, nr_copyId, n| | B909B740439B4B8747970DF4F762EEBB| 0| 100| 1.37%| 10| ON CPU| 1.37%| IN_SQL_EXECUTION| 1.23%| SELECT nr_toNodeId, nr_fromCollectionId, nr_fromCollect| | E79974DE56340B099DE55BEA08DECEFD| 0| 90| 1.23%| 9| ON CPU| 1.23%| IN_SQL_EXECUTION| 1.10%| select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */' | | A67AD996E76A98B85BF7BE4BD6DFBEDB| 0| 90| 1.23%| 9| ON CPU| 0.82%| IN_SQL_EXECUTION| 0.55%| SELECT SUM(nuh_update_count) AS update_count, nrc_colle| | | | | | | | 0.14%| IN_PX_EXECUTION| 0.14%| | | | | | | | | 0.14%| IN_SQL_EXECUTION| 0.14%| | | | | | | | | 0.14%| UNDEFINED| 0.14%| | | CAD55628BA4BC4035A77BF7DCE33A904| 0| 80| 1.10%| 8| ON CPU| 0.69%| UNDEFINED| 0.55%| SELECT cdu_version, cdu_userId, cdu_src, cdu_seq, cdu_c| | | | | | | | 0.41%| UNDEFINED| 0.41%| | | 095F2345F262D090A83FF1AC64CA8C76| 0| 80| 1.10%| 8| ON CPU| 1.10%| IN_PLAN_CACHE| 0.69%| SELECT ?| | FC5F38AA6F5F7B2082CCB180CE16D743| 0| 80| 1.10%| 8| ON CPU| 0.82%| UNDEFINED| 0.69%| SELECT' br_id, br_group_id, br_type, br_expire_time,| | | | | | | | 0.27%| UNDEFINED| 0.27%| | +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ Top SQL with Top Operator: - This Section lists the SQL statements that accounted for the highest percentages of sampled session activity with sql operator - Plan Hash: Numeric representation of the current SQL plan - Active Samples: num of samples for top current SQL - % Activity: activity percentage for given SQL ID - Sampled Executions: represents the number of times the current SQL execution has been sampled - Top Operator: top operator name for current SQL plan - % Operator: activity percentage for given operator - Top Event: top event name for current operator - % Event: activity percentage for given event +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ | SQL ID| Plan Hash|Active Samples| % Activity| Sampled Executions| Top Operator| % Operator| Top Event| % Event| SQL Text| +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ Top PL/SQL Procedures: - "PL/SQL Entry Subprogram" represents the application's top-level entry-point(procedure, function, trigger, package initialization) into PL/SQL. - "PL/SQL Current Subprogram" is the pl/sql subprogram being executed at the point of sampling. If the value is "SQL", it represents the percentage of time spent executing SQL for the particular plsql entry subprogram. - "PL/SQL Entry Subprogram" represents the application's top-level subprogram name +------------------------------------------------------------+--------------------+------------------------------------------------------------+--------------------+ | PLSQL Entry Subprogram| % Activity| PLSQL Current Subprogram| % Current| +------------------------------------------------------------+--------------------+------------------------------------------------------------+--------------------+ +------------------------------------------------------------+--------------------+------------------------------------------------------------+--------------------+ Complete List of SQL Text: SQL ID: 54A8B0E0FCD6397C5706051E7CE315FD SQL Text: SELECT crq_request_id,crq_channel,crq_loop_flag,crq_age_ms,crq_create_at,crq_expired_at FROM ( SELECT crq_request_id,crq_channel,crq_loop_flag,crq_age_ms,crq_create_at,crq_expired_at, row_number() over ( partition by crq_channel order by crq_expired_at ASC ) AS rank FROM converter_request_queue WHERE crq_channel in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND crq_expired_at <= ? ) AS T WHERE rank = ? SQL ID: BD726868E1EF777297E6D256C939FEF6 SQL Text: REPLACE INTO node_relation( nr_nodeId, nr_parentId, nr_collectionVersion, nr_status ) VALUES (?,?,?,?) SQL ID: A33DD674E9EC4DEE0C2F3E0640D7EBC4 SQL Text: INSERT IGNORE INTO node(n_id, n_type, n_userId, n_collectionId) VALUES(?,?,?,?) SQL ID: 45E78F492D8BCE36FBDB8AC2C66836E8 SQL Text: SELECT psq_node_id, psq_collection_id, psq_collection_version FROM page_screenshot_queue WHERE psq_status = ? ORDER BY psq_update_at DESC LIMIT ? SQL ID: 285CAFF5C0BA6433FA3AC0E37219729C SQL Text: SELECT COUNT(*) as total FROM page_screenshot_queue WHERE psq_status = ? SQL ID: 2F7DB8BAE2DBBD7ED0456710D2D350C8 SQL Text: SELECT nvcq_channel_id,nvcq_collection_id,nvcq_collection_version,nvcq_create_at,nvcq_expired_at,nvcq_loop_flag,nvcq_age_ms FROM ( SELECT nvcq_channel_id,nvcq_collection_id,nvcq_collection_version,nvcq_create_at,nvcq_expired_at,nvcq_loop_flag,nvcq_age_ms, row_number() over ( partition by nvcq_collection_id order by nvcq_expired_at ASC ) AS rank FROM collection_version_creating_queue JOIN server_version_on_collection ON nvcq_collection_id = svoc_collection_id WHERE nvcq_channel_id in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND nvcq_expired_at <= ? AND svoc_cluster_version = ? ) AS T WHERE rank = ? SQL ID: 2FD45F34AA6A412A55010FB665262699 SQL Text: INSERT IGNORE INTO co_data_snapshot(cds_codataId, cds_version, cds_data) VALUES(?,?,?) SQL ID: F898845B5825FBCD7C4CC8F67188DB9D SQL Text: INSERT IGNORE INTO collection_node_snapshot( cns_collectionId, cns_collectionVersion, cns_nodeId, cns_nodeVersion, cns_data, cns_beginVersion ) VALUES (?,?,?,?,?,?) SQL ID: A67AD996E76A98B85BF7BE4BD6DFBEDB SQL Text: SELECT SUM(nuh_update_count) AS update_count, nrc_collection_version, nrc_from_collection_id, nrc_from_collection_version, nrc_from_node_id FROM node_update_history LEFT JOIN node_copied ON nuh_collection_id = nrc_collection_id AND nuh_node_id = nrc_node_id WHERE nuh_node_id = ? AND nuh_collection_version = ? GROUP BY nuh_node_id SQL ID: 55C3E17DD1242A38678CEB6F52A83FEE SQL Text: SELECT br_id, br_group_id, br_type, br_expire_time, br_extend_info, br_status, br_create_at, br_update_at, bri_benefit_type, bri_quota, bri_benefit_info FROM benefit_record LEFT JOIN benefit_record_item ON benefit_record.br_id = benefit_record_item.bri_record_id WHERE br_status = ? AND bri_benefit_type = ? AND br_group_id IN ( SELECT gm_group_id FROM group_member WHERE gm_user_id = ? AND gm_status = ? ) ORDER By br_create_at ASC SQL ID: F9912F51D0D693AB9CE1B147F090C0A7 SQL Text: SELECT cns_data, cns_nodeVersion, cns_collectionVersion, cns_beginVersion FROM collection_node_snapshot WHERE cns_collectionId=? AND cns_collectionVersion > ? AND cns_nodeId=? order by cns_collectionVersion limit ? SQL ID: 5AD7FA60283581F9C84102E49CE12B06 SQL Text: SELECT c_id, c_app, c_rootNode, c_status FROM collection,node WHERE n_id = ? AND c_id = n_collectionId AND c_status = ? SQL ID: FC5F38AA6F5F7B2082CCB180CE16D743 SQL Text: SELECT br_id, br_group_id, br_type, br_expire_time, br_extend_info, br_status, br_create_at, br_update_at FROM benefit_record WHERE br_group_id = ? AND br_status = ? ORDER By br_create_at ASC SQL ID: E6817292C124582E5C084C7188576316 SQL Text: SELECT /*+ MONITOR_AGENT */ ash.con_id tenant_id, if (ash.event_no is null or ash.event_no = ?, ?, wait_class) waitclass, count(*) as cnt FROM oceanbase.v$active_session_history ash WHERE sample_time between now() - INTERVAL ? SECOND and now() and (wait_class <> ? or wait_class is null) and session_type = ? group by waitclass, tenant_id SQL ID: E79974DE56340B099DE55BEA08DECEFD SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ 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 = ? then ? else ? end) as fail_count, (case when ret_code = ? then ? else ? end) as ret_code_4012_count, (case when ret_code = ? then ? else ? end) as ret_code_4013_count, (case when ret_code = ? then ? else ? end) as ret_code_5001_count, (case when ret_code = ? then ? else ? end) as ret_code_5024_count, (case when ret_code = ? then ? else ? end) as ret_code_5167_count, (case when ret_code = ? then ? else ? end) as ret_code_5217_count, (case when ret_code = ? then ? else ? end) as ret_code_6002_count, event, p1, p2, p3, p1text, p2text, p3te SQL ID: AB083679B928CF882A1E38A28C822ED4 SQL Text: SELECT cds_version, cds_data FROM co_data_snapshot WHERE cds_codataId = ? ORDER BY cds_version DESC LIMIT ? SQL ID: 098BAD61386BE331830503F854E8DB61 SQL Text: INSERT IGNORE INTO node_reference( nr_toCollectionId, nr_toNodeId, nr_copyId, nr_fromCollectionId, nr_fromNodeId, nr_fromCollectionVersion, nr_userId ) VALUES(?,?,?,?,?,?,?) SQL ID: 095F2345F262D090A83FF1AC64CA8C76 SQL Text: SELECT ? SQL ID: 7D609596DF9F3484BEE4E449F484B04D SQL Text: SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = ? THEN ? ELSE ? END) AS SIGNED INTEGER), ?) AS IN_STORAGE_READ, COALESCE SQL ID: 35BF6604DD6AFB8D23AE0633C5AC8527 SQL Text: SELECT ajq_id,ajq_channel,ajq_provider,ajq_type,ajq_retry_times,ajq_retry_count,ajq_age_ms,ajq_start_at,ajq_create_at FROM ai_job_queue WHERE ajq_start_at <= ? AND ajq_provider = ? AND ajq_type = ? ORDER BY ajq_start_at ASC LIMIT ? SQL ID: CAD55628BA4BC4035A77BF7DCE33A904 SQL Text: SELECT cdu_version, cdu_userId, cdu_src, cdu_seq, cdu_createAt, cdu_data FROM co_data_update WHERE cdu_codataId = ? AND cdu_version >= ? ORDER BY cdu_version SQL ID: 030572EB4329CBF0455B3394248CF702 SQL Text: SELECT cns_data, cns_nodeVersion,cns_collectionVersion, cns_beginVersion FROM collection_node_snapshot WHERE cns_collectionId=? AND cns_collectionVersion <= ? AND cns_nodeId=? order by cns_collectionVersion DESC limit ? SQL ID: 4856DCEDAB4C1494C749283B3F2371D0 SQL Text: SELECT nr_fromCollectionId, nr_fromNodeId, nr_copyId, nr_fromCollectionVersion, nr_userId FROM node_reference WHERE nr_toCollectionId=? AND nr_toNodeId=? SQL ID: B909B740439B4B8747970DF4F762EEBB SQL Text: SELECT nr_toNodeId, nr_fromCollectionId, nr_fromCollectionVersion,nr_userId FROM node_reference WHERE nr_toCollectionId=? AND nr_fromNodeId=? AND nr_fromCollectionVersion=? AND nr_copyId=?