V$SERVICE_STATS

V$SERVICE_STATS displays a minimal set of performance statistics. These call rate statistics are used for making run-time routing decisions, for tracking service levels, and for per-instance diagnostics per call rate. The elapsed timing for each call provides a relative value across instances for how well a node is processing SQL calls issued under a service name.

When aggregation is enabled for the Service Name, then this view provides the timing and work done for calls issued for the whole service.

Column	Datatype	Description
`SERVICE_NAME_HASH`	`NUMBER`	Service name hash from `V$SERVICES`
`SERVICE_NAME`	`VARCHAR2(64)`	Service name from `V$SERVICES`
`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