SAP Table ORA_DBA_SEGMENTS
Copy of DBA_SEGMENTS (currently not provided with snapshots)
ORA_DBA_SEGMENTS (Copy of DBA_SEGMENTS (currently not provided with snapshots)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ORA_DBA_SEGMENTS to other SAP tables.
ORA_DBA_SEGMENTS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | 0 | |||
| OWNER | Oracle monitoring: Owner of the object | ORA_OWNER_30 | CHAR | 30 | 0 | |||
| SEGMENT_NAME | Oracle monitoring: Segment name | ORA_SEGMENT_NAME | CHAR | 81 | 0 | |||
| PARTITION_NAME | Oracle monitoring: Object Partition Name | ORA_PARTITION_NAME | CHAR | 30 | 0 | |||
| SEGMENT_TYPE | Oracle monitoring: Segment type | ORA_SEGMENT_TYPE | CHAR | 18 | 0 | |||
| TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | ORA_TABLESPACE_NAME | CHAR | 30 | 0 | |||
| HEADER_FILE | Oracle monitoring: ID of file containing the segment header | ORA_HEADER_FILE | DEC | 22 | 0 | |||
| HEADER_BLOCK | Oracle monitoring:ID of block containing the segment header | ORA_HEADER_BLOCK | DEC | 22 | 0 | |||
| BYTES | Oracle monitoring: Size of segment (Bytes) | ORA_BYTES_SEG | DEC | 22 | 0 | |||
| BLOCKS | Oracle monitoring: Size of segment in Oracle blocks | ORA_BLOCKS_SEG | DEC | 22 | 0 | |||
| EXTENTS | Oracle monitoring: Number of extents allocated to segment | ORA_EXTENTS | DEC | 22 | 0 | |||
| INITIAL_EXTENT | Oracle monitoring: Size of the initial extent in bytes | ORA_INITIAL_EXTENT | DEC | 22 | 0 | |||
| NEXT_EXTENT | Oracle monitor: Next extent | ORA_NEXT_EXTENT | DEC | 22 | 0 | |||
| MIN_EXTENTS | Oracle monitor: Minimum extent | ORA_MIN_EXTENTS | DEC | 22 | 0 | |||
| MAX_EXTENTS | Oracle monitor: Maximum extent | ORA_MAX_EXTENTS | DEC | 22 | 0 | |||
| PCT_INCREASE | Oracle monitor. PCT increase | ORA_PCT_INCREASE | DEC | 22 | 0 | |||
| FREELISTS | Oracle monitoring: Number of process freelists allocated | ORA_FREELISTS | DEC | 22 | 0 | |||
| FREELIST_GROUPS | Oracle monitoring: Number of freelist groups allocated | ORA_FREELIST_GROUPS | DEC | 22 | 0 | |||
| RELATIVE_FNO | Oracle monitoring: Relative file number of segment header | ORA_RELATIVE_FNO | DEC | 22 | 0 | |||
| BUFFER_POOL | Oracle monitoring: The default buffer pool for the object | ORA_BUFFER_POOL | CHAR | 7 | 0 | |||
