eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.KET$_CLIENT_TASKS

Object Details

Object Name:	KET$_CLIENT_TASKS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: KET$_TSK_PK

CLIENT_ID
OPERATION_ID
TARGET_TYPE
TARGET_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
KET$_TSK_PK	NORMAL	UNIQUE	SYSAUX	CLIENT_ID OPERATION_ID TARGET_TYPE TARGET_NAME
SYS_IL0000469356C00071$$	LOB	UNIQUE	SYSAUX

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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;

Dependencies

[top of page]

SYS.KET$_CLIENT_TASKS does not reference any database object

SYS.KET$_CLIENT_TASKS is referenced by following:

SYS: DBA_AUTOTASK_CLIENT; DBA_AUTOTASK_CLIENT_JOB; DBA_AUTOTASK_TASK; DBMS_AUTOTASK_PRVT - show dependent code