SAP Table ORA_DBA_EXTENTS
Copy of DBA_EXTENTS (currently not provided with snapshots)
Unsere Literaturempfehlung
Kundeneigene Erweiterungen mit ABAP: User-Exits, klassische und neue BAdIs, Switch und Enhancement Framework
Alle Technologien in einem Band! Ob Sie zukunftssichere Erweiterungen programmieren oder mit den Modifikationen in Ihren SAP-Systemen aufräumen möchten – hier erhalten Sie das erforderliche Wissen. Jede Methode wird ausführlich und mit Codebeispielen erläutert: User-Exits, klassische und neue BAdIs, Business Transaction Events, implizite und explizite Erweiterungspunkte u. v. m.
Bei amazon.de ansehen →
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 |