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

VIEW: SYS.CDB_AUTOTASK_TASK

Object Details
Object Name: CDB_AUTOTASK_TASK
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about current and past autmated maintenance tasks in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
CLIENT_NAME VARCHAR2 (64)
Name of the Automated Maintenance client
TASK_NAME VARCHAR2 (64)
Name of the maintenance task
TASK_TARGET_TYPE VARCHAR2 (64)
Type of target of the maintenance task
TASK_TARGET_NAME VARCHAR2 (513) Yes Name of the maintenance task target
OPERATION_NAME VARCHAR2 (64)
Operation being performed by the task
ATTRIBUTES VARCHAR2 (4000)
Task attributes
TASK_PRIORITY NUMBER

Task priority, relative to other tasks for this Client
PRIORITY_OVERRIDE NUMBER

Task priority as overridden by the user
STATUS VARCHAR2 (8)
Current status of the task
DEFERRED_WINDOW_NAME VARCHAR2 (65)
Name of the window to which execution of this task is deferred
CURRENT_JOB_NAME VARCHAR2 (65)
Job name associated with the task
JOB_SCHEDULER_STATUS VARCHAR2 (15)
Job status
ESTIMATE_TYPE VARCHAR2 (7)
Type of resource estimates applied
ESTIMATED_WEIGHT NUMBER

Weight of the task
ESTIMATED_DURATION NUMBER

Estimated elapsed time for the task
ESTIMATED_CPU_TIME NUMBER

Estimated CPU utilization for the task
ESTIMATED_TEMP NUMBER

Estimated temp space usage for the task
ESTIMATED_DOP NUMBER

Estimated Degree of Parallelism for the task
ESTIMATED_IO_RATE NUMBER

Estimated I/O Rate for the task
ESTIMATED_UNDO_RATE NUMBER

Estimated UNDO generation rate for the task
RETRY_COUNT NUMBER

Numbe rof failed attempts to execute the task
LAST_GOOD_DATE TIMESTAMP(6) WITH TIME ZONE (13)
Date/time of the last successful execution of the task
LAST_GOOD_PRIORITY NUMBER

Task priority during the last successful execution of the task
LAST_GOOD_DURATION NUMBER

Elapsed time of the last successful execution of the task
LAST_GOOD_CPU_TIME NUMBER

CPU time used during the last successful execution of the task
LAST_GOOD_TEMP NUMBER

Peak temp space used during last successful execution of the task
LAST_GOOD_DOP NUMBER

Parallelsism during last successful execution of the task
LAST_GOOD_IO_RATE NUMBER

Mean I/O rate during last successful execution of the task
LAST_GOOD_UNDO_RATE NUMBER

Mean UNDO rate during last successful execution of the task
LAST_GOOD_CPU_WAIT NUMBER

Total time spent waiting for CPU during last good run
LAST_GOOD_IO_WAIT NUMBER

Total time spent waiting for I/O during last good run
LAST_GOOD_UNDO_WAIT NUMBER

Total time spent waiting for UNDO during last good run
LAST_GOOD_TEMP_WAIT NUMBER

Total time spent waiting for Temp Space during last good run
LAST_GOOD_CONCURRENCY NUMBER

Total time in concurrency wait during last good run
LAST_GOOD_CONTENTION NUMBER

Total time in contention wait during last good run
NEXT_TRY_DATE TIMESTAMP(6) WITH TIME ZONE (13)
Next projected start date/time for the deferred maintenance window
LAST_TRY_DATE TIMESTAMP(6) WITH TIME ZONE (13)
Date/Time of the last executon of the task
LAST_TRY_PRIORITY NUMBER

Priority of the task at the time of the last execution
LAST_TRY_RESULT VARCHAR2 (36)
Result code of the last execution of the task
LAST_TRY_DURATION NUMBER

Elapsed time of the last execution of the task
LAST_TRY_CPU_TIME NUMBER

CPU time consumed during last execution of the task
LAST_TRY_TEMP NUMBER

Peak Temp space usage during the last execution of the task
LAST_TRY_DOP NUMBER

Degree of parallelism of the last execution of the task
LAST_TRY_IO_RATE NUMBER

I/O rate during the last execution of the task
LAST_TRY_UNDO_RATE NUMBER

UNDO generation rate during the last execution of the task
LAST_TRY_CPU_WAIT NUMBER

Time spent waiting for CPU during the last execution of the task
LAST_TRY_IO_WAIT NUMBER

Time spent waiting for I/O during the last execution of the task
LAST_TRY_UNDO_WAIT NUMBER

Time spent waiting for UNDO during the last execution of the task
LAST_TRY_TEMP_WAIT NUMBER

Time spent waiting for Temp Space during the last execution of the task
LAST_TRY_CONCURRENCY NUMBER

