ASH_REPORT

The ASH_REPORT procedure is used to display an ASH report in text format.

Syntax

 PROCEDURE ASH_REPORT(BTIME         IN DATE,
                       ETIME         IN DATE,
                       SQL_ID        IN VARCHAR2  DEFAULT NULL,
                       TRACE_ID      IN VARCHAR2  DEFAULT NULL,
                       WAIT_CLASS    IN VARCHAR2  DEFAULT NULL,
                       REPORT_TYPE   IN VARCHAR2  DEFAULT 'text',
                       SVR_IP        IN VARCHAR2  DEFAULT NULL,
                       SVR_PORT      IN NUMBER    DEFAULT NULL,
                       TENANT_ID     INT          DEFAULT NULL
                     );

Parameters

Parameter	Description
BTIME	The start time of the sampling period.
ETIME	The end time of the sampling period.
SQL_ID	The SQL_ID of the SQL statement to be sampled. If this parameter is not specified or set to NULL, no restriction is imposed on the SQL_ID.
TRACE_ID	The TRACE_ID of the SQL statement to be sampled. If this parameter is not specified or set to NULL, no restriction is imposed on the TRACE_ID.
WAIT_CLASS	The event type to be sampled. The value of WAIT_CLASS is referenced from the GV$ACTIVE_SESSION_HISTORY.WAIT_CLASS field. If this parameter is not specified or set to NULL, no restriction is imposed on the wait type.
REPORT_TYPE	The report type. Currently, only HTML and TEXT are supported. If this parameter is not specified, the default value TEXT is used.

Usage notes

To obtain ASH information, query the GV$ACTIVE_SESSION_HISTORY view.

Example

Call ASH_REPORT, and specify the start and end times for the diagnostic. After the execution, the ASH report information is displayed on the interface.

CALL DBMS_WORKLOAD_REPOSITORY.ASH_REPORT( '2023-12-25 10:15:00',  '2023-12-25 10:19:02' );

The following is an example of the output:

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| REPORT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 
ASH Report

           Cluster Name: obcluster 
       Observer Version: OceanBase 1.0.0.0 (100000262025111218-5343637512e28c346f938516af53b7879d4d5974) 
  Operation System Info: Linux(5.10.134-18.al8.x86_64)_x86_64 
  User Input Begin Time: 2025-12-25 10:15:00 
    User Input End Time: 2025-12-25 10:19:02 
 Wr Analysis Begin Time: 2025-12-25 10:15:09 
   Wr Analysis End Time: 2025-12-25 10:18:56 
         Wr Data Source: oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY 
           Elapsed Time: 227 
       Wr Num of Sample: 230 
