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

TABLE: APPLSYS.AD_PARALLEL_UPDATE_UNITS

Object Details
Object Name: AD_PARALLEL_UPDATE_UNITS
Object Type: TABLE
Owner: APPLSYS
Subobject Name:
Status: VALID


Around 5,000 rows per table?


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AD_PARALLEL_UPDATE_UNITS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnUPDATE_ID
ColumnUNIT_ID
AD_PARALLEL_UPDATE_UNITS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnUPDATE_ID
ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
UNIT_ID NUMBER
Yes Unique ID for unit of work
UPDATE_ID NUMBER
Yes ID for the parallel update
STATUS VARCHAR2 (1) Yes Status of the unit of work
RELATIVE_FNO NUMBER

DB file associated with ROWIDs in the unit
START_BLOCK NUMBER

Block ID for the first row in the unit
END_BLOCK NUMBER

Block ID 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
WORKER_ID NUMBER

ID for worker processing the unit
START_DATE DATE

Processing start time for the unit.
END_DATE DATE

Processing end time for the unit.
ROWS_PROCESSED NUMBER

Number of rows processed for this unit.
DATA_OBJECT_ID NUMBER

Data object number for the segment
Query Text

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


SELECT UNIT_ID
,      UPDATE_ID
,      STATUS
,      RELATIVE_FNO
,      START_BLOCK
,      END_BLOCK
,      START_ID
,      END_ID
,      WORKER_ID
,      START_DATE
,      END_DATE
,      ROWS_PROCESSED
,      DATA_OBJECT_ID
FROM APPLSYS.AD_PARALLEL_UPDATE_UNITS;

Dependencies

[top of page]

APPLSYS.AD_PARALLEL_UPDATE_UNITS does not reference any database object

APPLSYS.AD_PARALLEL_UPDATE_UNITS is referenced by following:

SchemaAPPS
SynonymAD_PARALLEL_UPDATE_UNITS