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: APPLSYS.AD_TASK_TIMING

Object Details

Object Name:	AD_TASK_TIMING
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.AD_TASK_TIMING
Subobject Name:
Status:	VALID

This table is used to track how long each parallel job takes to run.
Session versus task:
A session consists of one or more tasks. For instance:
- In one adadmin invocation, each menu choice is a separate task in the same session
- In one adpatch invocation of multiple drivers, the timing history of each driver has a unique TASK_NUMBER but they all share the same SESSION_ID.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_TASK_TIMING_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SESSION_ID JOB_NAME PRODUCT CURRENT_FLAG WORKER_ID INSTALL_GROUP_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Session ID for the AD program run which ran this parallel job. See table description for details
JOB_NAME	VARCHAR2	(60)	Yes	Name of the file associated with this job
PRODUCT	VARCHAR2	(30)	Yes	Product that owns the file associated with this job
CURRENT_FLAG	VARCHAR2	(1)	Yes	Y for currently-running jobs; N for completed or skipped jobs
WORKER_ID	NUMBER		Yes	The worker ID for the parallel worker that ran this job
INSTALL_GROUP_NUM	NUMBER		Yes	The Installation Group Number for this job; 0 for SOA product jobs -- 1 for MOA product jobs
PROGRAM	VARCHAR2	(30)	Yes	The name of the AD program that ran this job
PHASE	NUMBER		Yes	The numeric phase for this job
ARGUMENTS	VARCHAR2	(1996)		The comand-line arguments for this job
PHASE_NAME	VARCHAR2	(30)		User-friendly name of the phase for this job
START_TIME	DATE			Time when job started
RESTART_TIME	DATE			Time when job (last) restarted
END_TIME	DATE			Time when job completed
ELAPSED_TIME	NUMBER			Total run time for the job
RESTART_COUNT	NUMBER			Number of times job failed and was restarted
DEFER_COUNT	NUMBER			Number of times this job was deferred (after a failure)
COMMAND	VARCHAR2	(30)		Command code ("bin" for executables, "package" for packages, etc)
SUBDIRECTORY	VARCHAR2	(256)		Subdirectory where the acted-upon file resides
TASK_NUMBER	NUMBER			Task number. See table description for details
TASK_STATUS_ID	NUMBER		Yes	Id of the task to which this job corresponds. It is a foreign key to AD_TASK_STATUS
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.

Query Text

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


SELECT SESSION_ID
,      JOB_NAME
,      PRODUCT
,      CURRENT_FLAG
,      WORKER_ID
,      INSTALL_GROUP_NUM
,      PROGRAM
,      PHASE
,      ARGUMENTS
,      PHASE_NAME
,      START_TIME
,      RESTART_TIME
,      END_TIME
,      ELAPSED_TIME
,      RESTART_COUNT
,      DEFER_COUNT
,      COMMAND
,      SUBDIRECTORY
,      TASK_NUMBER
,      TASK_STATUS_ID
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM APPLSYS.AD_TASK_TIMING;

Dependencies

[top of page]

APPLSYS.AD_TASK_TIMING does not reference any database object

APPLSYS.AD_TASK_TIMING is referenced by following:

APPS: AD_TASK_TIMING