ORA_DBA_EXTENTS - Copy of DBA_EXTENTS (currently not provided with snapshots)
Copy of DBA_EXTENTS (currently not provided with snapshots) information is stored in SAP table ORA_DBA_EXTENTS.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table ORA_DBA_EXTENTS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| OWNER | Oracle monitoring: Owner of the object | X | ORA_OWNER_30 | CHAR | 30 | |
| SEGMENT_NAME | Oracle monitoring: Segment name | X | ORA_SEGMENT_NAME | CHAR | 81 | |
| PARTITION_NAME | Oracle monitoring: Object Partition Name | X | ORA_PARTITION_NAME | CHAR | 30 | |
| SEGMENT_TYPE | Oracle monitoring: Type of segment: INDEX/TABLE PARTITION | X | ORA_SEGMENT_TYPE_2 | CHAR | 18 | |
| TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | X | ORA_TABLESPACE_NAME | CHAR | 30 | |
| EXTENT_ID | Oracle monitoring: Extent number in the segment | X | ORA_EXTEND_ID | DEC | 12 | |
| FILE_ID | Oracle monitoring: File of the file containing the extend | ORA_FILE_ID | DEC | 12 | ||
| BLOCK_ID | Oracle monitoring: Block number | ORA_BLOCK_ID | DEC | 12 | ||
| BYTES | Oracle monitoring: Size of the extent in bytes | ORA_BYTES_EXTEND | DEC | 12 | ||
| BLOCKS | Oracle monitoring: Size of the extent in Oracle blocks | ORA_BLOCKS_EXT | DEC | 12 | ||
| RELATIVE_FNO | Oracle monitoring:Relative file number of first extent block | ORA_RELATIVE_FNO_BL | DEC | 12 |