DBA Data[Home] [Help]

VIEW: SYS.V_$QMON_SERVER_STATS

Source

View Text - Preformatted

select "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 v$qmon_server_stats
View Text - HTML Formatted

SELECT "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 V$QMON_SERVER_STATS