[Home] [Help] [Dependency Information]
Object Name: | GV_$QMON_SERVER_STATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
QMNC_PID | VARCHAR2 | (24) | ||
SERVER_PID | VARCHAR2 | (24) | ||
SERVER_NAME | VARCHAR2 | (48) | ||
STATUS | VARCHAR2 | (40) | ||
SERVER_START_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
TASK_NAME | VARCHAR2 | (32) | ||
TASK_NUMBER | NUMBER | |||
TASK_START_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
LAST_WAIT_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
MAX_LATENCY | NUMBER | |||
MIN_LATENCY | NUMBER | |||
TOTAL_LATENCY | NUMBER | |||
NUM_TASKS | NUMBER | |||
LAST_FAILURE | VARCHAR2 | (128) | ||
LAST_FAILURE_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
LAST_FAILURE_TASK | VARCHAR2 | (32) | ||
LAST_FAILURE_TASKNUM | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
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 SYS.GV_$QMON_SERVER_STATS;
|
|
|