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