oracle 查询SQL 的执行速度

最新推荐文章于 2024-02-01 17:55:34 发布

weixin_30426065

最新推荐文章于 2024-02-01 17:55:34 发布

阅读量541

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/ss-33/p/8601708.html

版权

SELECT SE.SID,
       OPNAME,
       TRUNC(SOFAR / TOTALWORK * 100, 2) || '%' AS PCT_WORK,
       ELAPSED_SECONDS ELAPSED,
       ROUND(ELAPSED_SECONDS * (TOTALWORK - SOFAR) / SOFAR) REMAIN_TIME,
       SQL_TEXT
FROM V$SESSION_LONGOPS SL, V$SQLAREA SA, V$SESSION SE
WHERE SL.SQL_HASH_VALUE = SA.HASH_VALUE
   AND SL.SID = SE.SID
   AND SOFAR != TOTALWORK
--and SE.SID = 459
ORDER BY START_TIME;

转载于:https://www.cnblogs.com/ss-33/p/8601708.html