Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value

Table CTL_PURGE_HISTORY

Description

Modified: 8.5.003 (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 List

Legend

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

JOB_ID

ID that uniquely identifies the execution instance of the maintenance job.

JOB_VERSION

The version of the job that purged data--for example, 8.1.000.10.

TABLE_NAME

The name of the table from which data was purged.

PURGE_MAX_TIME

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.

PURGE_MAX_TS

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.

PURGE_START_TIME

The date and time when the maintenance job started the purge cycle.

PURGE_END_TIME

The date and time when the maintenance job finished the purge cycle.

ROW_COUNT

The number of rows that was deleted in a given purge cycle.

CREATED_TS

The UTC-equivalent value of the date and time at which the maintenance job started the purge cycle.


Index List

CODE U C Description

I_C_PURGE_H_CTS

Improves purge performance.

Index I_C_PURGE_H_CTS

Field Sort Comment
CREATED_TS Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 15:00.