SAP ABAP Table ORA_DBA_EXTENTS (Copy of DBA_EXTENTS (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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ORA_DBA_EXTENTS	Table Relationship Diagram
Short Description	Copy of DBA_EXTENTS (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_2	ORA_NUM_18	CHAR	18	0	Oracle monitoring: Type of segment: INDEX/TABLE PARTITION
6	TABLESPACE_NAME	☑	ORA_TABLESPACE_NAME	ORA_CHAR_30	CHAR	30	0	Oracle monitoring: Tablespacename to which objects belong
7	EXTENT_ID	☑	ORA_EXTEND_ID	ORA_NUM_22	DEC	22	0	Oracle monitoring: Extent number in the segment
8	FILE_ID	☐	ORA_FILE_ID	ORA_NUM_22	DEC	22	0	Oracle monitoring: File of the file containing the extend
9	BLOCK_ID	☐	ORA_BLOCK_ID	ORA_NUM_22	DEC	22	0	Oracle monitoring: Block number
10	BYTES	☐	ORA_BYTES_EXTEND	ORA_NUM_22	DEC	22	0	Oracle monitoring: Size of the extent in bytes
11	BLOCKS	☐	ORA_BLOCKS_EXT	ORA_NUM_22	DEC	22	0	Oracle monitoring: Size of the extent in Oracle blocks
12	RELATIVE_FNO	☐	ORA_RELATIVE_FNO_BL	ORA_NUM_22	DEC	22	0	Oracle monitoring:Relative file number of first extent block

History

Last changed by/on	SAP	20130604
SAP Release Created in	700