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.
| Column | Datatype | Description |
|---|---|---|
BEGIN_TIME |
DATE |
Begin timestamp for the interval period |
END_TIME |
DATE |
End timestamp for the interval period |
INTSIZE_CSEC |
NUMBER |
Interval size (in hundredths of a second) |
GROUP_ID |
NUMBER |
Group ID for the service metric group |
SERVICE_NAME_HASH |
NUMBER |
Service name hash |
SERVICE_NAME |
VARCHAR2(64) |
Service name |
CTMHASH |
NUMBER |
Service create timestamp hash value |
ELAPSEDPERCALL |
NUMBER |
Elapsed time per call (in microseconds). This column is deprecated in favor of the DBTIMEPERCALL column. |
CPUPERCALL |
NUMBER |
CPU time per call (in microseconds) |
DBTIMEPERCALL |
NUMBER |
Elapsed time per call (in microseconds) |
CALLSPERSEC |
NUMBER |
Number of user calls per second |
DBTIMEPERSEC |
NUMBER |
Database time per second |
GOODNESS |
NUMBER |
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. |
DELTA |
NUMBER |
Indicates the predicted increase in the goodness for every additional session that is routed to this instance |
FLAGS |
NUMBER |
Flags that can be any of the following values:
|