This page was last edited on June 22, 2022, at 23:47.
Comments or questions about this documentation? Contact us for support!
In the Column List:
Modified: 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
In partitioned databases, this table is partitioned.
This table provides information about the execution history of Job_MaintainGIM as it pertains to purge.
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
JOB_ID | VARCHAR2(64 CHAR) | X | |||
JOB_VERSION | VARCHAR2(64 CHAR) | ||||
TABLE_NAME | VARCHAR2(255 CHAR) | X | |||
PURGE_MAX_TIME | TIMESTAMP(3) | ||||
PURGE_MAX_TS | NUMBER(10) | X | |||
PURGE_START_TIME | TIMESTAMP(3) | ||||
PURGE_END_TIME | TIMESTAMP(3) | ||||
ROW_COUNT | NUMBER(10) | ||||
CREATED_TS | NUMBER(10) | X |
ID that uniquely identifies the execution instance of the maintenance job.
The date and time, in the GMT time zone, that represent the highest timestamp value for the records that are deleted in a given purge cycle.
The UTC-equivalent value of the date and time that represents the highest timestamp value for the records that are deleted in a given purge cycle.
The date and time when the maintenance job started the purge cycle.
The date and time when the maintenance job finished the purge cycle.
The UTC-equivalent value of the date and time at which the maintenance job started the purge cycle.
CODE | U | C | Description |
---|---|---|---|
I_C_PURGE_H_CTS | Improves purge performance. |
Field | Sort | Comment |
---|---|---|
CREATED_TS | Ascending |
No subject area information available.