V$SERVICEMETRIC displays metric values measured on the most recent time interval period for services executing inside the database. Service metrics are measured in 5-second and 1-minute intervals.
Begin timestamp for the interval period
End timestamp for the interval period
Interval size (in hundredths of a second)
Group ID for the service metric group
Service name hash
Service create timestamp hash value
Elapsed time per call (in microseconds). This column is deprecated in favor of the DBTIMEPERCALL column.
CPU time per call (in microseconds)
Elapsed time per call (in microseconds)
Number of user calls per second
Database time per second
Indicates how attractive a given instance is with respect to processing the workload that is presented to the service. A lower number is better. This number is internally computed based on the GOAL (LONG or SHORT) that is specified for the particular service.
Indicates the predicted increase in the goodness for every additional session that is routed to this instance
Flags that can be any of the following values:
0x01 - Service is BLOCKED from accepting new connections
0x02 - Service is VIOLATING the set threshold on some metric
0x04 - Goodness is UNKNOWN
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