Oracle教程 2023-04-08

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

本站中文解释

Oracle视图V$SERV_MOD_ACT_STATS视图记录从功能模块被激活到服务进程终止的每一次服务请求的统计信息。它记录各项活动的起始和结束时间，活动的名字，响应时间以及服务的负载请求量等信息。

它的用途是用于查看服务请求的统计信息，从而可以观察服务器性能的变化。

可以使用下面的语句来返回V$SERV_MOD_ACT_STATS视图的数据：

select * from v$serv_mod_act_stats;

官方英文解释

V$SERV_MOD_ACT_STATS displays the same set of performance statistics as V$SERVICE_STATS except for a specific combination of service/module/action names.

When aggregation is enabled for the service name, module, and action name, then this view provides the timing and work done for calls issued for the business transaction.

Column	Datatype	Description
`AGGREGATION_TYPE`	`VARCHAR2(21)`	Aggregation statistic type: `SERVICE_MODULE` – Action value is NULL and the entry is an aggregate for all actions within a given module `SERVICE_MODULE_ACTION` – Action value is NULL only for an empty action, and the aggregation is on the level of service/module/action
`SERVICE_NAME`	`VARCHAR2(64)`	Service name from `V$SERVICES`
`MODULE`	`VARCHAR2(65)`	Module name from `DBA_ENABLED_AGGREGATIONS`
`ACTION`	`VARCHAR2(65)`	Action name from `DBA_ENABLED_AGGREGATIONS`
`STAT_ID`	`NUMBER`	Statistic identifier
`STAT_NAME`	`VARCHAR2(64)`	Derived statistic name from `V$STATNAME` and `V$SESS_TIME_MODEL`
`VALUE`	`NUMBER`	Cumulative value (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

本站中文解释

官方英文解释

相关推荐