ORA_SNAPSHOT - Master data of an oracle monitor snapshot
Master data of an oracle monitor snapshot information is stored in SAP table ORA_SNAPSHOT.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table ORA_SNAPSHOT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | |
SNAPSHOT_TYPE | Type of the oracle database snapshot | ORA_SNAPSHOT_TYPE | CHAR | 1 | ||
SNAPSHOT_VALID | Oracle snapshot is valid and complete? | ORA_SNAPSHOT_VALID | CHAR | 1 | ||
ORA_SYSDATE_D | Oracle system date of snapshot | ORA_SYSDATE_D | DATS | 8 | ||
ORA_SYSDATE_T | Oracle system time of snapshot | ORA_SYSDATE_T | TIMS | 6 | ||
SAP_DATE | SAP Date of the Oracle snapshot | ORA_SAP_DATE | DATS | 8 | ||
SAP_TIME | SAP Time of oracle snapshot | ORA_SAP_TIME | TIMS | 6 | ||
SAP_USER | SAP user who initiated the snapshot | ORA_SAP_USER | CHAR | 12 |