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

网络编程 Oracle 视图 V$EMON 官方解释，作用，如何使用详细说明 10-15

本站中文解释

_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.

编辑：568数据

标签：视图,性能,状态,参数,数据库