FUN_PARALLEL_SETUP
This table contains the default metadata for parallel runs, and run-specific metadata for parallel runs where the default metadata is overridden.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FUN_PARALLEL_SETUP_PK |
PARALLEL_SETUP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARALLEL_SETUP_ID | NUMBER | 18 | Yes | Unique identifier of the parallel setup. | |
| PARALLEL_JOB_CODE | VARCHAR2 | 30 | Yes | Parallel job for which this parallel run was submitted. | |
| ORACLE_SEEDED_FLAG | VARCHAR2 | 1 | Yes | Indicates if the parallel setup was seeded by Oracle or not. | |
| PARALLEL_RUN_ID | NUMBER | 18 | Yes | Parallel run that created this row in cases where the data dynamically created as versus Oracle seeded. Contains the value 1 for all seeded rows. | |
| MANUAL_JOB_SUBMISSION_FLAG | VARCHAR2 | 1 | Yes | Indicates whether all jobs for this parallel run will be submitted manually. | |
| PROCESS_PHASES_SERIALLY_FLAG | VARCHAR2 | 1 | Yes | Indicates in the case of multi-phase jobs, whether the phases should be processed sequentially or whether they can overlap. | |
| MINIMUM_ESS_THREADS | NUMBER | 6 | Yes | Minimum Enterprise Service Scheduler threads this parallel setup requires to run (excluding PL/SQL slots). | |
| MINIMUM_PLSQL_SLOTS | NUMBER | 6 | Yes | Minimum PL/SQL slots this parallel setup requires to run. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | |
| LAUNCH_JOBS_AT_INIT_FLAG | VARCHAR2 | 1 | Yes | Indicates whether any additional threads will be launched when the initialization API is called. When the value is N, system waits for subsequent calls to the parallelism APIs to launch additional threads. | |
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_PARALLEL_SETUP_U1 | Unique | FUSION_TS_TX_DATA | PARALLEL_SETUP_ID, ORA_SEED_SET1 |
| FUN_PARALLEL_SETUP_U11 | Unique | FUSION_TS_TX_DATA | PARALLEL_SETUP_ID, ORA_SEED_SET2 |
| FUN_PARALLEL_SETUP_U2 | Unique | FUSION_TS_TX_DATA | PARALLEL_JOB_CODE, ORACLE_SEEDED_FLAG, PARALLEL_RUN_ID, ORA_SEED_SET1 |
| FUN_PARALLEL_SETUP_U21 | Unique | FUSION_TS_TX_DATA | PARALLEL_JOB_CODE, ORACLE_SEEDED_FLAG, PARALLEL_RUN_ID, ORA_SEED_SET2 |