SVC_BI_JOB_PROCESS_LISTS
This table is intended to be used for preparing the set of chunks for a parallel processing task. Any number of lists may be created simultaneously in this table, and each list will be deleted upon completion of the task. If the task is not successful, the associated list will be deleted after 24 hours. The data created will be used by the dbms_parallel_execute.create_chunks_by_sql API to define the set of chunks. This table is intended only for internal use, and the data should be considered to be temporary.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_BI_JOB_PROCESS_LISTS_PK |
JOB_PROCESS_LIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| JOB_PROCESS_LIST_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | |
| LIST_ID | NUMBER | 18 | Yes | Unique Id to distinguish lists from each other. | |
| OBJECT_ID | NUMBER | 18 | Yes | Id of an object to be sorted and grouped into chunks for parallel processing. For example, an SR_ID. | |
| PROCESS_ID | NUMBER | 18 | Yes | A sequential (ascending) order of the OBJECT_IDs within a list, starts with 1 and ends with the size of the list. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_BI_JOB_PROCESS_LISTS_N1 | Non Unique | Default | LIST_ID |
| SVC_BI_JOB_PROCESS_LISTS_N2 | Non Unique | Default | CREATION_DATE |
| SVC_BI_JOB_PROCESS_LISTS_PK | Unique | Default | JOB_PROCESS_LIST_ID |