查找系统中近一小时执行时间较长的前10条sql
1、找到耗时较久的sql的sql_id
SELECT ACTIVITY_PCT, DB_TIME, SQL_ID
FROM (SELECT ROUND(100 * RATIO_TO_REPORT(COUNT(1)) OVER(), 1
查找系统中近一小时执行时间较长的前10条sql
1、找到耗时较久的sql的sql_id
SELECT ACTIVITY_PCT, DB_TIME, SQL_ID
FROM (SELECT ROUND(100 * RATIO_TO_REPORT(COUNT(1)) OVER(), 1