GVD_DATAFILE - Copy of GV$DATAFILE
Copy of GV$DATAFILE information is stored in SAP table GVD_DATAFILE.
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 GVD_DATAFILE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| FILE_DATAFILE | Oracle monitoring: File# | X | ORA_FILE | DEC | 12 | |
| CREATION_CHANGE | Oracle monitoring: creation_change# | ORA_CREATION_CHANGE | DEC | 12 | ||
| CREATION_TIME_D | Oracle Monitoring: creation date | ORA_CREATION_DATE | DATS | 8 | ||
| CREATION_TIME_T | Oracle Monitoring: creation time | ORA_CREATION_TIME | TIMS | 6 | ||
| TS | Oracle Monitoring: File tablespace number | ORA_TS | DEC | 12 | ||
| RFILE | Oracle monitoring: rfile# | ORA_RFILE | DEC | 12 | ||
| STATUS | Oracle monitoring: ora_status | ORA_STATUS_DF | CHAR | 7 | ||
| ENABLED | Oracle Monitoring: enabled | ORA_ENABLED | CHAR | 10 | ||
| CHECKPOINT_CHANG | Oracle monitoring: file checkpoint change number | ORA_CHECKPOINT_CHANGE_DF | DEC | 12 | ||
| CHECKPOINT_TIMED | Oracle Monitoring: checkpoint_time | ORA_CHECKPOINT_DATE | DATS | 8 | ||
| CHECKPOINT_TIMET | Oracle Monitoring: checkpoint_time | ORA_CHECKPOINT_TIME | TIMS | 6 | ||
| UNRECOVERABLE_CH | Oracle monitoring: unrecoverable_change# | ORA_UNRECOVERABLE_CHANGE | DEC | 12 | ||
| UNRECOVERABLE_TD | Oracle monitoring: unrecoverable_date | ORA_UNRECOVERABLE_DATE | DATS | 8 | ||
| UNRECOVERABLE_TT | Oracle monitoring: unrecoverable_time | ORA_UNRECOVERABLE_TIME | TIMS | 6 | ||
| LAST_CHANGE | Oracle monitoring: last_change# | ORA_LAST_CHANGE | DEC | 12 | ||
| LAST_TIME_D | Oracle monitoring: last_time (date value) | ORA_LAST_DATE | DATS | 8 | ||
| LAST_TIME_T | Oracle monitoring: last_time | ORA_LAST_TIME | TIMS | 6 | ||
| OFFLINE_CHANGE | Oracle monitoring: offline_change# | ORA_OFFLINE_CHANGE | DEC | 12 | ||
| ONLINE_CHANGE | Oracle monitoring: online_change# | ORA_ONLINE_CHANGE | DEC | 12 | ||
| ONLINE_TIME_D | Oracle monitoring: online_time (date value) | ORA_ONLINE_DATE | DATS | 8 | ||
| ONLINE_TIME_T | Oracle monitoring: online_time | ORA_ONLINE_TIME | TIMS | 6 | ||
| BYTES | Oracle monitoring: bytes | ORA_BYTES_DF | DEC | 12 | ||
| BLOCKS | Oracle monitoring: blocks | ORA_BLOCKS_DF | DEC | 12 | ||
| CREATE_BYTES | Oracle monitor: CREATE BYTES | ORA_CREATE_BYTES | DEC | 12 | ||
| BLOCK_SIZE | Oracle monitor: BLOCK SIZE | ORA_BLOCK_SIZE | DEC | 12 | ||
| NAME | Oracle monitoring: name | ORA_NAME_DF | STRG | 8 | ||
| PLUGGED_IN | Oracle monitoring: plugged_in | ORA_PLUGGED_IN | DEC | 12 | ||
| BLOCK1_OFFSET | Oracle monitoring: block1_offset | ORA_BLOCK1_OFFSET | DEC | 12 | ||
| AUX_NAME | Oracle monitoring: aux_name | ORA_AUX_NAME | STRG | 8 |