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

VIEW: SYS.CDB_AUTOTASK_CLIENT

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

Autotask Client Summary Information in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
CLIENT_NAME VARCHAR2 (64)
Name of Automated Maintenance Tasks Client
STATUS VARCHAR2 (8)
Current status of the Client
CONSUMER_GROUP VARCHAR2 (128)
Resource Consumer Group normaly used to execute jobs
CLIENT_TAG VARCHAR2 (2)
Tag used in forming job names
PRIORITY_OVERRIDE VARCHAR2 (7)
Priority override for jobs
ATTRIBUTES VARCHAR2 (4000)
Client Attributes
WINDOW_GROUP VARCHAR2 (64)
Window group used to schedule jobs
SERVICE_NAME VARCHAR2 (64)
Service on which jobs will execute
RESOURCE_PERCENTAGE NUMBER

Percentage of maintenance resources for the client
USE_RESOURCE_ESTIMATES VARCHAR2 (5)
Indicates if resource estimates are uesd for this client
MEAN_JOB_DURATION INTERVAL DAY(9) TO SECOND(9) (24)
Average job duration for this client
MEAN_JOB_CPU INTERVAL DAY(9) TO SECOND(9) (24)
Average CPU time consumed by jobs
MEAN_JOB_ATTEMPTS NUMBER

Average number of attempts to execute the job successfully
MEAN_INCOMING_TASKS_7_DAYS NUMBER

Average number of tasks over last 7 days
MEAN_INCOMING_TASKS_30_DAYS NUMBER

Average number of tasks over last 30 days
TOTAL_CPU_LAST_7_DAYS INTERVAL DAY(9) TO SECOND(9) (24)
Cumulative CPU usage over last 7 days
TOTAL_CPU_LAST_30_DAYS INTERVAL DAY(9) TO SECOND(9) (24)
Cumulative CPU usage over last 30 days
MAX_DURATION_LAST_7_DAYS INTERVAL DAY(3) TO SECOND(0) (11)
Longest running job over last 7 days
MAX_DURATION_LAST_30_DAYS INTERVAL DAY(3) TO SECOND(0) (11)
Longest running job over last 30 days
WINDOW_DURATION_LAST_7_DAYS INTERVAL DAY(9) TO SECOND(9) (24)
Cumulative maintenance window duration over last 7 days
WINDOW_DURATION_LAST_30_DAYS INTERVAL DAY(9) TO SECOND(9) (24)
Cumulative maintenance window duration over last 30 days
LAST_CHANGE TIMESTAMP(6) WITH TIME ZONE (13)
Timestamp of last configuration change for the client
CON_ID NUMBER

container id
Query Text

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


SELECT CLIENT_NAME
,      STATUS
,      CONSUMER_GROUP
,      CLIENT_TAG
,      PRIORITY_OVERRIDE
,      ATTRIBUTES
,      WINDOW_GROUP
,      SERVICE_NAME
,      RESOURCE_PERCENTAGE
,      USE_RESOURCE_ESTIMATES
,      MEAN_JOB_DURATION
,      MEAN_JOB_CPU
,      MEAN_JOB_ATTEMPTS
,      MEAN_INCOMING_TASKS_7_DAYS
,      MEAN_INCOMING_TASKS_30_DAYS
,      TOTAL_CPU_LAST_7_DAYS
,      TOTAL_CPU_LAST_30_DAYS
,      MAX_DURATION_LAST_7_DAYS
,      MAX_DURATION_LAST_30_DAYS
,      WINDOW_DURATION_LAST_7_DAYS
,      WINDOW_DURATION_LAST_30_DAYS
,      LAST_CHANGE
,      CON_ID
FROM SYS.CDB_AUTOTASK_CLIENT;

Dependencies

[top of page]

SYS.CDB_AUTOTASK_CLIENT does not reference any database object

SYS.CDB_AUTOTASK_CLIENT is referenced by following:

SchemaPUBLIC
SynonymCDB_AUTOTASK_CLIENT