Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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(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)