[Home] [Help] [Dependency Information]
Object Name: | DBA_AUTOTASK_CLIENT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Autotask Client Summary Information
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 |
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
FROM SYS.DBA_AUTOTASK_CLIENT;
|
|
|