DBA Data[Home] [Help]

VIEW: SYS.GV_$SERVICEMETRIC_HISTORY

Source

View Text - Preformatted

select "INST_ID","BEGIN_TIME","END_TIME","INTSIZE_CSEC","GROUP_ID","SERVICE_NAME_HASH","SERVICE_NAME","CTMHASH","ELAPSEDPERCALL","CPUPERCALL","DBTIMEPERCALL","CALLSPERSEC","DBTIMEPERSEC","CON_ID" from gv$servicemetric_history
View Text - HTML Formatted

SELECT "INST_ID"
, "BEGIN_TIME"
, "END_TIME"
, "INTSIZE_CSEC"
, "GROUP_ID"
, "SERVICE_NAME_HASH"
, "SERVICE_NAME"
, "CTMHASH"
, "ELAPSEDPERCALL"
, "CPUPERCALL"
, "DBTIMEPERCALL"
, "CALLSPERSEC"
, "DBTIMEPERSEC"
, "CON_ID"
FROM GV$SERVICEMETRIC_HISTORY