DBA Data[Home] [Help]

VIEW: SYS.GV_$QMON_SERVER_STATS

Source

View Text - Preformatted

select "INST_ID","QMNC_PID","SERVER_PID","SERVER_NAME","STATUS","SERVER_START_TIME","TASK_NAME","TASK_NUMBER","TASK_START_TIME","LAST_WAIT_TIME","MAX_LATENCY","MIN_LATENCY","TOTAL_LATENCY","NUM_TASKS","LAST_FAILURE","LAST_FAILURE_TIME","LAST_FAILURE_TASK","LAST_FAILURE_TASKNUM","CON_ID" from gv$qmon_server_stats
View Text - HTML Formatted

SELECT "INST_ID"
, "QMNC_PID"
, "SERVER_PID"
, "SERVER_NAME"
, "STATUS"
, "SERVER_START_TIME"
, "TASK_NAME"
, "TASK_NUMBER"
, "TASK_START_TIME"
, "LAST_WAIT_TIME"
, "MAX_LATENCY"
, "MIN_LATENCY"
, "TOTAL_LATENCY"
, "NUM_TASKS"
, "LAST_FAILURE"
, "LAST_FAILURE_TIME"
, "LAST_FAILURE_TASK"
, "LAST_FAILURE_TASKNUM"
, "CON_ID"
FROM GV$QMON_SERVER_STATS