mysql> SELECT MAX(ELAPSED_TIME),* FROM GV$OB_SQL_AUDIT WHERE QUERY_SQL like 'insert into widenetwork.pppoe_User_x%'\G *************************** 1. row *************************** MAX(ELAPSED_TIME): 11930 SVR_IP: 133.197.204.3 SVR_PORT: 2882 REQUEST_ID: 331744484 SQL_EXEC_ID: 653883919 TRACE_ID: YB4285C5CC03-0005EEB0B83692BC-0-0 SID: 3221688174 CLIENT_IP: 133.197.204.3 CLIENT_PORT: 53190 TENANT_ID: 1002 TENANT_NAME: daren EFFECTIVE_TENANT_ID: 1002 USER_ID: 200001 USER_NAME: root USER_GROUP: 0 USER_CLIENT_IP: 10.60.253.145 DB_ID: 500008 DB_NAME: wcn SQL_ID: 3042BFF5F3B319CC595D91AA9A5E5E34 QUERY_SQL: insert into widenetwork.pppoe_User_x (facility, isdx, node_number, oltip, oltjx, oltpon, phone, qyId, qzdsphone, serialNumber, username, whry, whwg, whwgId, xq, zjdz, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) PLAN_ID: 83546 AFFECTED_ROWS: 1 RETURN_ROWS: 0 PARTITION_CNT: 1 RET_CODE: 0 QC_ID: 0 DFO_ID: 0 SQC_ID: 0 WORKER_ID: 0 EVENT: P1TEXT: P1: 0 P2TEXT: P2: 0 P3TEXT: P3: 0 LEVEL: 0 WAIT_CLASS_ID: 100 WAIT_CLASS#: 0 WAIT_CLASS: OTHER STATE: MAX_WAIT TIME ZERO WAIT_TIME_MICRO: 0 TOTAL_WAIT_TIME_MICRO: 0 TOTAL_WAITS: 0 RPC_COUNT: 0 PLAN_TYPE: 1 IS_INNER_SQL: 0 IS_EXECUTOR_RPC: 0 IS_HIT_PLAN: 1 REQUEST_TIME: 1672038481869938 ELAPSED_TIME: 1519 NET_TIME: 0 NET_WAIT_TIME: 5 QUEUE_TIME: 53 DECODE_TIME: 2 GET_PLAN_TIME: 221 EXECUTE_TIME: 867 APPLICATION_WAIT_TIME: 0 CONCURRENCY_WAIT_TIME: 0 USER_IO_WAIT_TIME: 0 SCHEDULE_TIME: 0 ROW_CACHE_HIT: 0 BLOOM_FILTER_CACHE_HIT: 1 BLOCK_CACHE_HIT: 4 DISK_READS: 0 RETRY_CNT: 0 TABLE_SCAN: 0 CONSISTENCY_LEVEL: 3 MEMSTORE_READ_ROW_COUNT: 0 SSSTORE_READ_ROW_COUNT: 1 DATA_BLOCK_READ_CNT: 2 DATA_BLOCK_CACHE_HIT: 2 INDEX_BLOCK_READ_CNT: 5 INDEX_BLOCK_CACHE_HIT: 2 BLOCKSCAN_BLOCK_CNT: 0 BLOCKSCAN_ROW_CNT: 0 PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0 REQUEST_MEMORY_USED: 67168 EXPECTED_WORKER_COUNT: 0 USED_WORKER_COUNT: 0 SCHED_INFO: NULL FUSE_ROW_CACHE_HIT: 0 PS_CLIENT_STMT_ID: 3 PS_INNER_STMT_ID: 85 TX_ID: 62181348 SNAPSHOT_VERSION: 0 REQUEST_TYPE: 6 IS_BATCHED_MULTI_STMT: 0 OB_TRACE_INFO: NULL PLAN_HASH: 3290318591324336132 LOCK_FOR_READ_TIME: 0