[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | SY_PURG_MST |
|---|---|
| Object Type: | TABLE |
| Owner: | GMA |
| FND Design Data: |  GMA.SY_PURG_MST
|
| Subobject Name: | |
| Status: | VALID |
Table storing data of all OPM Archives/Purges that have been run
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| SY_PURG_MST_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PURGE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PURGE_ID | NUMBER | (5) | Yes | Unique identifier for each purge. |
| PURGE_TYPE | VARCHAR2 | (4) | Yes | Purge Type - the name of the Purge and Archive routine (eg, PROD). |
| STATUS | NUMBER | (5) | Yes | No longer used. Purge Status used instead. |
| PURGE_COMMENT | VARCHAR2 | (256) | User entered purge comment. | |
| ROWS_ARCHIVED | NUMBER | (10) | Number of rows archived for this purge_id. | |
| ROWS_DELETED | NUMBER | (10) | Number of rows deleted for this purge_id. | |
| ARCHIVE_START_TIME | DATE | Date and Time Archive process began. | ||
| ARCHIVE_ELAPSED_TIME | NUMBER | (38) | Elapsed time ONLY FOR ARCHIVE (in seconds). | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| ORA_STATUS | NUMBER | Oracle Error message number | ||
| PURGE_START_TIME | DATE | Date and Time Purge process began. | ||
| PURGE_ELAPSED_TIME | NUMBER | (38) | Elapsed time ONLY FOR PURGE (in seconds). | |
| TRANS_CNT | NUMBER | (10) | Not currently used | |
| DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| SELECTION_ELAPSED_TIME | NUMBER | (38) | Time in seconds for P/A row selection | |
| COPY_ELAPSED_TIME | NUMBER | (38) | Time in seconds for copy function | |
| ROWS_PER_SECOND | NUMBER | (38) | Rows per second using end to end P/A execution time (includes selection time). | |
| COPY_ROWS_PER_SECOND | NUMBER | (38) | Rows per second * just* usin copy time. Probably represents a platform dependent constant. Performance increases as rows_per_second approaches copy_rows_per_second. | |
| DEBUG_FLAG | VARCHAR2 | (1) | If set to 'T', adds debuggin information to logged output. Basically, this means that the generated SQL is output for analysis. | |
| DISABLE_CONSTRAINTS_FLAG | VARCHAR2 | (1) | If set to 'T', disables constraints as appropriate before the copy function starts and restores them after the end of the ocpy function. 'As appropriate', means that if a table is marked for delete, constraints are disabled. This greatly spedd performance. This requires that the purge definition respects data integrity constraints (as it should be). | |
| CALCULATE_STORAGE_FLAG | VARCHAR2 | (1) | If set to 'T', calcuates the size of target tables before the copy function and attempts to allocate the entire space. Failure to do so will *not* stop archiver; archiver will then just use 'standard' method. | |
| COMMIT_FREQUENCY | NUMBER | Store value that designates how often to commit. Advanced users may find that this settin affects copy_rows_per_second. Defaults to 1000 if not specified. | ||
| PURGE_STATUS | NUMBER | (5) | Yes | 0= Defined, not yet run. 1= Archive in progress. 2= Archived Successfully. 3= Purge in progress. 4= Purge Completed Successfully. -1= Archive process failed. -3=Purge process failed. |
| OBJECT_OWNER | VARCHAR2 | (30) | The name of the Product that owns the purged object. | |
| ARCHIVE_TABLE_COUNT | NUMBER | Count of tables to be archived. |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_ID
, PURGE_TYPE
, STATUS
, PURGE_COMMENT
, ROWS_ARCHIVED
, ROWS_DELETED
, ARCHIVE_START_TIME
, ARCHIVE_ELAPSED_TIME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ORA_STATUS
, PURGE_START_TIME
, PURGE_ELAPSED_TIME
, TRANS_CNT
, DELETE_MARK
, TEXT_CODE
, LAST_UPDATE_LOGIN
, SELECTION_ELAPSED_TIME
, COPY_ELAPSED_TIME
, ROWS_PER_SECOND
, COPY_ROWS_PER_SECOND
, DEBUG_FLAG
, DISABLE_CONSTRAINTS_FLAG
, CALCULATE_STORAGE_FLAG
, COMMIT_FREQUENCY
, PURGE_STATUS
, OBJECT_OWNER
, ARCHIVE_TABLE_COUNT
FROM GMA.SY_PURG_MST;
GMA.SY_PURG_MST does not reference any database object
GMA.SY_PURG_MST is referenced by following:
APPS
SY_PURG_MST
|
|
|
|