V$SESSION_LONGOPS

V$SESSION_LONGOPS视图解析

最新推荐文章于 2025-08-31 09:54:39 发布

转载最新推荐文章于 2025-08-31 09:54:39 发布 · 508 阅读

文章标签：

#session #statistics #application #query #include #oracle

Oracle 同时被 2 个专栏收录

523 篇文章

订阅专栏

Oracle EBS

416 篇文章

订阅专栏

本文介绍Oracle数据库中V$SESSION_LONGOPS视图的功能和使用方法。该视图用于监控运行时间超过6秒的操作状态，包括备份、恢复、统计信息收集及查询执行等。为了跟踪查询执行进度，需启用成本基础优化器并设置TIMED_STATISTICS或SQL_TRACE参数为true。此外，可通过DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS过程添加应用程序特定的长时间运行操作信息。

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