Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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_NAME |
VARCHAR2(64) |
Service name from V$SERVICES |
MODULE |
VARCHAR2(49) |
Module name from DBA_ENABLED_AGGREGATIONS |
ACTION |
VARCHAR2(33) |
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) |