9.11 V$SERVICEMETRIC
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 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 name |
|
|
Service create timestamp hash value |
|
|
Elapsed time per call (in microseconds). This column is deprecated in favor of the |
|
|
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:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|