SAP ABAP Table ORA_DBA_SEGMENTS (Copy of DBA_SEGMENTS (currently not provided with snapshots))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷
STUN (Package) DBA: All the rest in English
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)⤷
STUN (Package) DBA: All the rest in English
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | ORA_DBA_SEGMENTS |
Table Relationship Diagram 
|
| Short Description | Copy of DBA_SEGMENTS (currently not provided with snapshots) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  SNAPSHOT_ID |
ORA_SNAPSHOT_ID | ORA_SNAPSHOT_ID | NUMC | 10 | 0 | Oracle monitor: snapshot ID | * | |
| 2 | OWNER |
ORA_OWNER_30 | ORA_CHAR_30 | CHAR | 30 | 0 | Oracle monitoring: Owner of the object | ||
| 3 | SEGMENT_NAME |
ORA_SEGMENT_NAME | ORA_CHAR_81 | CHAR | 81 | 0 | Oracle monitoring: Segment name | ||
| 4 | PARTITION_NAME |
ORA_PARTITION_NAME | ORA_CHAR_30 | CHAR | 30 | 0 | Oracle monitoring: Object Partition Name | ||
| 5 | SEGMENT_TYPE |
ORA_SEGMENT_TYPE | ORA_SEGMENT_TYPE | CHAR | 18 | 0 | Oracle monitoring: Segment type | ||
| 6 | TABLESPACE_NAME |
ORA_TABLESPACE_NAME | ORA_CHAR_30 | CHAR | 30 | 0 | Oracle monitoring: Tablespacename to which objects belong | ||
| 7 | HEADER_FILE |
ORA_HEADER_FILE | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: ID of file containing the segment header | ||
| 8 | HEADER_BLOCK |
ORA_HEADER_BLOCK | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring:ID of block containing the segment header | ||
| 9 | BYTES |
ORA_BYTES_SEG | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Size of segment (Bytes) | ||
| 10 | BLOCKS |
ORA_BLOCKS_SEG | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Size of segment in Oracle blocks | ||
| 11 | EXTENTS |
ORA_EXTENTS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of extents allocated to segment | ||
| 12 | INITIAL_EXTENT |
ORA_INITIAL_EXTENT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Size of the initial extent in bytes | ||
| 13 | NEXT_EXTENT |
ORA_NEXT_EXTENT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: Next extent | ||
| 14 | MIN_EXTENTS |
ORA_MIN_EXTENTS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: Minimum extent | ||
| 15 | MAX_EXTENTS |
ORA_MAX_EXTENTS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: Maximum extent | ||
| 16 | PCT_INCREASE |
ORA_PCT_INCREASE | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor. PCT increase | ||
| 17 | FREELISTS |
ORA_FREELISTS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of process freelists allocated | ||
| 18 | FREELIST_GROUPS |
ORA_FREELIST_GROUPS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of freelist groups allocated | ||
| 19 | RELATIVE_FNO |
ORA_RELATIVE_FNO | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Relative file number of segment header | ||
| 20 | BUFFER_POOL |
ORA_BUFFER_POOL | ORA_CHAR_7 | CHAR | 7 | 0 | Oracle monitoring: The default buffer pool for the object |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |
