GVD_SEGMENT_STAT - Copy of GV$SEGMENT_STATISTICS (curr. not provided w. snaps)
Copy of GV$SEGMENT_STATISTICS (curr. not provided w. snaps) information is stored in SAP table GVD_SEGMENT_STAT.
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_SEGMENT_STAT
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 | |
| OWNER | Oracle monitoring: Owner of the object | X | ORA_OWNER_30 | CHAR | 30 | |
| OBJECT_NAME | Oracle monitoring: Name of the object | X | ORA_OBJECT_NAME | CHAR | 30 | |
| SUBOBJECT_NAME | Oracle monitoring: Name of the subobject | X | ORA_SUBOBJ_NAME | CHAR | 30 | |
| STATISTIC_NR | Oracle monitoring: Statistic number | X | ORA_STATISTIC_NR | DEC | 12 | |
| TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | ORA_TABLESPACE_NAME | CHAR | 30 | ||
| TS_NR | Oracle monitoring: tablespace number | ORA_TABLESPACE_NR | DEC | 12 | ||
| OBJ_NR | Oracle monitoring: Dictionary object number | ORA_OBJECT_NUMBER | DEC | 12 | ||
| DATAOBJ_NR | Oracle monitoring: Data object number | ORA_DATAOBJ_NR | DEC | 12 | ||
| OBJECT_TYPE | Oracle monitoring: Type of the object | ORA_OBJECT_TYPE | CHAR | 18 | ||
| STATISTIC_NAME | Oracle monitoring: Name of the statistic | ORA_STATISTIC_NAME | CHAR | 64 | ||
| VALUE | oracle monitor: value | ORA_VALUE_1 | DEC | 12 |