Oracle教程 2023-04-05

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

V$SERVICE_EVENT是一个关于服务级别的显示视图，它显示可能的服务级别及其定义的公用统计信息。这个视图是一种反映按照常规服务器操作指南定义的服务事件的方式。

V$SERVICE_EVENT可以用来跟踪和定位服务级别事件，帮助查找定位可能造成繁忙时间的原因。

使用V$SERVICE_EVENT视图需要在服务管理器者定义好服务级别事件，任何服务级别事件都可以在V$SERVICE_EVENT视图中查看。

例如，可以使用以下查询检索当前服务级别定义：

SELECT *
FROM v$service_event;

V$SERVICE_EVENT displays aggregated wait counts and wait times for each wait statistic.

Column	Datatype	Description
`SERVICE_NAME`	`VARCHAR2(64)`	Service name from `V$SERVICES`
`SERVICE_NAME_HASH`	`NUMBER`	Service name hash from `V$SERVICES`
`EVENT`	`VARCHAR2(64)`	Name of the wait event; derived statistic name from `V$EVENT_NAME` See Also: “Oracle Wait Events”
`EVENT_ID`	`NUMBER`	Identifier of the wait event
`TOTAL_WAITS`	`NUMBER`	Total number of waits for the event by the service
`TOTAL_TIMEOUTS`	`NUMBER`	Total number of timeouts for the event by the service
`TIME_WAITED`	`NUMBER`	Total amount of time waited for the event by the service (in hundredths of a second)
`AVERAGE_WAIT`	`NUMBER`	Average amount of time waited for the event by the service (in hundredths of a second)
`MAX_WAIT`	`NUMBER`	Maximum amount of time waited for the event by the service (in hundredths of a second)
`TIME_WAITED_MICRO`	`NUMBER`	Total amount of time waited for the event by the service (in microseconds)
`CPU`	`NUMBER`	Total amount of CPU time consumed by the service while implementing the wait event itself (in microseconds)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：