Average Active Sessions: 1.01 

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|
+----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+
|                                                             sys|  BACKGROUND|               230|                      0|                230|                1.01|    100.00%|                       -|
+----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+

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|
+----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+
|       127.0.0.1|   2882|  BACKGROUND|               230|                      0|                230|                1.01|    100.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|
+----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+
|                                                  127.0.0.1:2882|                                                                                                                    cgroup/other|          230|    100.00%|                                                          qsched|    100.00%|                          qsched|    100.00%|                       UNDEFINED|    100.00%|                1.01|
+----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+
+----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+
|             Slot Begin Time|   Slot Count|                                                                                                                      Action Key|      Action Samples| % Activity| Avg Active Sessions|
+----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+
|   2025-12-25 10:15:09(+21s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.95|
|   2025-12-25 10:15:30(+22s)|           30|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  30|    100.00%|                1.36|
|   2025-12-25 10:15:52(+22s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.91|
|   2025-12-25 10:16:14(+22s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.91|
|   2025-12-25 10:16:36(+22s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.91|
|   2025-12-25 10:16:58(+22s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.91|
|   2025-12-25 10:17:20(+22s)|           30|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  30|    100.00%|                1.36|
|   2025-12-25 10:17:42(+22s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.91|
|   2025-12-25 10:18:04(+22s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.91|
|   2025-12-25 10:18:26(+22s)|           20|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  20|    100.00%|                0.91|
|    2025-12-25 10:18:48(+8s)|           10|                                                                             127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED|                  10|    100.00%|                1.25|
+----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+

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|
+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+--------------------+-----------+
+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+--------------------+-----------+

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|
+----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+
|                                                  127.0.0.1:2882|                                                           qsched|                                                          qsched|                                                       UNDEFINED|                                                          ON CPU|                NULL|          230|    100.00%|                1.01|
+----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+

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|
+--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+
+--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+

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-25 10:15:09(+21s)|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.95|
|         2025-12-25 10:15:30|           30|                                                          ON CPU|                NULL|           30|    100.00%|                1.36|
|         2025-12-25 10:15:52|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.91|
|         2025-12-25 10:16:14|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.91|
|         2025-12-25 10:16:36|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.91|
|         2025-12-25 10:16:58|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.91|
|         2025-12-25 10:17:20|           30|                                                          ON CPU|                NULL|           30|    100.00%|                1.36|
|         2025-12-25 10:17:42|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.91|
|         2025-12-25 10:18:04|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.91|
|         2025-12-25 10:18:26|           20|                                                          ON CPU|                NULL|           20|    100.00%|                0.91|
|    2025-12-25 10:18:48(+8s)|           10|                                                          ON CPU|                NULL|           10|    100.00%|                1.25|
+----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+

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|
+------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+
+------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+

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|                  230|              100.00%|                    1|                                                  127.0.0.1:2882|              100.00%|              100.00%|                0.00%|
+---------------------------------------------+---------------------+---------------------+---------------------+----------------------------------------------------------------+---------------------+---------------------+---------------------+

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|
+----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+
+----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+

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: 1DCD1A13FF867BD1C03DE1582C274EE6
SQL Text: SELECT DBMS_WORKLOAD_REPOSITORY.ASH_REPORT_TEXT(:0, :1,:2,:3,:4, :6, :7, :8, LOWER(:5)) AS REPORT

  SQL ID: 32AB97A0126F566064F84DDDF4936F82
SQL Text: SELECT * FROM __all_ls_meta_table WHERE tenant_id = ? ORDER BY tenant_id, ls_id, svr_ip, svr_port

  SQL ID: 3468E7114C438006DD0574C9657EF3BF
SQL Text: select * from __all_tenant_scheduler_job where tenant_id = ? and job_name = ? and job = ?

  SQL ID: 1A01F4CAC17DA8C38C9BF4909F7D9BB9
SQL Text: WITH session_data AS (SELECT sql_id, svr_ip, svr_port, session_id, trace_id,  plan_hash, sql_plan_line_id, event_no, CAST(IF (event_no = ?, ?, event) AS CHAR(64))  AS event, time_model, count_weight, action FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.

  SQL ID: DB6D1C21FFA60ECAA8DA632C54E77752
SQL Text: WITH session_data AS (SELECT svr_ip, svr_port, session_id, CAST(IF (event_no = ?, ?, event) AS CHAR(64)) AS event, CAST(IF (event_no = ?, ?, wait_class) AS CHAR(64)) AS wait_class, event_no, sql_id, plan_hash, trace_id, program, count_weight FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LI

  SQL ID: 45B3D06C663D68113AFD35E24947F7E7
SQL Text: WITH session_data AS (SELECT svr_ip, svr_port, program, module, action, sql_id, plan_hash, delta_read_io_requests, delta_read_io_bytes, delta_write_io_requests, delta_write_io_bytes, tablet_id, count_weight, tm_delta_time FROM ( SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID 

  SQL ID: AE6AAA45F76278C5D07446959A258989
SQL Text: WITH session_data AS (SELECT sql_id, stmt_type, event_no, count_weight, svr_ip, svr_port, trace_id,session_id, time_model FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_ID, WR.STMT_TYPE AS STMT_TYPE, WR.PROG

  SQL ID: 543F534A64169F20873AB8189D804C90
SQL Text: WITH session_data AS (SELECT CAST(IF (event_no = ?, ?, event) AS CHAR(64)) AS event, CAST(IF (event_no = ?, ?, wait_class) AS CHAR(64)) AS wait_class, SUM(count_weight) AS event_time, CONCAT(svr_ip, ?, svr_port) AS node, CASE WHEN program IS NULL THEN ? ELSE program END AS program, CASE WHEN module IS NULL THEN ? ELSE module END AS module, CASE WHEN action IS NULL THEN ? ELSE action END AS action FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO =

  SQL ID: D918D505E3D554101A8153107A5D4174
SQL Text: WITH session_data AS(SELECT blocking_session_id, event, p1 AS holder_tx_id, p2 AS holder_data_seq, tx_id, sql_id, count_weight, trace_id, event_id,  session_id FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_

  SQL ID: 0DB6919F9B66178BA969E950C30C2AE1
SQL Text: WITH session_data AS (SELECT session_type,sql_id,trace_id,time_model,count_weight,svr_ip, svr_port, session_id FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_ID, WR.STMT_TYPE AS STMT_TYPE, WR.PROGRAM AS PROG

  SQL ID: CF2AADDE69A639BC676C2E9E772A1AF0
SQL Text: SELECT zone FROM __all_server where svr_ip=? and svr_port=?

  SQL ID: AFF6D863C784CC7E0A5141BD75242EF9
SQL Text: WITH session_data AS (SELECT event_no, event, wait_class, count_weight, slot_begin_time, slot_end_time, UNIX_TIMESTAMP(slot_end_time) - UNIX_TIMESTAMP(slot_begin_time) AS interval_time FROM (SELECT event_no, event, wait_class, count_weight, CASE WHEN slot_begin_time < min_sample_time THEN min_sample_time ELSE slot_begin_time END AS slot_begin_time, CASE WHEN slot_end_time > max_sample_time THEN max_sample_time ELSE slot_end_time END AS slot_end_time FROM (SELECT event_no, event, wait_class, count_weight, FROM_UNIXTIME(utc_seconds - (utc_seconds % interval_time)) AS slot_begin_time, FROM_UNIXTIME(utc_seconds + interval_time - (utc_seconds % interval_time)) AS slot_end_time, ? AS min_sample_time, ? AS max_sample_time FROM (SELECT event_no, count_weight, ? AS interval_time, CASE WHEN event_no = ? THEN ? ELSE event END AS event, CASE WHEN event_no = ? THEN ? ELSE wait_class END AS wait_class, CAST(UNIX_TIMESTAMP(sample_time) AS SIGNED) AS utc_seconds FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SV

  SQL ID: 24D486F20861EBD9E0217692DB0E9C61
SQL Text: update __all_weak_read_service set min_version=?, max_version=?     where tenant_id = ? and level_id = ? and level_value = ? and min_version = ? and max_version = ?

  SQL ID: 6F3109B2EDC153980E1722318E4F6240
SQL Text: SELECT value FROM __all_zone where zone=? and name=?

  SQL ID: F072EFE2E438832E4CFCFC0E47D09E98
SQL Text: SELECT CAST(IF (EVENT_NO = ?, ?, EVENT) AS CHAR(64)) AS EVENT, SUM(count_weight) AS CNT FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_ID, WR.STMT_TYPE AS STMT_TYPE, WR.PROGRAM AS PROGRAM, WR.MODULE AS MODUL

  SQL ID: 5610A1050E9A34F45A5517F5A3FFA2A6
SQL Text: SELECT info FROM __all_zone where zone = ? and name = ?

  SQL ID: 1D0BA376E273B9D622641124D8C59264
SQL Text: COMMIT

  SQL ID: 858015B92843B43D99CA77541C4C2592
SQL Text: SELECT VALUE FROM __all_sys_stat WHERE ZONE = ? AND NAME = ? AND TENANT_ID = ? FOR UPDATE

  SQL ID: B7A6FA97FEC98C06F9586D23935AC4C6
SQL Text: START TRANSACTION

  SQL ID: 7F4BF0A21CBDBB436BAFAB2674482F89
SQL Text: SELECT * FROM __all_unit WHERE (svr_ip = ? AND svr_port = ?) or (migrate_from_svr_ip = ? AND migrate_from_svr_port = ?)

  SQL ID: 69D4EC82CE11CB6BA481591FD96467E2
SQL Text: SELECT value from oceanbase.__all_sys_stat where name = ?

  SQL ID: 421077B5841DBAAC88F5E2AE5B8082F8
SQL Text: SELECT tenant_id, svr_ip, svr_port, migrate_from_svr_ip, migrate_from_svr_port from __all_unit unit join __all_resource_pool pool on unit.resource_pool_id = pool.resource_pool_id where tenant_id != ? order by tenant_id

  SQL ID: FD4390F00BA50EBCC4BBAE0C3A06BD8E
SQL Text: SELECT column_value FROM __all_core_table WHERE TABLE_NAME = ? AND COLUMN_NAME = ? FOR UPDATE

  SQL ID: 95C9A6346A2B1546D243358F32684FAB
SQL Text: SELECT *, time_to_usec(gmt_modified) AS last_hb_time FROM __all_server

  SQL ID: A300863F1A27D37B8CFAD64C08892CEF
SQL Text: DELETE FROM oceanbase.__all_dbms_lock_allocated WHERE expiration <= usec_to_time(?)AND lockid NOT IN( SELECT obj_id FROM oceanbase.__all_detect_lock_info_v2 WHERE obj_type = ? or obj_type = ? ) LIMIT ?

  SQL ID: 556CEFD22F28DDDCB6E283DF89BD9348
SQL Text: UPDATE __all_core_table SET column_value = ? WHERE table_name = ? AND column_name = ? AND column_value < ?

  SQL ID: 48CEB0A0959F23770F34CB064EA1A1EA
SQL Text: SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `svr_ip`, `svr_port`, `sample_time`, `event_id`, `group_id`, `program`, `module`, `action` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC

  SQL ID: 6D076E4DC9EFCD54B69932B70F5F9212
SQL Text: SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `sample_time`, `event_no`, `event_id` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC

  SQL ID: 4C7CBDC327592A4B6E26F94324B5ABA4
SQL Text: SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `svr_ip`, `svr_port`, `sample_time`, `sql_id`, `event_id`, `time_waited`, `p1`, `p2`, `p3`, `plan_hash`, `program`, `module`, `action` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC

  SQL ID: 1B26C909437A4F990E0D2E2FF2EEA6F4
SQL Text: SELECT owner_type,owner_id FROM oceanbase.__all_detect_lock_info_v2 WHERE detect_func_no = ? GROUP BY owner_id

  SQL ID: 58F593697294BBBE422235CCA6DE1A0F
SQL Text: SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `svr_ip`, `svr_port`, `sample_time`, `event_no`, `sql_id`, `trace_id`, `event_id`, `module`, `action`, `tablet_id` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC

  SQL ID: 2F342DE7B51CA64B28233E836A9331F6
SQL Text: SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,col_stat.cg_skip_rate as cg_skip_rate,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_s

  SQL ID: E9FEB140E9462E663AA8AA8B5B1959A0
SQL Text: SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,col_stat.cg_skip_rate as cg_skip_rate,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_s

  SQL ID: EE5609A32CDCA874F5D52107C681D512
SQL Text: SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,col_stat.cg_skip_rate as cg_skip_rate,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_s

  SQL ID: 7CC42215503DE6C0B04054BE7A20DF56
SQL Text: DELETE FROM __all_vector_index_task WHERE tenant_id = ? AND status = ? AND gmt_create <= (SELECT gmt_create FROM __all_vector_index_task_history ORDER BY gmt_create desc LIMIT ?)

  SQL ID: AB432370A94ED418C318E72A2E0DCA7B
SQL Text: SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,col_stat.cg_skip_rate as cg_skip_rate,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_s

  SQL ID: 8D72C2DC3F227C7834ED9172F677D0A1
SQL Text: SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,col_stat.cg_skip_rate as cg_skip_rate,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_s

  SQL ID: AEE1D864C114B40CA73E5A66FADF96F1
SQL Text: SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,col_stat.cg_skip_rate as cg_skip_rate,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_s

  SQL ID: 1C2A2CCE80094591D6F75AD5DF9F4227
SQL Text: DELETE FROM __all_vector_index_task_history WHERE gmt_modified < usec_to_time(?) LIMIT ?

  SQL ID: AF6EB4B3612A1A358ED582F6F0D8FFA5
SQL Text: SELECT /*+ query_timeout(3216672000000000) */ effective_tenant_id(), `table_id`, `part_id`, `partition_type`, `sub_part_name`, `tablet_id` FROM `__all_sub_part` WHERE ?=? AND tenant_id = ? ORDER BY `table_id` ASC, `part_id` ASC, `sub_part_id` ASC

  SQL ID: 5A4B823D62DB0A70CA1B9386414D3B50
SQL Text: SELECT /*+ query_timeout(3216672000000000) */ effective_tenant_id(), `data_table_id`, `table_type`, `table_name` FROM `__all_table` WHERE ?=? AND tenant_id = ? ORDER BY `table_id` ASC

 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (5.652 sec)

Query OK, 0 rows affected (5.655 sec)

Run the following command to display the report in the HTML format.

CALL DBMS_WORKLOAD_REPOSITORY.ASH_REPORT('2023-12-25 10:15:00',  '2023-12-25 10:19:02', null, null, null, 'HTML', '172.30.xxx.xxx', 28xx)\G

The following is an example of the output:

*************************** 1. row ***************************
REPORT: <!DOCTYPE html><html lang="en"><head><title>ASH Report</title>         <style type="text/css">         body.ash_html {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:rgb(246, 248, 251);}         pre.ash_html  {font:8pt Courier;color:black; background:rgb(246, 248, 251);}         pre_sqltext.ash_html  {white-space: pre-wrap;}         h1.ash_html   {font:bold 20pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:rgb(246, 248, 251);border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}         h2.ash_html   {font:bold 18pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:rgb(246, 248, 251);margin-top:4pt; margin-bottom:0pt;}         h3.ash_html {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:rgb(246, 248, 251);margin-top:4pt; margin-bottom:0pt;}         li.ash_html {font: 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:rgb(246, 248, 251);}         th.ash_htmlnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:rgb(246, 248, 251);padding-left:4px; padding-right:4px;padding-bottom:2px}         th.ash_htmlbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}         td.ash_htmlnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:rgb(246, 248, 251);vertical-align:top;}         td.ash_htmlc    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}         td.ash_htmlnclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:rgb(246, 248, 251);vertical-align:top;border-left: thin solid black;}         td.ash_htmlncbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:rgb(246, 248, 251);vertical-align:top;border-left: thin solid black;border-right: thin solid black;}         td.ash_htmlncrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:rgb(246, 248, 251);vertical-align:top;border-right: thin solid black;}         td.ash_htmlcrb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-right: thin solid black;}         td.ash_htmlclb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;}         td.ash_htmlcbb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;border-right: thin solid black;}         a.ash_html {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}         td.ash_htmlnct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:rgb(246, 248, 251);vertical-align:top;}         td.ash_htmlct   {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:#FFFFCC; vertical-align:top;}         td.ash_htmlnclbt  {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:rgb(246, 248, 251);vertical-align:top;border-top: thin solid black;border-left: thin solid black;}         td.ash_htmlncbbt  {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:rgb(246, 248, 251);vertical-align:top;border-left: thin solid black;border-right: thin solid black;border-top: thin solid black;}         td.ash_htmlncrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:rgb(246, 248, 251);vertical-align:top;border-top: thin solid black;border-right: thin solid black;}         td.ash_htmlcrbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-right: thin solid black;}         td.ash_htmlclbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;}         td.ash_htmlcbbt   {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;border-right: thin solid black;}         table.tdiff {  border_collapse: collapse; }         table.tscl {width: 600;}         table.tscl tbody, table.tscl thead { display: block; }         table.tscl thead tr th {height: 12px;line-height: 12px;}         table.tscl tbody { height: 100px;overflow-y: auto; overflow-x: hidden;}         table.tscl tbody td, thead th {width: 200;}         .hidden   {position:absolute;left:-10000px;top:auto;width:1px;height:1px;overflow:hidden;}         .pad   {margin-left:17px;}         .doublepad {margin-left:34px;}         .hide-column {           display: none;         }         </style></head>
         <script>           function setSectionList() {             var list = document.getElementById(110);             const section_headers = document.querySelectorAll('h2');             section_headers.forEach(ele => {               let str = ele.innerText.replaceAll('<br>','');               let li = document.createElement('li');               let a = document.createElement('a');               a.classList.add('ash_html');               a.setAttribute('href', str);               a.innerText = str;               li.innerHTML = '<a class = "ash_html" href = "#' + str + '">' + str + '</a>';               li.classList.add('ash_html');               list.appendChild(li);             });           }           function mergeEmptyCells() {             const tables = document.querySelectorAll('table');             tables.forEach(table => {               const rows = table.rows;               const calcSpanNum = (rowIndex, colIndex) => {                 let num = 0;                 for (let i = rowIndex + 1; i < rows.length; i++) {                   if (rows[i].cells[colIndex].innerText.trim() === '') {                     num++;                   } else {                     break;                   }                 }                 return num;               };               let mergeColumns = new Set();               if (table.classList.contains('merge_cell')) {                 for (let j = 0; j < rows[0].cells.length; j++ ) {                   mergeColumns.add(j);                 }               } else {                 const headers = rows[0].getElementsByTagName('th');                 for (let j = 0; j < headers.length; j++) {                   if (headers[j].classList.contains('merge_cell')) {                     mergeColumns.add(j);                   }                 }               }               for (let i = 1; i < rows.length; i++) {                 for (let j = 0; j < rows[i].cells.length; j++) {                   if (!mergeColumns.has(j)) continue;                   /*skip columns that do not need to be merged*/                   let currentCell = rows[i].cells[j];                   let spanNum = calcSpanNum(i, j);                   /*do not clear the empty cell in the first row of tbody*/                   if (i > 1 && currentCell.innerText.trim() === '') {                     currentCell.className = 'blank-cell';                     continue;                   }                   if (spanNum) {                     currentCell.rowSpan = spanNum + 1;                   }                 }               }             });             document.querySelectorAll('.blank-cell').forEach(el => el.parentNode.removeChild(el));           }           function hideColumn() {             const tables = document.querySelectorAll('table');             tables.forEach(table => {               const rows = table.rows;               const headers = rows[0].getElementsByTagName('th');               let hiddenColumns = new Set();               for (let i = 0; i < headers.length; i++) {                 if (headers[i].classList.contains('hide-column')) {                   hiddenColumns.add(i);                 }               }               for (let i = 1; i < rows.length; i++) {                 hiddenColumns.forEach(colIndex => {                   rows[i].cells[colIndex].classList.add('hide-column');                 });               }             });           }           document.addEventListener('DOMContentLoaded', function () {             setSectionList();             mergeEmptyCells(); /*merge empty cells*/             hideColumn();           });         </script>         <body class="ash_html">         <h1 class="ash_html">         ASH Report         </h1><pre class="ash_html">           Cluster Name: obcluster 
       Observer Version: OceanBase 1.0.0.0 (100000262025111218-5343637512e28c346f938516af53b7879d4d5974) 
  Operation System Info: Linux(5.10.134-18.al8.x86_64)_x86_64 
  User Input Begin Time: 2025-12-25 10:15:00 
    User Input End Time: 2025-12-25 10:19:02 
 Wr Analysis Begin Time: 2025-12-25 10:15:09 
   Wr Analysis End Time: 2025-12-25 10:18:56 
         Wr Data Source: oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY 
           Elapsed Time: 227 
       Wr Num of Sample: 230 
Average Active Sessions: 1.01 
</pre><ul id=110></ul><a class="ash_html" name='Top Active Tenants'></a>          <h2 class="ash_html">Top Active Tenants<br></h2><ul><li class='ash_html'>this section lists top active tenant information</li>
<li class='ash_html'>Total Samples: num of records during ash report analysis time period</li>
<li class='ash_html'>Wait Event Samples: num of records when session is on wait event</li>
<li class='ash_html'>On CPU Samples: num of records when session is on cpu</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period</li>
<li class='ash_html'>% Activity: activity(cpu + wait) percentage for given tenant</li>
<li class='ash_html'>Equivalent Client Load: equivalent client average active sessions during ash report analysis time period</li>
</ul>
<table id="1272084602444817527" class="normal" border="1"><tr><th class="ash_htmlbg" scope="col">Tenant Name</th><th class="ash_htmlbg" scope="col">Session Type</th><th class="ash_htmlbg" scope="col">Total Samples</th><th class="ash_htmlbg" scope="col">Wait Event Samples</th><th class="ash_htmlbg" scope="col">On CPU Samples</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Equivalent Client Load</th></tr><tr><td scope="row" class='ash_htmlc'>sys</td><td class='ash_htmlc'>BACKGROUND</td><td class='ash_htmlc'>230</td><td class='ash_htmlc'>0</td><td class='ash_htmlc'>230</td><td class='ash_htmlc'>1.01</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>-</td></tr>
</table><p />
<a class="ash_html" name='Top Node Load'></a>          <h2 class="ash_html">Top Node Load<br></h2><ul><li class='ash_html'>this section lists top node measured by DB time</li>
<li class='ash_html'>IP: OceanBase instance svr_ip</li>
<li class='ash_html'>Port: OceanBase instance svr_port</li>
<li class='ash_html'>Total Samples: num of records during ash report analysis time period</li>
<li class='ash_html'>Wait Event Samples: num of records when session is on wait event</li>
<li class='ash_html'>On CPU Samples: num of records when session is on cpu</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period</li>
<li class='ash_html'>% Activity: activity(cpu + wait) percentage for given tenant</li>
<li class='ash_html'>Equivalent Client Load: equivalent client average active sessions during ash report analysis time period</li>
</ul>
<table id="16357310892602464515" class="normal" border="1"><tr><th class="ash_htmlbg" scope="col">IP</th><th class="ash_htmlbg" scope="col">Port</th><th class="ash_htmlbg" scope="col">Session Type</th><th class="ash_htmlbg" scope="col">Total Samples</th><th class="ash_htmlbg" scope="col">Wait Event Samples</th><th class="ash_htmlbg" scope="col">On CPU Samples</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Equivalent Client Load</th></tr><tr><td scope="row" class='ash_htmlc'>127.0.0.1</td><td class='ash_htmlc'>2882</td><td class='ash_htmlc'>BACKGROUND</td><td class='ash_htmlc'>230</td><td class='ash_htmlc'>0</td><td class='ash_htmlc'>230</td><td class='ash_htmlc'>1.01</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>-</td></tr>
</table><p />
<a class="ash_html" name='Top Groups'></a>          <h2 class="ash_html">Top Groups<br></h2><ul><li class='ash_html'>this section lists top resource consumer groups</li>
<li class='ash_html'>Group Name: resource consumer group name</li>
<li class='ash_html'>Group Samples: num of sampled session activity records in the current resource group</li>
<li class='ash_html'>% Activity: activity percentage for given event resource group</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period</li>
</ul>
<table id="11442395157058278182" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Node</th><th class="ash_htmlbg" scope="col">Group Name</th><th class="ash_htmlbg" scope="col">Group Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Program</th><th class="ash_htmlbg" scope="col">% Program</th><th class="ash_htmlbg" scope="col">Module</th><th class="ash_htmlbg" scope="col">% Module</th><th class="ash_htmlbg" scope="col">Action</th><th class="ash_htmlbg" scope="col">% Action</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th></tr><tr><td scope="row" class='ash_htmlc'>127.0.0.1:2882</td><td class='ash_htmlc'>cgroup/other</td><td class='ash_htmlc'>230</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>qsched</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>qsched</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>UNDEFINED</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc actions' data-action-params='tableIds=2114525341428311308&rowIds=17248049173992735523'>1.01</td></tr>
</table><p />
<table id="2114525341428311308" class="normal hide-table" border="1"><tr><th class="ash_htmlbg" scope="col">Slot Begin Time</th><th class="ash_htmlbg" scope="col">Slot Count</th><th class="ash_htmlbg hide-column" scope="col">Action Key</th><th class="ash_htmlbg" scope="col">Action Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th></tr><tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlc'>2025-12-25 10:15:09(+21s)</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.95</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlnc'>2025-12-25 10:15:30(+22s)</td><td class='ash_htmlnc'>30</td><td class='ash_htmlnc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlnc'>30</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>1.36</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlc'>2025-12-25 10:15:52(+22s)</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.91</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlnc'>2025-12-25 10:16:14(+22s)</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlc'>2025-12-25 10:16:36(+22s)</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.91</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlnc'>2025-12-25 10:16:58(+22s)</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlc'>2025-12-25 10:17:20(+22s)</td><td class='ash_htmlc'>30</td><td class='ash_htmlc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlc'>30</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>1.36</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlnc'>2025-12-25 10:17:42(+22s)</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlc'>2025-12-25 10:18:04(+22s)</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.91</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlnc'>2025-12-25 10:18:26(+22s)</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr data-row-id='17248049173992735523'><td scope="row" class='ash_htmlc'>2025-12-25 10:18:48(+8s)</td><td class='ash_htmlc'>10</td><td class='ash_htmlc'>127.0.0.1:2882-cgroup/other-qsched-qsched-UNDEFINED</td><td class='ash_htmlc'>10</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>1.25</td></tr>
</table><p />
<a class="ash_html" name='Top Foreground DB Time'></a>          <h2 class="ash_html">Top Foreground DB Time<br></h2><ul><li class='ash_html'>This section lists top foreground db time categorized by event</li>
<li class='ash_html'>Event Name: comprise wait event and on cpu event</li>
<li class='ash_html'>Event Samples: num of sampled session activity records</li>
<li class='ash_html'>% Activity: activity percentage for given event</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period</li>
</ul>
<table id="9599644564085823616" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Node</th><th class="ash_htmlbg" scope="col">Event Name</th><th class="ash_htmlbg" scope="col">Wait Class</th><th class="ash_htmlbg" scope="col">Event Samples</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th><th class="ash_htmlbg" scope="col">% Activity</th></tr></table><p />
<a class="ash_html" name='Top Background DB Time'></a>          <h2 class="ash_html">Top Background DB Time<br></h2><ul><li class='ash_html'>this section lists top DB Time for background sessions</li>
<li class='ash_html'>Program: process name for background sessions</li>
<li class='ash_html'>Event Name: comprise wait event and on cpu event</li>
<li class='ash_html'>Event Samples: num of sampled session activity records</li>
<li class='ash_html'>% Activity: activity percentage for given event</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period</li>
</ul>
<table id="13694051875954344442" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Node</th><th class="ash_htmlbg" scope="col">Program</th><th class="ash_htmlbg" scope="col">Module</th><th class="ash_htmlbg" scope="col">Action</th><th class="ash_htmlbg" scope="col">Event Name</th><th class="ash_htmlbg" scope="col">Wait Class</th><th class="ash_htmlbg" scope="col">Event Samples</th><th class="ash_htmlbg" scope="col"> % Activity</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th></tr><tr><td scope="row" class='ash_htmlc'>127.0.0.1:2882</td><td class='ash_htmlc'>qsched</td><td class='ash_htmlc'>qsched</td><td class='ash_htmlc'>UNDEFINED</td><td class='ash_htmlc'>ON CPU</td><td class='ash_htmlc'>NULL</td><td class='ash_htmlc'>230</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>1.01</td></tr>
</table><p />
<a class="ash_html" name='Top Sessions'></a>          <h2 class="ash_html">Top Sessions<br></h2><ul><li class='ash_html'>this section lists top Active Sessions with the largest wait event and SQL_ID</li>
<li class='ash_html'>Session ID: user session id</li>
<li class='ash_html'>% Activity: represents the load on the database caused by this session</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period</li>
<li class='ash_html'>Event Name: comprise wait event and on cpu event</li>
<li class='ash_html'>% Event: represents the activity load of the event on the database</li>
<li class='ash_html'>% SQL ID: represents the activity load of the event on the database</li>
<li class='ash_html'>Sql Executions: represents the execution count of the SQL_ID</li>
</ul>
<table id="3657758197288966648" class="normal" border="1"><tr><th class="ash_htmlbg" scope="col">Node</th><th class="ash_htmlbg" scope="col">Session ID</th><th class="ash_htmlbg" scope="col">Program</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th><th class="ash_htmlbg" scope="col">Event Name</th><th class="ash_htmlbg" scope="col">Wait Class</th><th class="ash_htmlbg" scope="col">% Event</th><th class="ash_htmlbg" scope="col">SQL ID</th><th class="ash_htmlbg" scope="col">Plan Hash</th><th class="ash_htmlbg" scope="col">% SQL ID</th><th class="ash_htmlbg" scope="col">Sql Executions</th></tr></table><p />
<a class="ash_html" name='Top IO Bandwidth'></a>          <h2 class="ash_html">Top IO Bandwidth<br></h2><ul><li class='ash_html'>This section lists the top io bandwidth from the perspective of SQL and background tasks</li>
<li class='ash_html'>Node: The IP address and port number of the observer</li>
<li class='ash_html'>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</li>
<li class='ash_html'>Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks.</li>
<li class='ash_html'>IOPS: Average IO requests executed per second</li>
<li class='ash_html'>IO Size: The total read or write size(MB) of background task or SQL</li>
<li class='ash_html'>IO Bandwidth: Average IO size(MB) consumed per second</li>
<li class='ash_html'>Type: read or write</li>
<li class='ash_html'>Object ID: The tablet_id with the highest read or write bytes</li>
<li class='ash_html'>% 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</li>
</ul>
<table id="13332205474538740856" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Node</th><th class="ash_htmlbg" scope="col">Program Module Action / SQL ID</th><th class="ash_htmlbg" scope="col">Plan Hash</th><th class="ash_htmlbg" scope="col">Type</th><th class="ash_htmlbg" scope="col">IOPS</th><th class="ash_htmlbg" scope="col">IO Size(MB)</th><th class="ash_htmlbg" scope="col">IO Bandwidth(MB/s)</th><th class="ash_htmlbg" scope="col">Object ID</th><th class="ash_htmlbg" scope="col">% Object ID</th></tr></table><p />
<a class="ash_html" name='Top Blocking Sessions'></a>          <h2 class="ash_html">Top Blocking Sessions<br></h2><ul><li class='ash_html'>Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only.</li>
<li class='ash_html'>'% Activity' represents the load on the database caused by a particular blocking session.</li>
<li class='ash_html'>'# Avg Active Sessions' shows the number of ASH samples in which the blocking session was found active.</li>
</ul>
<table id="854397819795971770" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Blocking Session ID</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th><th class="ash_htmlbg" scope="col">Holder User</th><th class="ash_htmlbg" scope="col">Holder TX ID</th><th class="ash_htmlbg" scope="col">Holder SQL ID</th><th class="ash_htmlbg" scope="col">Event Caused</th><th class="ash_htmlbg" scope="col">% Event</th><th class="ash_htmlbg" scope="col">XIDs</th><th class="ash_htmlbg" scope="col">Top Waitting SQL ID</th><th class="ash_htmlbg" scope="col">% SQL ID</th></tr></table><p />
<a class="ash_html" name='Top Latchs'></a>          <h2 class="ash_html">Top Latchs<br></h2><ul><li class='ash_html'>this section lists top latches</li>
<li class='ash_html'>Latch Wait Event: event that waiting for latch</li>
<li class='ash_html'>Event Samples: num of sampled session activity records</li>
<li class='ash_html'>% Activity: activity percentage for given event</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period</li>
</ul>
<table id="12450523581268721567" class="normal" border="1"><tr><th class="ash_htmlbg" scope="col">Latch Wait Event</th><th class="ash_htmlbg" scope="col">Event Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th></tr></table><p />
<a class="ash_html" name='Top DB Objects'></a>          <h2 class="ash_html">Top DB Objects<br></h2><ul><li class='ash_html'>With respect to Application, Cluster, User I/O and buffer busy waits only.</li>
<li class='ash_html'>Object ID: tablet_id of the database table.</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period.</li>
<li class='ash_html'>% Activity:the load on the database caused by accessing the databsae object.</li>
<li class='ash_html'>Execution Count:represents how many executions involve this object</li>
<li class='ash_html'>Event:When accessing the object, the corresponding Top waiting events (up to 5 are printed).</li>
<li class='ash_html'>% Event:The percentage of the corresponding Top wait events when accessing the object (up to 5 events are printed).</li>
<li class='ash_html'>SQL ID:the SQL ID with the highest load when accessing the object and in the wait event.</li>
<li class='ash_html'>%SQL ID/Module:The percentage of SQL ID or Module with the highest load in this wait event when accessing the object.</li>
<li class='ash_html'>Object Name (Type/ Partition Name):the name and type/partition_name of the database object being accessed</li>
</ul>
<table id="11282109316625080131" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Node Address</th><th class="ash_htmlbg" scope="col">Tenant ID</th><th class="ash_htmlbg" scope="col">Object ID</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Execution Count</th><th class="ash_htmlbg" scope="col">Event</th><th class="ash_htmlbg" scope="col">% Event</th><th class="ash_htmlbg" scope="col">SQL ID</th><th class="ash_htmlbg" scope="col">%SQL ID/Module</th><th class="ash_htmlbg" scope="col">Object Name (Type/Partition Name)</th></tr></table><p />
<a class="ash_html" name='Activity Over Time'></a>          <h2 class="ash_html">Activity Over Time<br></h2><ul><li class='ash_html'>this section lists time slot information during the analysis period.</li>
<li class='ash_html'>The numbers in parentheses represent the time (in seconds) that has passed since the beginning and end stages.</li>
<li class='ash_html'>Slot Begin Time: current slot's begin time. current slot end with next slot begin time.</li>
<li class='ash_html'>Event Name: comprise wait event and on cpu event.</li>
<li class='ash_html'>Event Samples: num of sampled session activity records.</li>
<li class='ash_html'>% Activity: activity percentage for given event.</li>
<li class='ash_html'>Avg Active Sessions: average active sessions during ash report analysis time period.</li>
</ul>
<table id="7190104774825384967" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Slot Begin Time</th><th class="ash_htmlbg" scope="col">Slot Count</th><th class="ash_htmlbg" scope="col">Event Name</th><th class="ash_htmlbg" scope="col">Wait Class</th><th class="ash_htmlbg" scope="col">Event Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Avg Active Sessions</th></tr><tr><td scope="row" class='ash_htmlc'>2025-12-25 10:15:09(+21s)</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>ON CPU</td><td class='ash_htmlc'>NULL</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.95</td></tr>
<tr><td scope="row" class='ash_htmlnc'>2025-12-25 10:15:30</td><td class='ash_htmlnc'>30</td><td class='ash_htmlnc'>ON CPU</td><td class='ash_htmlnc'>NULL</td><td class='ash_htmlnc'>30</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>1.36</td></tr>
<tr><td scope="row" class='ash_htmlc'>2025-12-25 10:15:52</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>ON CPU</td><td class='ash_htmlc'>NULL</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.91</td></tr>
<tr><td scope="row" class='ash_htmlnc'>2025-12-25 10:16:14</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>ON CPU</td><td class='ash_htmlnc'>NULL</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr><td scope="row" class='ash_htmlc'>2025-12-25 10:16:36</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>ON CPU</td><td class='ash_htmlc'>NULL</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.91</td></tr>
<tr><td scope="row" class='ash_htmlnc'>2025-12-25 10:16:58</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>ON CPU</td><td class='ash_htmlnc'>NULL</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr><td scope="row" class='ash_htmlc'>2025-12-25 10:17:20</td><td class='ash_htmlc'>30</td><td class='ash_htmlc'>ON CPU</td><td class='ash_htmlc'>NULL</td><td class='ash_htmlc'>30</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>1.36</td></tr>
<tr><td scope="row" class='ash_htmlnc'>2025-12-25 10:17:42</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>ON CPU</td><td class='ash_htmlnc'>NULL</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr><td scope="row" class='ash_htmlc'>2025-12-25 10:18:04</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>ON CPU</td><td class='ash_htmlc'>NULL</td><td class='ash_htmlc'>20</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.91</td></tr>
<tr><td scope="row" class='ash_htmlnc'>2025-12-25 10:18:26</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>ON CPU</td><td class='ash_htmlnc'>NULL</td><td class='ash_htmlnc'>20</td><td class='ash_htmlnc'>100.00%</td><td class='ash_htmlnc'>0.91</td></tr>
<tr><td scope="row" class='ash_htmlc'>2025-12-25 10:18:48(+8s)</td><td class='ash_htmlc'>10</td><td class='ash_htmlc'>ON CPU</td><td class='ash_htmlc'>NULL</td><td class='ash_htmlc'>10</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>1.25</td></tr>
</table><p />
<a class="ash_html" name='Top Execution Phase'></a>          <h2 class="ash_html">Top Execution Phase<br></h2><ul><li class='ash_html'>this section lists top phases of execution, such as SQL, PL/SQL, STORAGE, etc.</li>
</ul>
<table id="7462397101562178098" class="normal" border="1"><tr><th class="ash_htmlbg merge_cell" scope="col">Session Type</th><th class="ash_htmlbg" scope="col">Phase of Execution</th><th class="ash_htmlbg" scope="col">Active Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">SQL_ID</th><th class="ash_htmlbg" scope="col">% SQL_ID</th></tr></table><p />
<a class="ash_html" name='Top IO Events'></a>          <h2 class="ash_html">Top IO Events<br></h2><ul><li class='ash_html'>This section lists the top io event from the perspective of SQL and background tasks</li>
<li class='ash_html'>Node: The IP address and port number of the observer</li>
<li class='ash_html'>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</li>
<li class='ash_html'>Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks</li>
<li class='ash_html'>IO Event Samples: The total samples of io wait event during task execution.</li>
<li class='ash_html'>%IO Event Samples: The proportion of total io wait event samples among all sampled points</li>
<li class='ash_html'>Top Event: The top io wait event name.</li>
<li class='ash_html'>IO Type: The type of io wait event.</li>
<li class='ash_html'>% EVENT: activity percentage for the io wait event.</li>
<li class='ash_html'>Enqueue Time: The total time(in seconds) spent queuing for I/O requests.</li>
<li class='ash_html'>Device Time: The total time (in seconds) spent executing I/O requests on the device.</li>
<li class='ash_html'>Callback Time: The total time (in seconds) spent executing callbacks for I/O requests.</li>
</ul>
<table id="17880690652322861663" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">Node</th><th class="ash_htmlbg" scope="col">Program Module Action / SQL ID</th><th class="ash_htmlbg" scope="col">Plan Hash</th><th class="ash_htmlbg" scope="col">IO Event Samples</th><th class="ash_htmlbg" scope="col">%IO Event Samples</th><th class="ash_htmlbg" scope="col">Top Event</th><th class="ash_htmlbg" scope="col">IO Type</th><th class="ash_htmlbg" scope="col">% EVENT</th><th class="ash_htmlbg" scope="col">Enqueue Time(S)</th><th class="ash_htmlbg" scope="col">Device Time(S)</th><th class="ash_htmlbg" scope="col">Callback Time(S)</th></tr></table><p />
<a class="ash_html" name='Top SQL Statement Types'></a>          <h2 class="ash_html">Top SQL Statement Types<br></h2><ul><li class='ash_html'>this section lists top sql statement type.</li>
<li class='ash_html'>SQL Statement Type: SQL statement types such as SELECT or UPDATE</li>
<li class='ash_html'>Total Samples: num of records during ash report analysis time period</li>
<li class='ash_html'>% Event: activity percentage of records when session is on wait event</li>
<li class='ash_html'>% On CPU: activity percentage of records when session is on cpu</li>
<li class='ash_html'>% Activity: activity(cpu + wait) percentage for given tenant</li>
<li class='ash_html'>Node: the server address where the statement was executed</li>
</ul>
<table id="3775396883518930055" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">SQL Statement Type</th><th class="ash_htmlbg" scope="col">Total Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Sampled Executions</th><th class="ash_htmlbg" scope="col">Node</th><th class="ash_htmlbg" scope="col">% Node</th><th class="ash_htmlbg" scope="col">% On CPU</th><th class="ash_htmlbg" scope="col">% Event</th></tr><tr><td scope="row" class='ash_htmlc'>T_NONE</td><td class='ash_htmlc'>230</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>1</td><td class='ash_htmlc'>127.0.0.1:2882</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>100.00%</td><td class='ash_htmlc'>0.00%</td></tr>
</table><p />
<a class="ash_html" name='Top SQL with Top Events'></a>          <h2 class="ash_html">Top SQL with Top Events<br></h2><ul><li class='ash_html'>This Section lists the SQL statements that accounted for the highest percentages event.</li>
<li class='ash_html'>Plan Hash: Numeric representation of the current SQL plan</li>
<li class='ash_html'>Active Samples: num of samples for top current SQL</li>
<li class='ash_html'>% Activity: activity percentage for given SQL ID</li>
<li class='ash_html'>Sampled Executions: represents the number of times the current SQL execution has been sampled</li>
<li class='ash_html'>Top Event: top event name for current SQL plan</li>
<li class='ash_html'>% Event: activity percentage for current SQL plan</li>
<li class='ash_html'>Top Operator/ExecPhase: top operator name or execution phase for current event</li>
<li class='ash_html'>% Operator/ExecPhase: activity percentage for given operator</li>
</ul>
<table id="2324647871458503671" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">SQL ID</th><th class="ash_htmlbg" scope="col">Plan Hash</th><th class="ash_htmlbg" scope="col">Active Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Sampled Executions</th><th class="ash_htmlbg" scope="col">Top Event</th><th class="ash_htmlbg" scope="col">% Event</th><th class="ash_htmlbg" scope="col">Top Operator/ExecPhase</th><th class="ash_htmlbg" scope="col">% Operator/ExecPhase</th><th class="ash_htmlbg" scope="col">SQL Text</th></tr></table><p />
<a class="ash_html" name='Top SQL with Top Operator'></a>          <h2 class="ash_html">Top SQL with Top Operator<br></h2><ul><li class='ash_html'>This Section lists the SQL statements that accounted for the highest percentages of sampled session activity with sql operator</li>
<li class='ash_html'>Plan Hash: Numeric representation of the current SQL plan</li>
<li class='ash_html'>Active Samples: num of samples for top current SQL</li>
<li class='ash_html'>% Activity: activity percentage for given SQL ID</li>
<li class='ash_html'>Sampled Executions: represents the number of times the current SQL execution has been sampled</li>
<li class='ash_html'>Top Operator: top operator name for current SQL plan</li>
<li class='ash_html'>% Operator: activity percentage for given operator</li>
<li class='ash_html'>Top Event: top event name for current operator</li>
<li class='ash_html'>% Event: activity percentage for given event</li>
</ul>
<table id="2614023125399793780" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">SQL ID</th><th class="ash_htmlbg" scope="col">Plan Hash</th><th class="ash_htmlbg" scope="col">Active Samples</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">Sampled Executions</th><th class="ash_htmlbg" scope="col">Top Operator</th><th class="ash_htmlbg" scope="col">% Operator</th><th class="ash_htmlbg" scope="col">Top Event</th><th class="ash_htmlbg" scope="col">% Event</th><th class="ash_htmlbg" scope="col">SQL Text</th></tr></table><p />
<a class="ash_html" name='Top PL/SQL Procedures'></a>          <h2 class="ash_html">Top PL/SQL Procedures<br></h2><ul><li class='ash_html'>"PL/SQL Entry Subprogram" represents the application's top-level entry-point(procedure, function, trigger, package initialization) into PL/SQL.</li>
<li class='ash_html'>"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.</li>
<li class='ash_html'>"PL/SQL Entry Subprogram" represents the application's top-level subprogram name</li>
</ul>
<table id="16550835464327228232" class="normal merge_cell" border="1"><tr><th class="ash_htmlbg" scope="col">PLSQL Entry Subprogram</th><th class="ash_htmlbg" scope="col">% Activity</th><th class="ash_htmlbg" scope="col">PLSQL Current Subprogram</th><th class="ash_htmlbg" scope="col">% Current</th></tr></table><p />
<a class="ash_html" name='Complete List of SQL Text'></a>          <h2 class="ash_html">Complete List of SQL Text<br></h2><table id="472260429780264946" class="normal" border="1"><tr><th class="ash_htmlbg" scope="col">SQL ID</th><th class="ash_htmlbg" scope="col">SQL Text</th></tr><tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="1DCD1A13FF867BD1C03DE1582C274EE6"></a>1DCD1A13FF867BD1C03DE1582C274EE6</td>
<td class='ash_htmlc'>SELECT DBMS_WORKLOAD_REPOSITORY.ASH_REPORT_TEXT(:0, :1,:2,:3,:4, :6, :7, :8, LOWER(:5)) AS REPORT</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="32AB97A0126F566064F84DDDF4936F82"></a>32AB97A0126F566064F84DDDF4936F82</td>
<td class='ash_htmlnc'>SELECT * FROM __all_ls_meta_table WHERE tenant_id = ? ORDER BY tenant_id, ls_id, svr_ip, svr_port</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="1A01F4CAC17DA8C38C9BF4909F7D9BB9"></a>1A01F4CAC17DA8C38C9BF4909F7D9BB9</td>
<td class='ash_htmlc'>WITH session_data AS (SELECT sql_id, svr_ip, svr_port, session_id, trace_id,  plan_hash, sql_plan_line_id, event_no, CAST(IF (event_no = ?, ?, event) AS CHAR(64))  AS event, time_model, count_weight, action FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="DB6D1C21FFA60ECAA8DA632C54E77752"></a>DB6D1C21FFA60ECAA8DA632C54E77752</td>
<td class='ash_htmlnc'>WITH session_data AS (SELECT svr_ip, svr_port, session_id, CAST(IF (event_no = ?, ?, event) AS CHAR(64)) AS event, CAST(IF (event_no = ?, ?, wait_class) AS CHAR(64)) AS wait_class, event_no, sql_id, plan_hash, trace_id, program, count_weight FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LI</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="45B3D06C663D68113AFD35E24947F7E7"></a>45B3D06C663D68113AFD35E24947F7E7</td>
<td class='ash_htmlc'>WITH session_data AS (SELECT svr_ip, svr_port, program, module, action, sql_id, plan_hash, delta_read_io_requests, delta_read_io_bytes, delta_write_io_requests, delta_write_io_bytes, tablet_id, count_weight, tm_delta_time FROM ( SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID </td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="AE6AAA45F76278C5D07446959A258989"></a>AE6AAA45F76278C5D07446959A258989</td>
<td class='ash_htmlnc'>WITH session_data AS (SELECT sql_id, stmt_type, event_no, count_weight, svr_ip, svr_port, trace_id,session_id, time_model FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_ID, WR.STMT_TYPE AS STMT_TYPE, WR.PROG</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="7D3B8C4BCD66733251F4F7601799F30D"></a>7D3B8C4BCD66733251F4F7601799F30D</td>
<td class='ash_htmlc'>WITH session_data AS (SELECT plsql_entry_object_id, plsql_entry_subprogram_id, plsql_entry_subprogram_name, plsql_object_id, plsql_subprogram_id, plsql_subprogram_name, CAST(CASE WHEN (TIME_MODEL & ?) > ? THEN ? ELSE ? END AS CHAR(1)) AS IN_PLSQL_COMPILATION, CAST(CASE WHEN (TIME_MODEL & ?) > ? THEN ? ELSE ? END AS CHAR(1)) AS IN_PLSQL_EXECUTION, CAST(CASE WHEN (TIME_MODEL & ?) > ? THEN ? ELSE ? END AS CHAR(1)) AS IN_SQL_EXECUTION, time_model, count_weight FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 A</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="543F534A64169F20873AB8189D804C90"></a>543F534A64169F20873AB8189D804C90</td>
<td class='ash_htmlnc'>WITH session_data AS (SELECT CAST(IF (event_no = ?, ?, event) AS CHAR(64)) AS event, CAST(IF (event_no = ?, ?, wait_class) AS CHAR(64)) AS wait_class, SUM(count_weight) AS event_time, CONCAT(svr_ip, ?, svr_port) AS node, CASE WHEN program IS NULL THEN ? ELSE program END AS program, CASE WHEN module IS NULL THEN ? ELSE module END AS module, CASE WHEN action IS NULL THEN ? ELSE action END AS action FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO =</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="CF2AADDE69A639BC676C2E9E772A1AF0"></a>CF2AADDE69A639BC676C2E9E772A1AF0</td>
<td class='ash_htmlc'>SELECT zone FROM __all_server where svr_ip=? and svr_port=?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="0DB6919F9B66178BA969E950C30C2AE1"></a>0DB6919F9B66178BA969E950C30C2AE1</td>
<td class='ash_htmlnc'>WITH session_data AS (SELECT session_type,sql_id,trace_id,time_model,count_weight,svr_ip, svr_port, session_id FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_ID, WR.STMT_TYPE AS STMT_TYPE, WR.PROGRAM AS PROG</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="D918D505E3D554101A8153107A5D4174"></a>D918D505E3D554101A8153107A5D4174</td>
<td class='ash_htmlc'>WITH session_data AS(SELECT blocking_session_id, event, p1 AS holder_tx_id, p2 AS holder_data_seq, tx_id, sql_id, count_weight, trace_id, event_id,  session_id FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="AFF6D863C784CC7E0A5141BD75242EF9"></a>AFF6D863C784CC7E0A5141BD75242EF9</td>
<td class='ash_htmlnc'>WITH session_data AS (SELECT event_no, event, wait_class, count_weight, slot_begin_time, slot_end_time, UNIX_TIMESTAMP(slot_end_time) - UNIX_TIMESTAMP(slot_begin_time) AS interval_time FROM (SELECT event_no, event, wait_class, count_weight, CASE WHEN slot_begin_time < min_sample_time THEN min_sample_time ELSE slot_begin_time END AS slot_begin_time, CASE WHEN slot_end_time > max_sample_time THEN max_sample_time ELSE slot_end_time END AS slot_end_time FROM (SELECT event_no, event, wait_class, count_weight, FROM_UNIXTIME(utc_seconds - (utc_seconds % interval_time)) AS slot_begin_time, FROM_UNIXTIME(utc_seconds + interval_time - (utc_seconds % interval_time)) AS slot_end_time, ? AS min_sample_time, ? AS max_sample_time FROM (SELECT event_no, count_weight, ? AS interval_time, CASE WHEN event_no = ? THEN ? ELSE event END AS event, CASE WHEN event_no = ? THEN ? ELSE wait_class END AS wait_class, CAST(UNIX_TIMESTAMP(sample_time) AS SIGNED) AS utc_seconds FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SV</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="6F3109B2EDC153980E1722318E4F6240"></a>6F3109B2EDC153980E1722318E4F6240</td>
<td class='ash_htmlc'>SELECT value FROM __all_zone where zone=? and name=?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="F072EFE2E438832E4CFCFC0E47D09E98"></a>F072EFE2E438832E4CFCFC0E47D09E98</td>
<td class='ash_htmlnc'>SELECT CAST(IF (EVENT_NO = ?, ?, EVENT) AS CHAR(64)) AS EVENT, SUM(count_weight) AS CNT FROM (SELECT * FROM (SELECT WR.TIME_MODEL AS TIME_MODEL, WR.SVR_IP AS SVR_IP, WR.SVR_PORT AS SVR_PORT, WR.SAMPLE_TIME AS SAMPLE_TIME, WR.TENANT_ID AS TENANT_ID, WR.USER_ID AS USER_ID, WR.SESSION_ID AS SESSION_ID,  CAST(IF (SESSION_TYPE = ?, ?, ?) AS CHAR(10)) AS SESSION_TYPE, WR.SQL_ID AS SQL_ID, WR.PLAN_ID AS PLAN_ID, WR.TRACE_ID AS TRACE_ID, CAST(IF (EVENT_NO = ?, ?, EVENT_NAME) AS CHAR(64)) AS EVENT, WR.EVENT_NO AS EVENT_NO, WR.EVENT_ID AS EVENT_ID, WR.P1 AS P1, WR_EVENT_NAME.PARAMETER1 AS P1TEXT, WR.P2 AS P2, WR_EVENT_NAME.PARAMETER2 AS P2TEXT, WR.P3 AS P3, WR_EVENT_NAME.PARAMETER3 AS P3TEXT, CAST(IF (EVENT_NO = ?, ?, WAIT_CLASS) AS CHAR(64)) AS WAIT_CLASS, WR_EVENT_NAME.WAIT_CLASS_ID AS WAIT_CLASS_ID, WR.TIME_WAITED AS TIME_WAITED, WR.SQL_PLAN_LINE_ID AS SQL_PLAN_LINE_ID, WR.GROUP_ID AS GROUP_ID, WR.PLAN_HASH AS PLAN_HASH, WR.THREAD_ID AS THREAD_ID, WR.STMT_TYPE AS STMT_TYPE, WR.PROGRAM AS PROGRAM, WR.MODULE AS MODUL</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="5610A1050E9A34F45A5517F5A3FFA2A6"></a>5610A1050E9A34F45A5517F5A3FFA2A6</td>
<td class='ash_htmlc'>SELECT info FROM __all_zone where zone = ? and name = ?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="24D486F20861EBD9E0217692DB0E9C61"></a>24D486F20861EBD9E0217692DB0E9C61</td>
<td class='ash_htmlnc'>update __all_weak_read_service set min_version=?, max_version=?     where tenant_id = ? and level_id = ? and level_value = ? and min_version = ? and max_version = ?</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="3468E7114C438006DD0574C9657EF3BF"></a>3468E7114C438006DD0574C9657EF3BF</td>
<td class='ash_htmlc'>select * from __all_tenant_scheduler_job where tenant_id = ? and job_name = ? and job = ?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="1D0BA376E273B9D622641124D8C59264"></a>1D0BA376E273B9D622641124D8C59264</td>
<td class='ash_htmlnc'>COMMIT</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="24431689903B50E19BD2C735F168E448"></a>24431689903B50E19BD2C735F168E448</td>
<td class='ash_htmlc'>SELECT * FROM __all_vector_index_task where trigger_type = ? AND status = ? AND tablet_id != ?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="B7A6FA97FEC98C06F9586D23935AC4C6"></a>B7A6FA97FEC98C06F9586D23935AC4C6</td>
<td class='ash_htmlnc'>START TRANSACTION</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="D9EB4937E65F94AA38F6B0FE72B06D13"></a>D9EB4937E65F94AA38F6B0FE72B06D13</td>
<td class='ash_htmlc'>SELECT column_value FROM __all_core_table WHERE TABLE_NAME = ? AND COLUMN_NAME = ?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="858015B92843B43D99CA77541C4C2592"></a>858015B92843B43D99CA77541C4C2592</td>
<td class='ash_htmlnc'>SELECT VALUE FROM __all_sys_stat WHERE ZONE = ? AND NAME = ? AND TENANT_ID = ? FOR UPDATE</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="69D4EC82CE11CB6BA481591FD96467E2"></a>69D4EC82CE11CB6BA481591FD96467E2</td>
<td class='ash_htmlc'>SELECT value from oceanbase.__all_sys_stat where name = ?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="421077B5841DBAAC88F5E2AE5B8082F8"></a>421077B5841DBAAC88F5E2AE5B8082F8</td>
<td class='ash_htmlnc'>SELECT tenant_id, svr_ip, svr_port, migrate_from_svr_ip, migrate_from_svr_port from __all_unit unit join __all_resource_pool pool on unit.resource_pool_id = pool.resource_pool_id where tenant_id != ? order by tenant_id</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="9CA2F8D24467EB1A28CA50EE09743A86"></a>9CA2F8D24467EB1A28CA50EE09743A86</td>
<td class='ash_htmlc'>SELECT * FROM __all_acquired_snapshot WHERE tenant_id = ?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="FD4390F00BA50EBCC4BBAE0C3A06BD8E"></a>FD4390F00BA50EBCC4BBAE0C3A06BD8E</td>
<td class='ash_htmlnc'>SELECT column_value FROM __all_core_table WHERE TABLE_NAME = ? AND COLUMN_NAME = ? FOR UPDATE</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="A300863F1A27D37B8CFAD64C08892CEF"></a>A300863F1A27D37B8CFAD64C08892CEF</td>
<td class='ash_htmlc'>DELETE FROM oceanbase.__all_dbms_lock_allocated WHERE expiration <= usec_to_time(?)AND lockid NOT IN( SELECT obj_id FROM oceanbase.__all_detect_lock_info_v2 WHERE obj_type = ? or obj_type = ? ) LIMIT ?</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="556CEFD22F28DDDCB6E283DF89BD9348"></a>556CEFD22F28DDDCB6E283DF89BD9348</td>
<td class='ash_htmlnc'>UPDATE __all_core_table SET column_value = ? WHERE table_name = ? AND column_name = ? AND column_value < ?</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="48CEB0A0959F23770F34CB064EA1A1EA"></a>48CEB0A0959F23770F34CB064EA1A1EA</td>
<td class='ash_htmlc'>SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `svr_ip`, `svr_port`, `sample_time`, `event_id`, `group_id`, `program`, `module`, `action` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="7F4BF0A21CBDBB436BAFAB2674482F89"></a>7F4BF0A21CBDBB436BAFAB2674482F89</td>
<td class='ash_htmlnc'>SELECT * FROM __all_unit WHERE (svr_ip = ? AND svr_port = ?) or (migrate_from_svr_ip = ? AND migrate_from_svr_port = ?)</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="6D076E4DC9EFCD54B69932B70F5F9212"></a>6D076E4DC9EFCD54B69932B70F5F9212</td>
<td class='ash_htmlc'>SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `sample_time`, `event_no`, `event_id` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="6FF93F6AA5BE8A3A69BD6DEB867CC7B1"></a>6FF93F6AA5BE8A3A69BD6DEB867CC7B1</td>
<td class='ash_htmlnc'>SELECT CAST(MVIEW_ID AS UNSIGNED) AS MVIEW_ID,                               LAST_REFRESH_SCN,                               CAST(REFRESH_MODE AS UNSIGNED) AS REFRESH_MODE                               FROM `oceanbase`.`__all_mview`                               WHERE TENANT_ID = ? and REFRESH_MODE = ?</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="95C9A6346A2B1546D243358F32684FAB"></a>95C9A6346A2B1546D243358F32684FAB</td>
<td class='ash_htmlc'>SELECT *, time_to_usec(gmt_modified) AS last_hb_time FROM __all_server</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="4C7CBDC327592A4B6E26F94324B5ABA4"></a>4C7CBDC327592A4B6E26F94324B5ABA4</td>
<td class='ash_htmlnc'>SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `svr_ip`, `svr_port`, `sample_time`, `sql_id`, `event_id`, `time_waited`, `p1`, `p2`, `p3`, `plan_hash`, `program`, `module`, `action` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="58F593697294BBBE422235CCA6DE1A0F"></a>58F593697294BBBE422235CCA6DE1A0F</td>
<td class='ash_htmlc'>SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `svr_ip`, `svr_port`, `sample_time`, `event_no`, `sql_id`, `trace_id`, `event_id`, `module`, `action`, `tablet_id` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="1B26C909437A4F990E0D2E2FF2EEA6F4"></a>1B26C909437A4F990E0D2E2FF2EEA6F4</td>
<td class='ash_htmlnc'>SELECT owner_type,owner_id FROM oceanbase.__all_detect_lock_info_v2 WHERE detect_func_no = ? GROUP BY owner_id</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="DD8EDF5E46C4D63C6DD7690E9BF472E1"></a>DD8EDF5E46C4D63C6DD7690E9BF472E1</td>
<td class='ash_htmlc'>SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `sample_time`, `event_id`, `time_model`, `plsql_entry_object_id`, `plsql_entry_subprogram_id`, `plsql_entry_subprogram_name`, `plsql_object_id`, `plsql_subprogram_id`, `plsql_subprogram_name` FROM `__wr_active_session_history` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC, `sample_id` ASC, `session_id` ASC</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="1C2A2CCE80094591D6F75AD5DF9F4227"></a>1C2A2CCE80094591D6F75AD5DF9F4227</td>
<td class='ash_htmlnc'>DELETE FROM __all_vector_index_task_history WHERE gmt_modified < usec_to_time(?) LIMIT ?</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="27684485F6F0D9BBE5A31381AE814D3B"></a>27684485F6F0D9BBE5A31381AE814D3B</td>
<td class='ash_htmlc'>SELECT EXISTS (SELECT ? FROM `oceanbase`.`__all_mview_dep` t1, `oceanbase`.`__all_mview_dep` t2 WHERE t1.mview_id = t2.p_obj AND t1.tenant_id = ?) as exist_nested</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="5A4B823D62DB0A70CA1B9386414D3B50"></a>5A4B823D62DB0A70CA1B9386414D3B50</td>
<td class='ash_htmlnc'>SELECT /*+ query_timeout(3216672000000000) */ effective_tenant_id(), `data_table_id`, `table_type`, `table_name` FROM `__all_table` WHERE ?=? AND tenant_id = ? ORDER BY `table_id` ASC</td>
</tr>

<tr><td scope="row" class='ash_htmlc'><a class="ash_html" name="01C101F1B479299F470599A9302BE7A1"></a>01C101F1B479299F470599A9302BE7A1</td>
<td class='ash_htmlc'>SELECT /*+ query_timeout(3216672000000000) */ `tenant_id`, `cluster_id`, `snap_id`, `status` FROM `__wr_snapshot` WHERE ?=? AND tenant_id = ? ORDER BY `cluster_id` ASC, `snap_id` ASC, `svr_ip` ASC, `svr_port` ASC</td>
</tr>

<tr><td scope="row" class='ash_htmlnc'><a class="ash_html" name="AF6EB4B3612A1A358ED582F6F0D8FFA5"></a>AF6EB4B3612A1A358ED582F6F0D8FFA5</td>
<td class='ash_htmlnc'>SELECT /*+ query_timeout(3216672000000000) */ effective_tenant_id(), `table_id`, `part_id`, `partition_type`, `sub_part_name`, `tablet_id` FROM `__all_sub_part` WHERE ?=? AND tenant_id = ? ORDER BY `table_id` ASC, `part_id` ASC, `sub_part_id` ASC</td>
</tr>

</table><p />
End of Report       <script>         (() => {          const styles = document.createElement('style');          styles.innerHTML = `            .actions {              position: relative;              cursor: pointer;            }            .actions:hover {              color: #00e;            }            .actions:hover::before {              content: 'view detail';              position: absolute;              left: 0;              top: 0;              transform: translateY(-120%);              background: rgba(0 0 0/.6);              color: #fff;              font-size: 12px;              padding: 2px;              line-height: 1.4;            }            .mask.actions {              cursor: default;            }            .mask.actions:hover {              color: currentColor;            }            .drawer {              position: fixed;              display: flex;              flex-direction: column;              right: 0;              top: 0;              bottom: 0;              width: 100%;              max-width: 1024px;              background: #fff;              box-shadow: 0 0 10px rgba(0 0 0/0.15);            }            .mask {              position: fixed;              left: 0;              right: 0;              top: 0;              bottom: 0;              z-index: 100;              overflow: hidden;              box-sizing: border-box;            }            .drawer {              animation: slide-in .3s ease-in;            }            .drawer header {              padding: 24px;              margin-right: 100px;              box-sizing: border-box;            }            .drawer main {              padding: 24px;              box-sizing: border-box;              font-weight: normal;              overflow: auto;              overscroll-behavior: none;            }            .drawer main > section {              margin: 10px 0 20px;            }            .drawer .close {              position: absolute;              right: 10px;              top: 6px;              -webkit-appearance: none;              border: none;              background: transparent;              cursor: pointer;              padding: 4px;              line-height: 1.6;              color: #00e;            }            .hide-table {              height: 0;              overflow: hidden;              position: absolute;              visibility: hidden;            }            @keyframes slide-in {              from {                transform: translateX(100%);              }              to {                transform: translateX(0);              }            }        `;          document.head.appendChild(styles);                  const findTableById = id => [...document.querySelectorAll('table[id]')].filter(t => t.id === id.trim())[0] || null;                  const html = `        <div class="mask actions" data-action-params="actionType=close" style="display:none;">          <div class="drawer">            <button class="actions close" data-action-params="actionType=close">[close]</button>        <header>{title}</header>            <main>content</main>          </div>        </div>        `;          const attach = document.createElement('div');          attach.innerHTML = html;          document.body.appendChild(attach);                  document.body.addEventListener('click', e => {            const hasAction = e.target.classList.contains('actions');            if (!hasAction) {              return;            }            if (!e.target.dataset.actionParams) {              return;            }            const params = new URLSearchParams(e.target.dataset.actionParams);            e.preventDefault();            e.stopPropagation();            const actionType = params.get('actionType') || 'view';            const title = params.get('title') || '';            const width = params.get('width');            const tableIds = (params.get('tableIds') || '').split(',').filter(e => e);            const rowIds = (params.get('rowIds') || '').split(',').filter(e => e);            if (actionType === 'close') {              attach.querySelector('.mask').style.display = 'none';              return;            }                    attach.querySelector('.mask').style.display = 'block';            attach.querySelector('.mask .drawer > header').style.display = title ? 'block' : 'none';            if (title) {              attach.querySelector('.mask .drawer > header').innerHTML = attach.querySelector('.mask .drawer > header').innerHTML.replace('{title}', title);            }                    htmlString = [];            const tableSize = [];            tableIds.forEach(tid => {              const t = findTableById(tid);              if (!t) {                throw new Error('[JS ERR] table id no find.');              }              tableSize.push(t.getBoundingClientRect().width);              htmlString.push(`<section>${t.outerHTML.replaceAll('data-action-params', 'data-none')                .replaceAll('hide-table', '')                }</section>`);            });            attach.querySelector('.mask .drawer').style.cssText = `max-width:${width || (Math.max(...tableSize) || 0) + 60}px`;            attach.querySelector('.mask .drawer > main').innerHTML = htmlString.join('');                    if (rowIds.length) {              document.querySelectorAll('.mask .drawer > main > section > table > tbody > tr').forEach((row, i) => {                if (row.querySelectorAll('th').length) {                  return;                }                row.style.display = rowIds.includes((row.dataset.rowId || '').trim()) ? 'table-row' : 'none';              });            }          }, false);          document.addEventListener('keydown', function(event) {            if (event.keyCode === 27) {              document.querySelector('.mask').style.display = 'none';            }          });        })();      </script>       </body></html>
1 row in set (5.496 sec)

Query OK, 0 rows affected (5.498 sec)