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]

VIEW: SYS.DBA_AUTOTASK_CLIENT

Object Details

Object Name:	DBA_AUTOTASK_CLIENT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Autotask Client Summary Information

[View Source]

Columns

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

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
FROM SYS.DBA_AUTOTASK_CLIENT;

Dependencies

[top of page]

SYS.DBA_AUTOTASK_CLIENT references the following:

SYS: DBA_AUTOTASK_CLIENT_HISTORY; DBA_RSRC_PLAN_DIRECTIVES; DBA_SCHEDULER_JOB_CLASSES; DBA_SCHEDULER_JOB_LOG; DBA_SCHEDULER_JOB_RUN_DETAILS; DBMS_AUTO_TASK - show dependent code; DBMS_SCHEDULER - show dependent code; KET$_CLIENT_CONFIG; KET$_CLIENT_TASKS

SYS.DBA_AUTOTASK_CLIENT is referenced by following:

PUBLIC: DBA_AUTOTASK_CLIENT
SYS: DBMS_AUTO_TASK_EXPORT - show dependent code; DBMS_MANAGEMENT_PACKS - show dependent code