FUN_PARALLEL_SETUP_PHASES
This table contains details of each phase of a parallel run.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FUN_PARALLEL_SETUP_PHASES_PK |
PARALLEL_PHASE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARALLEL_PHASE_ID | NUMBER | 18 | Yes | Unique identifier of the parallel phase. | |
| PARALLEL_SETUP_ID | NUMBER | 18 | Yes | Parallel setup that contains this phase. | |
| PHASE_ORDER_NUM | NUMBER | 3 | Yes | Indicates the logical order of the phases. An older phases can only create data for later phases. | |
| PHASE_CODE | VARCHAR2 | 30 | Yes | Internal name of the phase. Its value must be unique within the parallel job. | |
| HAS_CHUNKING_ATTRIBUTE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether a chunking attribute is provided. This attribute is for future use only. It is not currently supported. | |
| DATA_RETRIEVAL_METHOD_CODE | VARCHAR2 | 30 | Yes | Method used to retrieve the initial data for this phase. Possible values are NONE, SQL, and GT_TABLE. A value of NONE means that this phase does not have any initial data, and only processes data produced by upstream phases. | |
| GENDATA_RETRIEVAL_METHOD_CODE | VARCHAR2 | 30 | Yes | Method used to retrieve the data produced for downstream phases as a result of processing data in this phase. Possible values are NONE, SQL, and GT_TABLE. A value of NONE means that this phase does not produce data for a downstream phase. | |
| HAS_PRIORITIES_FLAG | VARCHAR2 | 1 | Yes | Indicates whether priority information is provided for the phase data. | |
| HIGHEST_PRIORITY | NUMBER | 3 | Indicates the priority order with which data is processed. of the job. Data with priority value of 1 is processed before data with priority value of 2, and so on. | ||
| PROCESS_PRIORITIES_IN_ORDER | VARCHAR2 | 1 | Yes | Indicates whether all data for a higher priority must be processed completely before any data for a lower priority can be processed. If set as Y, idle threads will not start processing lower priority data while other threads are still processing higher priority data. | |
| CHUNK_ACROSS_PRIORITIES_FLAG | VARCHAR2 | 1 | Yes | Indicates whether a single chunk can contain data with multiple different priorities. | |
| HAS_SPLIT_COLUMN_FLAG | VARCHAR2 | 1 | Yes | Indicates whether split column information is provided for the phase data. | |
| SPLIT_VALUE_CONCURRENCY_MODE | VARCHAR2 | 30 | Concurrency mode for split values. It determines whether split values are processed simultaneously. Possible values are NO_LIMIT, SINGLE, ONE_WITHIN, or ONE_ACROSS. | ||
| GROUPING_METHOD_CODE | VARCHAR2 | 30 | Yes | Method used to group related data into the same chunk. Possible values are NONE, SIMPLE, and ADVANCED. | |
| GROUP_ACROSS_ORIGINAL_SQL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether grouping is done across all of the SQL statements in the initial fetch, when the initial fetch is done using SQL. | |
| GROUP_ACROSS_PRIOR_CHUNKS_FLAG | VARCHAR2 | 1 | Yes | Indicates whether grouping is done across all of the data provided from prior phases for this phase, even if the data is coming from different prior phase chunks, different prior phase SQLs, or different phases. | |
| GROUP_ACROSS_BOTH_FLAG | VARCHAR2 | 1 | Yes | Indicates whether grouping is done across both data from the initial fetch and data provided from prior phases for this phase. | |
| NUMBER_OF_ADVANCED_COLUMNS | NUMBER | 1 | Number of advanced chunking columns. | ||
| CHUNK_MODE_CODE | VARCHAR2 | 30 | Yes | Mode for creating chunks. Possible values are NORMAL, ONLY_ONE, and MAX_SIZED. | |
| MAXIMUM_CHUNK_SIZE | NUMBER | 18 | Maximum size limit for creating chunks. This limit is ignored if larger chunks are required to satisfy the grouping and other settings. | ||
| MINIMUM_CHUNK_SIZE | NUMBER | 18 | Minimum size limit for creating chunks. This limit is ignored if smaller chunks are required to satisfy the data processing and other settings. | ||
| 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. | |
| FLATTEN_ADVANCED_COLUMNS_FLAG | VARCHAR2 | 1 | Indicates whether grouping is done across all advanced columns treating them as common attribute. | ||
| 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_PHASES_U1 | Unique | Default | PARALLEL_PHASE_ID, ORA_SEED_SET1 |
| FUN_PARALLEL_SETUP_PHASES_U11 | Unique | Default | PARALLEL_PHASE_ID, ORA_SEED_SET2 |
| FUN_PARALLEL_SETUP_PHASES_U2 | Unique | FUSION_TS_TX_DATA | PARALLEL_SETUP_ID, PHASE_ORDER_NUM, ORA_SEED_SET1 |
| FUN_PARALLEL_SETUP_PHASES_U21 | Unique | FUSION_TS_TX_DATA | PARALLEL_SETUP_ID, PHASE_ORDER_NUM, ORA_SEED_SET2 |
| FUN_PARALLEL_SETUP_PHASES_U3 | Unique | FUSION_TS_TX_DATA | PARALLEL_SETUP_ID, PHASE_CODE, ORA_SEED_SET1 |
| FUN_PARALLEL_SETUP_PHASES_U31 | Unique | FUSION_TS_TX_DATA | PARALLEL_SETUP_ID, PHASE_CODE, ORA_SEED_SET2 |