如何检查Oracle数据库以查找长时间运行的查询

SELECT *
FROM DBA_HIST_ACTIVE_SESS_HISTORY
WHERE ELAPSED_TIME > 60 -- 查找运行时间超过60秒的查询
ORDER BY ELAPSED_TIME DESC;

SELECT *
FROM DBA_HIST_SQLSTAT
WHERE ELAPSED_TIME > 60 -- 查找运行时间超过60秒的查询
ORDER BY ELAPSED_TIME DESC;

SELECT *
FROM TABLE(DBMS_STATS.GET_PLAN_STATS)
WHERE ELAPSED_TIME > 60 -- 查找运行时间超过60秒的查询
ORDER BY ELAPSED_TIME DESC;

SELECT *
FROM DBA_HIST_SYSSTAT
WHERE ELAPSED_TIME > 60 -- 查找运行时间超过60秒的查询
ORDER BY ELAPSED_TIME DESC;