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 Foot 1 |
VARCHAR2(49) |
Module name from DBA_ENABLED_AGGREGATIONS |
ACTION Footref 1 |
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) |
Footnote 1 The datatype of this column is VARCHAR2(65)
starting with Oracle Database 11g Release 2 (11.2.0.2).