Time spent in concurrency wait during the last execution of the task
LAST_TRY_CONTENTION NUMBER

Time spent in contention wait during the last execution of the task
MEAN_GOOD_DURATION NUMBER

Average elapsed time for successful executions of the task
MEAN_GOOD_CPU_TIME NUMBER

Average CPU usage for successful executions of the task
MEAN_GOOD_TEMP NUMBER

Average peak temp space usage for successful executions of the task
MEAN_GOOD_DOP NUMBER

Average degree or parallelism for successful executions of the task
MEAN_GOOD_IO NUMBER

Average I/O rate for successful executions of the task
MEAN_GOOD_UNDO NUMBER

Average Undo generation rate for successful executions of the task
MEAN_GOOD_CPU_WAIT NUMBER

Average CPU wait time for successful executions of the task
MEAN_GOOD_IO_WAIT NUMBER

Average I/O wait time for successful executions of the task
MEAN_GOOD_UNDO_WAIT NUMBER

Average Undo wait time for successful executions of the task
MEAN_GOOD_TEMP_WAIT NUMBER

Average wait time for Temp space for successful executions of the task
MEAN_GOOD_CONCURRENCY NUMBER

Average time in concurrency wait for successful executions of the task
MEAN_GOOD_CONTENTION NUMBER

Average time in contention wait for successful executions of the task
INFO_FIELD_1 VARCHAR2 (4000)
Additional information field
INFO_FIELD_2 CLOB (4000)
Additional information field
INFO_FIELD_3 NUMBER

Additional Client information field
INFO_FIELD_4 NUMBER

Additional Client information field
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CLIENT_NAME
,      TASK_NAME
,      TASK_TARGET_TYPE
,      TASK_TARGET_NAME
,      OPERATION_NAME
,      ATTRIBUTES
,      TASK_PRIORITY
,      PRIORITY_OVERRIDE
,      STATUS
,      DEFERRED_WINDOW_NAME
,      CURRENT_JOB_NAME
,      JOB_SCHEDULER_STATUS
,      ESTIMATE_TYPE
,      ESTIMATED_WEIGHT
,      ESTIMATED_DURATION
,      ESTIMATED_CPU_TIME
,      ESTIMATED_TEMP
,      ESTIMATED_DOP
,      ESTIMATED_IO_RATE
,      ESTIMATED_UNDO_RATE
,      RETRY_COUNT
,      LAST_GOOD_DATE
,      LAST_GOOD_PRIORITY
,      LAST_GOOD_DURATION
,      LAST_GOOD_CPU_TIME
,      LAST_GOOD_TEMP
,      LAST_GOOD_DOP
,      LAST_GOOD_IO_RATE
,      LAST_GOOD_UNDO_RATE
,      LAST_GOOD_CPU_WAIT
,      LAST_GOOD_IO_WAIT
,      LAST_GOOD_UNDO_WAIT
,      LAST_GOOD_TEMP_WAIT
,      LAST_GOOD_CONCURRENCY
,      LAST_GOOD_CONTENTION
,      NEXT_TRY_DATE
,      LAST_TRY_DATE
,      LAST_TRY_PRIORITY
,      LAST_TRY_RESULT
,      LAST_TRY_DURATION
,      LAST_TRY_CPU_TIME
,      LAST_TRY_TEMP
,      LAST_TRY_DOP
,      LAST_TRY_IO_RATE
,      LAST_TRY_UNDO_RATE
,      LAST_TRY_CPU_WAIT
,      LAST_TRY_IO_WAIT
,      LAST_TRY_UNDO_WAIT
,      LAST_TRY_TEMP_WAIT
,      LAST_TRY_CONCURRENCY
,      LAST_TRY_CONTENTION
,      MEAN_GOOD_DURATION
,      MEAN_GOOD_CPU_TIME
,      MEAN_GOOD_TEMP
,      MEAN_GOOD_DOP
,      MEAN_GOOD_IO
,      MEAN_GOOD_UNDO
,      MEAN_GOOD_CPU_WAIT
,      MEAN_GOOD_IO_WAIT
,      MEAN_GOOD_UNDO_WAIT
,      MEAN_GOOD_TEMP_WAIT
,      MEAN_GOOD_CONCURRENCY
,      MEAN_GOOD_CONTENTION
,      INFO_FIELD_1
,      INFO_FIELD_2
,      INFO_FIELD_3
,      INFO_FIELD_4
,      CON_ID
FROM SYS.CDB_AUTOTASK_TASK;

Dependencies

[top of page]

SYS.CDB_AUTOTASK_TASK does not reference any database object

SYS.CDB_AUTOTASK_TASK is referenced by following:

SchemaPUBLIC
SynonymCDB_AUTOTASK_TASK