MSC_HVGOP_STATISTICS
This table contains NewGOP Statistics Support data.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: msc_hvgop_statistics
Primary Key
| Name | Columns |
|---|---|
|
MSC_HVGOP_STATISTICS_PK |
REQUEST_RUN_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| REQUEST_RUN_ID | VARCHAR2 | 512 | Yes | Contains data needed to uniquely identify the request in the format - <pid>@<hostname>&<thread_id>&<request_time> |
| REQUEST_TYPE | VARCHAR2 | 64 | Yes | Pre-defined values to indicate the request type for newGOP statistics framework project. 1.CheckAvailability 2.AutoSchedule 3.ScheduledSalesOrder 4.CancelSalesOrder 5.ReviewSupplyAvailability 6.QuickAvailability 7.getShipMethod |
| REQUEST_CALLER | VARCHAR2 | 256 | Yes | Contains the concatenated string of Calling Module and Calling Instance. |
| REQUEST_HEADER | CLOB | Contains the summary of the lines contained in current request. | ||
| REQUEST_DETAILS | CLOB | Contains the Input Payload and Output Payload - logged only if FINEST enabled | ||
| REQUEST_LINE_STATUS | CLOB | Indicates the status/error codes for each line within the current request. | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 256 | Indicates the Fulfillment Line id of the sales order. (for CA, if order number is absent then populate first request lines fulfilment line id) | |
| REQUEST_START_DATE | TIMESTAMP | Yes | Indicates the request start date time. | |
| ELAPSED_TIME | NUMBER | Indicates the total duration of the current request. | ||
| AVG_TIME_PER_LINE | NUMBER | Indicates the average duration per line for current request. | ||
| LOCK_WAIT_TIME | NUMBER | Indicates the elapsed time to acquire lock in milli-seconds. | ||
| LOCK_TIME | NUMBER | Indicates the elapsed time between the start of acquire locks and after the locks get released in milli-seconds. | ||
| DATABASE_TIME | NUMBER | Indicates the time spent in database calls. | ||
| SOLVER_TIMERS | CLOB | Indicates the values for several timers at different stages of a promising solution. The typical sequence is phase name followed by timer value in seconds. | ||
| USED_MEMORY | NUMBER | Indicates the details of memory utilization (USED_MEMORY=TOTAL_MEMORY- FREE_MEMORY). | ||
| MAX_MEMORY | NUMBER | Indicates the details of maximum memory. | ||
| FREE_MEMORY | NUMBER | Indicates the details of free memory. | ||
| TOTAL_MEMORY | NUMBER | Indicates the details of total memory. | ||
| TOTAL_FREE_MEMORY | NUMBER | Indicates the details of total free memory. | ||
| DEPENDENCY_SIZE | NUMBER | Indicates the additional number of inventories to be considered when promising this request. | ||
| 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. | |
| PROMISING_SUMMARY | CLOB | Contains the summary of the promising results contained in current request. | ||
| ECID | VARCHAR2 | 80 | This fields holds Execution Context ID for which the statistics are recorded. Helps to correlate the logs while debugging. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_HVGOP_STATISTICS_U1 | Unique | MSC_HVGOP_STATISTICS_U1 | REQUEST_RUN_ID |