SAP ORA_DBA_EXTENTS table - Copy of DBA_EXTENTS (currently not provided with snapshots) details in SAP

SAP ORA_DBA_EXTENTS table summary

Object Name: ORA_DBA_EXTENTS
Dictionary Type: Transparent table
Description: Copy of DBA_EXTENTS (currently not provided with snapshots)

Field list for ORA_DBA_EXTENTS table on an S/4 SAP system

Details

ORA_DBA_EXTENTS-SNAPSHOT_ID table field - Oracle monitor: snapshot ID ▼

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

ORA_DBA_EXTENTS-OWNER table field - Oracle monitoring: Owner of the object ▼

Description: Oracle monitoring: Owner of the object
Field Name: OWNER
Data Element: ORA_OWNER_30
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNER

ORA_DBA_EXTENTS-SEGMENT_NAME table field - Oracle monitoring: Segment name ▼

Description: Oracle monitoring: Segment name
Field Name: SEGMENT_NAME
Data Element: ORA_SEGMENT_NAME
Data Type: CHAR
length (Dec): 81(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_81
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEGMENT_NAME

ORA_DBA_EXTENTS-PARTITION_NAME table field - Oracle monitoring: Object Partition Name ▼

Description: Oracle monitoring: Object Partition Name
Field Name: PARTITION_NAME
Data Element: ORA_PARTITION_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITION_NAME

ORA_DBA_EXTENTS-SEGMENT_TYPE table field - Oracle monitoring: Type of segment: INDEX/TABLE PARTITION ▼

Description: Oracle monitoring: Type of segment: INDEX/TABLE PARTITION
Field Name: SEGMENT_TYPE
Data Element: ORA_SEGMENT_TYPE_2
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_18
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEGMENT_TYPE

ORA_DBA_EXTENTS-TABLESPACE_NAME table field - Oracle monitoring: Tablespacename to which objects belong ▼

Description: Oracle monitoring: Tablespacename to which objects belong
Field Name: TABLESPACE_NAME
Data Element: ORA_TABLESPACE_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLESPACE_NAME

ORA_DBA_EXTENTS-EXTENT_ID table field - Oracle monitoring: Extent number in the segment ▼

Description: Oracle monitoring: Extent number in the segment
Field Name: EXTENT_ID
Data Element: ORA_EXTEND_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENT_ID

ORA_DBA_EXTENTS-FILE_ID table field - Oracle monitoring: File of the file containing the extend ▼

Description: Oracle monitoring: File of the file containing the extend
Field Name: FILE_ID
Data Element: ORA_FILE_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILE_ID

ORA_DBA_EXTENTS-BLOCK_ID table field - Oracle monitoring: Block number ▼

Description: Oracle monitoring: Block number
Field Name: BLOCK_ID
Data Element: ORA_BLOCK_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK_ID

ORA_DBA_EXTENTS-BYTES table field - Oracle monitoring: Size of the extent in bytes ▼

Description: Oracle monitoring: Size of the extent in bytes
Field Name: BYTES
Data Element: ORA_BYTES_EXTEND
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BYTES

ORA_DBA_EXTENTS-BLOCKS table field - Oracle monitoring: Size of the extent in Oracle blocks ▼

Description: Oracle monitoring: Size of the extent in Oracle blocks
Field Name: BLOCKS
Data Element: ORA_BLOCKS_EXT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKS

ORA_DBA_EXTENTS-RELATIVE_FNO table field - Oracle monitoring:Relative file number of first extent block ▼

Description: Oracle monitoring:Relative file number of first extent block
Field Name: RELATIVE_FNO
Data Element: ORA_RELATIVE_FNO_BL
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATIVE_FNO

View list of all SAP tables(S4H/ECC)

Select data from SAP table