Oracle教程

Oracle 视图 V$EMON 官方解释，作用，如何使用详细说明

本站中文解释

_ACTIVITY视图

Oracle V$EMON_ACTIVITY视图是Oracle提供的开箱即用的系统视图，用于显示当前正在运行的数据库实例中的活动会话。它表示各种活动和上下文，例如会话状态、现在正在运行的程序、资源、会话等。

V$EMON_ACTIVITY视图提供用于监控系统性能的全局活动请求和参数。但是，它没有性能参数，而是指示了当前用户会话和其他活动，可以根据需要找出任何活动会话，以及其余各种活动状态，如会话状态和暂停原因。

V$EMON_ACTIVITY视图通常由数据库管理员用于监控“数据库实例”的活动，以帮助识别和解决活动和性能问题，并用于活动和性能分析。如果要使用V$EMON_ACTIVITY视图，则需要打开相应的控制文件参数，即MONITORING控制文件参数，以激活V$EMON_ACTIVITY视图的显示功能。

官方英文解释

V$EMON displays performance statistics per event monitor (EMON) slave for diagnosability of notifications. All processing time and latency is in seconds.

Column Datatype Description

EMON#

NUMBER

EMON identifier (0 – 9)

SID

NUMBER

Session identifier

STARTUP_TIME

TIMESTAMP(3) WITH TIME ZONE

Time when this EMON slave was started

SERVER_TYPE

VARCHAR2(8)

Notification quality of the service provided by EMON:

  • REGULAR

  • RELIABLE

STATUS

VARCHAR2(6)

EMON status:

  • IDLE

  • ACTIVE

STATUS_CHANGE_TIME

TIMESTAMP(3) WITH TIME ZONE

Time at which EMON switched to the current STATUS

NUM_NTFNS

NUMBER

Total number of notifications (including grouping notifications)

NUM_GROUPING_NTFNS

NUMBER

Number of grouping notifications

NUM_NTFNS_ALL_GROUPS

NUMBER

Total number of events in all notification groups

NUM_OCI_NTFNS

NUMBER

Number of OCI notifications

NUM_PLSQL_NTFNS

NUMBER

Number of PL/SQL notifications

NUM_EMAIL_NTFNS

NUMBER

Number of E-mail notifications

NUM_HTTP_NTFNS

NUMBER

Number of HTTP notifications

NUM_EVENTS_PROCESSED

NUMBER

Number of events posted by a publisher for which notifications have been delivered

NUM_EVENTS_PENDING

NUMBER

Number of events posted by a publisher for which notifications are not yet delivered

NUM_ANONYMOUS_NTFNS

NUMBER

Number of anonymous notifications

NUM_AQ_NTFNS

NUMBER

Number of AQ notifications

NUM_DBCHANGE_NTFNS

NUMBER

Number of DBChange notifications

TOTAL_ANONYMOUS_NTFN_TIME

NUMBER

Total time to process Anonymous notifications

TOTAL_AQ_NTFN_TIME

NUMBER

Total time to process AQ notifications

TOTAL_DBCHANGE_NTFN_TIME

NUMBER

Total time to process dbchange notifications

TOTAL_PLSQL_NTFN_TIME

NUMBER

Total time to process PL/SQL notifications

TOTAL_OCI_NTFN_TIME

NUMBER

Total time to process OCI notifications

TOTAL_EMAIL_NTFN_TIME

NUMBER

Total time to process E-mail notifications

TOTAL_HTTP_NTFN_TIME

NUMBER

Total time to process HTTP notifications

TOTAL_EMON_LATENCY

NUMBER

Total latency in processing events

REGISTRATIONS_EXPIRED

NUMBER

Number of expired registrations

REGISTRATIONS_PURGED

NUMBER

Number of purged registrations

REGISTRATIONS_INVALID

NUMBER

Number of registrations invalidated due to notification delivery failure

LAST_UPDATE_TIME

TIMESTAMP(3) WITH TIME ZONE

Time when statistics were last updated

CON_ID

NUMBER

The ID of the container to which the data pertains. The CON_ID value in this view is always 0. The rows pertain to the entire CDB or to the non-CDB.


数据运维技术 » Oracle 视图 V$EMON 官方解释，作用，如何使用详细说明
分享到：

相关推荐