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_PARALLEL_WORKERS

Object Details

Object Name:	AD_PARALLEL_WORKERS
Object Type:	TABLE
Owner:	APPLSYS
Subobject Name:
Status:	VALID

Workers for a script?

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_PARALLEL_WORKERS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	UPDATE_ID WORKER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WORKER_ID	NUMBER		Yes	ID for the worker
UPDATE_ID	NUMBER		Yes	ID for the parallel update
START_UNIT_ID	NUMBER		Yes	ID of the first unit processed by the worker
END_UNIT_ID	NUMBER		Yes	ID of the last unit processed by the worker
START_ROWID	ROWID	(10)		ROWID for the first row in the unit
END_ROWID	ROWID	(10)		ROWID for the last row in the unit
START_ID	NUMBER			ID for the first row in the unit
END_ID	NUMBER			ID for the last row in the unit
ROWS_PROCESSED	NUMBER			Number of rows processed by the worker for the current update.
SESSION_ID	NUMBER			Not used currently
SESSION_SERIAL_NO	NUMBER			Not used currently

Query Text

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


SELECT WORKER_ID
,      UPDATE_ID
,      START_UNIT_ID
,      END_UNIT_ID
,      START_ROWID
,      END_ROWID
,      START_ID
,      END_ID
,      ROWS_PROCESSED
,      SESSION_ID
,      SESSION_SERIAL_NO
FROM APPLSYS.AD_PARALLEL_WORKERS;

Dependencies

[top of page]

APPLSYS.AD_PARALLEL_WORKERS does not reference any database object

APPLSYS.AD_PARALLEL_WORKERS is referenced by following:

APPS: AD_PARALLEL_WORKERS