GVD_TEMPFILE - Copy of GV$TEMPFILE
Copy of GV$TEMPFILE information is stored in SAP table GVD_TEMPFILE.
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_TEMPFILE
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_NUM | Oracle monitor: File# | X | ORA_FILE_NUM | DEC | 12 | |
| CREATION_CHG_NUM | Oracle monitor: Cretaion change number | ORA_CREATION_CHG_NUM | DEC | 12 | ||
| CREATION_TIME_D | Oracle monitor: Creation time (date) | ORA_CREAT_TIME_D | DATS | 8 | ||
| CREATION_TIME_T | Oracle monitor: Creation time | ORA_CREAT_TIME_T | TIMS | 6 | ||
| TS_NUM | Oracle monitor: TS# | ORA_TS_NUM | DEC | 12 | ||
| RFILE_NUM | Oracle monitor: RFILE NUMBER | ORA_RFILE_NUM | DEC | 12 | ||
| STATUS | Oracle monitoring: Current status temp. file | ORA_STATUS_TMPFILE | CHAR | 7 | ||
| ENABLED | Oracle monitor: Gtemp. File ENABLED | ORA_ENEBLED | CHAR | 10 | ||
| BYTES | Oracle monitoring: BYTES: Memory size in bytes | ORA_BYTES | DEC | 12 | ||
| BLOCKS | Oracle monitoring: Size of the archived redo log in 512-byte | ORA_BLOCKS | 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_LENGTH | Oracle Monitoring: Field to store length of long char types | ORA_TEXT_LENGTH | INT4 | 4 | ||
| NAME | Oracle Monitoring: Temp file name | ORA_TMPFIL_NAME | LCHR | 513 |