Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$SERVICEMETRIC_HISTORY

V$SERVICEMETRIC_HISTORY displays a recent history of the metric values measured in predefined time interval periods 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 DB time per second