ORA_DBA_SEGMENTS - Copy of DBA_SEGMENTS (currently not provided with snapshots)
Copy of DBA_SEGMENTS (currently not provided with snapshots) information is stored in SAP table ORA_DBA_SEGMENTS.
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 ORA_DBA_SEGMENTS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| OWNER | Oracle monitoring: Owner of the object | X | ORA_OWNER_30 | CHAR | 30 | |
| SEGMENT_NAME | Oracle monitoring: Segment name | X | ORA_SEGMENT_NAME | CHAR | 81 | |
| PARTITION_NAME | Oracle monitoring: Object Partition Name | X | ORA_PARTITION_NAME | CHAR | 30 | |
| SEGMENT_TYPE | Oracle monitoring: Segment type | X | ORA_SEGMENT_TYPE | CHAR | 18 | |
| TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | ORA_TABLESPACE_NAME | CHAR | 30 | ||
| HEADER_FILE | Oracle monitoring: ID of file containing the segment header | ORA_HEADER_FILE | DEC | 12 | ||
| HEADER_BLOCK | Oracle monitoring:ID of block containing the segment header | ORA_HEADER_BLOCK | DEC | 12 | ||
| BYTES | Oracle monitoring: Size of segment (Bytes) | ORA_BYTES_SEG | DEC | 12 | ||
| BLOCKS | Oracle monitoring: Size of segment in Oracle blocks | ORA_BLOCKS_SEG | DEC | 12 | ||
| EXTENTS | Oracle monitoring: Number of extents allocated to segment | ORA_EXTENTS | DEC | 12 | ||
| INITIAL_EXTENT | Oracle monitoring: Size of the initial extent in bytes | ORA_INITIAL_EXTENT | DEC | 12 | ||
| NEXT_EXTENT | Oracle monitor: Next extent | ORA_NEXT_EXTENT | DEC | 12 | ||
| MIN_EXTENTS | Oracle monitor: Minimum extent | ORA_MIN_EXTENTS | DEC | 12 | ||
| MAX_EXTENTS | Oracle monitor: Maximum extent | ORA_MAX_EXTENTS | DEC | 12 | ||
| PCT_INCREASE | Oracle monitor. PCT increase | ORA_PCT_INCREASE | DEC | 12 | ||
| FREELISTS | Oracle monitoring: Number of process freelists allocated | ORA_FREELISTS | DEC | 12 | ||
| FREELIST_GROUPS | Oracle monitoring: Number of freelist groups allocated | ORA_FREELIST_GROUPS | DEC | 12 | ||
| RELATIVE_FNO | Oracle monitoring: Relative file number of segment header | ORA_RELATIVE_FNO | DEC | 12 | ||
| BUFFER_POOL | Oracle monitoring: The default buffer pool for the object | ORA_BUFFER_POOL | CHAR | 7 |