SAP Table ORA_DBA_EXTENTS
Copy of DBA_EXTENTS (currently not provided with snapshots)
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table ORA_DBA_EXTENTS (Copy of DBA_EXTENTS (currently not provided with snapshots)) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | ORA_DBA_EXTENTS |
| Short Text | Copy of DBA_EXTENTS (currently not provided with snapshots) |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table ORA_DBA_EXTENTS
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | ✔ | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| OWNER | ✔ | Oracle monitoring: Owner of the object | ORA_OWNER_30 | CHAR | 30 | |
| SEGMENT_NAME | ✔ | Oracle monitoring: Segment name | ORA_SEGMENT_NAME | CHAR | 81 | |
| PARTITION_NAME | ✔ | Oracle monitoring: Object Partition Name | ORA_PARTITION_NAME | CHAR | 30 | |
| SEGMENT_TYPE | ✔ | Oracle monitoring: Type of segment: INDEX/TABLE PARTITION | ORA_SEGMENT_TYPE_2 | CHAR | 18 | |
| TABLESPACE_NAME | ✔ | Oracle monitoring: Tablespacename to which objects belong | ORA_TABLESPACE_NAME | CHAR | 30 | |
| EXTENT_ID | ✔ | Oracle monitoring: Extent number in the segment | ORA_EXTEND_ID | DEC | 22 | |
| FILE_ID | Oracle monitoring: File of the file containing the extend | ORA_FILE_ID | DEC | 22 | ||
| BLOCK_ID | Oracle monitoring: Block number | ORA_BLOCK_ID | DEC | 22 | ||
| BYTES | Oracle monitoring: Size of the extent in bytes | ORA_BYTES_EXTEND | DEC | 22 | ||
| BLOCKS | Oracle monitoring: Size of the extent in Oracle blocks | ORA_BLOCKS_EXT | DEC | 22 | ||
| RELATIVE_FNO | Oracle monitoring:Relative file number of first extent block | ORA_RELATIVE_FNO_BL | DEC | 22 |