OSS_METRIC_RESULTS_GT
Global temporary table to process subscription insights metric results.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_METRIC_RESULTS_GT_PK |
METRIC_UNIT, RUNTIME_METRIC_ID, METRIC_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| METRIC_UNIT | VARCHAR2 | 80 | Yes | Business name of the metric component being calculated. | |
| RUNTIME_METRIC_ID | NUMBER | Yes | References the metric execution instance in Runtime Metrics. | ||
| METRIC_COUNT | NUMBER | Stores count-based metric values. | |||
| METRIC_AMOUNT | NUMBER | Stores monetary metric values. | |||
| METRIC_TYPE_CODE | VARCHAR2 | 64 | Name of the metric for different metric types. | ||
| METRIC_SCORE | NUMBER | 18 | Stores computed score or percentage value. | ||
| METRIC_DATE | DATE | Yes | Represents the effective date of the metric calculation |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| OSS_METRIC_RESULTS_GT_PK | Unique | METRIC_UNIT, RUNTIME_METRIC_ID, METRIC_DATE |