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_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:

  • 0x01 - Service is BLOCKED from accepting new connections

  • 0x02 - Service is VIOLATING the set threshold on some metric

  • 0x04 - Goodness is UNKNOWN

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