[Home] [Help] [Dependency Information]
Object Name: | KET$_CLIENT_TASKS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
KET$_TSK_PK | NORMAL | UNIQUE | SYSAUX |
CLIENT_ID
OPERATION_ID TARGET_TYPE TARGET_NAME |
SYS_IL0000469356C00071$$ | LOB | UNIQUE | SYSAUX |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLIENT_ID | NUMBER | Yes | ||
OPERATION_ID | NUMBER | Yes | ||
TARGET_TYPE | NUMBER | Yes | ||
TARGET_NAME | VARCHAR2 | (513) | Yes | |
ATTRIBUTES | NUMBER | |||
ATTRIBUTES_OVERRIDE | NUMBER | |||
TASK_PRIORITY | NUMBER | |||
PRIORITY_OVERRIDE | NUMBER | |||
STATUS | NUMBER | |||
ARG_4 | VARCHAR2 | (1024) | ||
ARG_5 | VARCHAR2 | (1024) | ||
ARG_6 | VARCHAR2 | (1024) | ||
WINDOW_NAME | VARCHAR2 | (65) | ||
CURR_JOB_NAME | VARCHAR2 | (65) | ||
CURR_WIN_START | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
EST_TYPE | NUMBER | |||
EST_WEIGHT | NUMBER | |||
EST_DURATION | NUMBER | |||
EST_CPU_TIME | NUMBER | |||
EST_TEMP | NUMBER | |||
EST_DOP | NUMBER | |||
EST_IO_RATE | NUMBER | |||
EST_UNDO_RATE | NUMBER | |||
RETRY_COUNT | NUMBER | |||
GOOD_COUNT | NUMBER | |||
LG_JOB_LOG_ID | NUMBER | |||
LG_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
LG_PRIORITY | NUMBER | |||
LG_DURATION | NUMBER | |||
LG_CPU_TIME | NUMBER | |||
LG_TEMP | NUMBER | |||
LG_DOP | NUMBER | |||
LG_IO_RATE | NUMBER | |||
LG_UNDO_RATE | NUMBER | |||
LG_CPU_WAIT | NUMBER | |||
LG_IO_WAIT | NUMBER | |||
LG_UNDO_WAIT | NUMBER | |||
LG_TEMP_WAIT | NUMBER | |||
LG_CONCURRENCY | NUMBER | |||
LG_CONTENTION | NUMBER | |||
LT_JOB_LOG_ID | NUMBER | |||
LT_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
LT_PRIORITY | NUMBER | |||
LT_TERM_CODE | NUMBER | |||
LT_ERROR | NUMBER | |||
LT_DURATION | NUMBER | |||
LT_CPU_TIME | NUMBER | |||
LT_TEMP | NUMBER | |||
LT_DOP | NUMBER | |||
LT_IO_RATE | NUMBER | |||
LT_UNDO_RATE | NUMBER | |||
LT_CPU_WAIT | NUMBER | |||
LT_IO_WAIT | NUMBER | |||
LT_UNDO_WAIT | NUMBER | |||
LT_TEMP_WAIT | NUMBER | |||
LT_CONCURRENCY | NUMBER | |||
LT_CONTENTION | NUMBER | |||
MG_DURATION | NUMBER | |||
MG_CPU_TIME | NUMBER | |||
MG_TEMP | NUMBER | |||
MG_DOP | NUMBER | |||
MG_IO_RATE | NUMBER | |||
MG_UNDO_RATE | NUMBER | |||
MG_CPU_WAIT | NUMBER | |||
MG_IO_WAIT | NUMBER | |||
MG_UNDO_WAIT | NUMBER | |||
MG_TEMP_WAIT | NUMBER | |||
MG_CONCURRENCY | NUMBER | |||
MG_CONTENTION | NUMBER | |||
INFO_FIELD_1 | VARCHAR2 | (4000) | ||
INFO_FIELD_2 | CLOB | (4000) | ||
INFO_FIELD_3 | NUMBER | |||
INFO_FIELD_4 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CLIENT_ID
, OPERATION_ID
, TARGET_TYPE
, TARGET_NAME
, ATTRIBUTES
, ATTRIBUTES_OVERRIDE
, TASK_PRIORITY
, PRIORITY_OVERRIDE
, STATUS
, ARG_4
, ARG_5
, ARG_6
, WINDOW_NAME
, CURR_JOB_NAME
, CURR_WIN_START
, EST_TYPE
, EST_WEIGHT
, EST_DURATION
, EST_CPU_TIME
, EST_TEMP
, EST_DOP
, EST_IO_RATE
, EST_UNDO_RATE
, RETRY_COUNT
, GOOD_COUNT
, LG_JOB_LOG_ID
, LG_DATE
, LG_PRIORITY
, LG_DURATION
, LG_CPU_TIME
, LG_TEMP
, LG_DOP
, LG_IO_RATE
, LG_UNDO_RATE
, LG_CPU_WAIT
, LG_IO_WAIT
, LG_UNDO_WAIT
, LG_TEMP_WAIT
, LG_CONCURRENCY
, LG_CONTENTION
, LT_JOB_LOG_ID
, LT_DATE
, LT_PRIORITY
, LT_TERM_CODE
, LT_ERROR
, LT_DURATION
, LT_CPU_TIME
, LT_TEMP
, LT_DOP
, LT_IO_RATE
, LT_UNDO_RATE
, LT_CPU_WAIT
, LT_IO_WAIT
, LT_UNDO_WAIT
, LT_TEMP_WAIT
, LT_CONCURRENCY
, LT_CONTENTION
, MG_DURATION
, MG_CPU_TIME
, MG_TEMP
, MG_DOP
, MG_IO_RATE
, MG_UNDO_RATE
, MG_CPU_WAIT
, MG_IO_WAIT
, MG_UNDO_WAIT
, MG_TEMP_WAIT
, MG_CONCURRENCY
, MG_CONTENTION
, INFO_FIELD_1
, INFO_FIELD_2
, INFO_FIELD_3
, INFO_FIELD_4
FROM SYS.KET$_CLIENT_TASKS;
SYS.KET$_CLIENT_TASKS does not reference any database object
SYS.KET$_CLIENT_TASKS is referenced by following:
|
|
|