V$SESSION_LONGOPS

最新推荐文章于 2021-06-03 14:07:16 发布

aicon

最新推荐文章于 2021-06-03 14:07:16 发布

阅读量467

点赞数

分类专栏： Oracle Oracle EBS 文章标签： session statistics application query include oracle

Oracle 同时被 2 个专栏收录

523 篇文章 0 订阅

订阅专栏

Oracle EBS

416 篇文章 0 订阅

订阅专栏

V$SESSION_LONGOPS
This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Oracle release.

To monitor query execution progress, you must be using the cost-based optimizer and you must:

Set the TIMED_STATISTICS or SQL_TRACE parameter to true
Gather statistics for your objects with the ANALYZE statement or the DBMS_STATS package
You can add information to this view about application-specific long-running operations by using the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure.

from:http://www.itpub.net/thread-312128-1-1.html