CST_CP_RUN_TIMINGS
This table stores the loop information, step and class wise timings for the cost processor runs.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CST_CP_RUN_TIMINGS_PK |
CP_RUN_TIMING_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CP_RUN_TIMING_ID | NUMBER | 18 | Yes | Indicates the surrogate key of the table record. | |
REQ_ID | NUMBER | 18 | Yes | Indicates the request ID of the job that created or last updated the row. | |
RETRY_NUMBER | NUMBER | 18 | Indicates the retry attempt number of the cost processor run if it goes to retrying status. | ||
COMMIT_LIMIT_LOOP | NUMBER | 18 | Indicates the commit limit loop for the current cost processor iteration. | ||
PROCESSOR_STAGE_CODE | VARCHAR2 | 30 | Yes | Indicates the current stage of the cost processor. | |
INNER_LOOP | NUMBER | 18 | Indicates the inner loop for the main cost processor iteration. | ||
STEP_NUMBER | NUMBER | 18 | Yes | Indicates the step number of the cost processor stage. | |
TOTAL_STEPS_IN_STAGE | NUMBER | 18 | Yes | Indicates the total number of steps in a stage. | |
CLASS_NAME | VARCHAR2 | 900 | Yes | Indicates the class executed as part of the cost processor run. | |
START_TIME | TIMESTAMP | Yes | Indicates the start time of the step. | ||
STEP_DESC | VARCHAR2 | 240 | Describes the cost processor step. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CST_CP_RUN_TIMINGS_N1 | Non Unique | Default | REQ_ID |
CST_CP_RUN_TIMINGS_U1 | Unique | Default | CP_RUN_TIMING_ID |