GVD_SESS_IO - Copy of GV$SESS_IO (currently not provided with snapshots)
Copy of GV$SESS_IO (currently not provided with snapshots) information is stored in SAP table GVD_SESS_IO.
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_SESS_IO
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 | |
| SID | Oracle monitoring: SID (Session) | X | ORA_SID | DEC | 12 | |
| BLOCK_GETS | Oracle monitoring: ORA_BLOCK_GETS: Block gets for this sessi | ORA_BLOCK_GETS | DEC | 12 | ||
| CONSISTENT_GETS | Oracle monitoring: CONSISTENT_GETS: Consistent gets for sess | ORA_CONSISTENT_GETS | DEC | 12 | ||
| PHYSICAL_READS | Oracle monitoring: PHYSICAL_READS: Physical reads for sess. | ORA_PHYSICAL_READS | DEC | 12 | ||
| BLOCK_CHANGES | Oracle monitoring: BLOCK_CHANGES: Block changes for session | ORA_BLOCK_CHANGES | DEC | 12 | ||
| CONSISTENT_CHANG | Oracle monitoring: CONSISTENT_CHANGES: Consistent changes | ORA_CONSISTENT_CHANGES | DEC | 12 |