[Home] [Help] [Dependency Information]
Object Name: | V_$QMON_TASK_STATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_NAME | VARCHAR2 | (32) | ||
TASK_TYPE | VARCHAR2 | (40) | ||
LAST_CREATED_TASKNUM | NUMBER | |||
NUM_TASKS | NUMBER | |||
TOTAL_TASK_RUN_TIME | NUMBER | |||
TOTAL_TASK_RUNS | NUMBER | |||
TOTAL_TASK_FAILURES | NUMBER | |||
METRIC_TYPE | VARCHAR2 | (50) | ||
METRIC_VALUE | NUMBER | |||
LAST_FAILURE | VARCHAR2 | (32) | ||
LAST_FAILURE_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
LAST_FAILURE_TASKNUM | NUMBER | |||
REMARK | VARCHAR2 | (64) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_NAME
, TASK_TYPE
, LAST_CREATED_TASKNUM
, NUM_TASKS
, TOTAL_TASK_RUN_TIME
, TOTAL_TASK_RUNS
, TOTAL_TASK_FAILURES
, METRIC_TYPE
, METRIC_VALUE
, LAST_FAILURE
, LAST_FAILURE_TIME
, LAST_FAILURE_TASKNUM
, REMARK
, CON_ID
FROM SYS.V_$QMON_TASK_STATS;
|
|
|