GVD_FILESTAT - Copy of GV$FILESTAT
Copy of GV$FILESTAT information is stored in SAP table GVD_FILESTAT.
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_FILESTAT
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_NB | Oracle monitoring: filestat file# | X | ORA_FILE_FILESTAT | DEC | 12 | |
| PHYRDS | Oracel monitoring: filestat physical reads | ORA_PHYRDS | DEC | 12 | ||
| PHYWRTS | Oracle monitoring: filestat physical writes | ORA_PHYWRTS | DEC | 12 | ||
| PHYBLKRD | Oracle monitoring: filestat physical block read | ORA_PHYBLKRD | DEC | 12 | ||
| PHYBLKWRT | Oracle monitoring: filestat physical block writes | ORA_PHYBLKWRT | DEC | 12 | ||
| SINGLEBLKRDS | Oracle monitoring: filestat single block reads | ORA_SINGLEBLKRDS | DEC | 12 | ||
| READTIM | Oracle monitoring: filestat read time | ORA_READTIM | DEC | 12 | ||
| WRITETIM | Oracle monitoring: filestat write time | ORA_WRITETIM | DEC | 12 | ||
| SINGLEBLKRDTIM | Oracle monitoring: filestat single block read time | ORA_SINGLEBLKRDTIM | DEC | 12 | ||
| AVGIOTIM | Oracle monitoring: filestat average I/O time | ORA_AVGIOTIM | DEC | 12 | ||
| LSTIOTIM | Oracle monitoring: filestat lst I/O time | ORA_LSTIOTIM | DEC | 12 | ||
| MINIOTIM | Oracle monitoring: filestat min I/O time | ORA_MINIOTIM | DEC | 12 | ||
| MAXIORTM | Oracle monitoring: filestat max I/O read time | ORA_MAXIORTM | DEC | 12 | ||
| MAXIOWTM | Oracle monitoring: filestat max I/O wait time | ORA_MAXIOWTM | DEC | 12 |