查询sql执行速度慢的记录:
SELECT
usec_to_time(REQUEST_TIME) AS start_time,
elapsed_time/1000 AS query_time,
query_sql AS sql_text,
user_name AS user_host,
svr_ip AS db
FROM gv$ob_sql_audit
WHERE
query_sql LIKE ‘%unfinished_count%’
AND usec_to_time(REQUEST_TIME) > ‘2025-12-08’
ORDER BY elapsed_time DESC, request_time DESC
SELECT /ligang1418/
a.order_id,
a.use_type,
( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
(h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
h.sensi_flag in (2,96,97) ) sensi_count,
( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
h.sensi_flag in (98,99)) black_count,
u.censor_flag,u.sensi_handle_flag
FROM
t_order a
LEFT JOIN t_set s ON a.set_id = s.set_id
LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
WHERE
a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = ‘woqu’
AND a.state_date < DATE_ADD(now(),INTERVAL - 60 SECOND)
AND a.state = ‘00’
AND a.checked_flag is null;
