SAP ORA_DBA_SEGMENTS table - Copy of DBA_SEGMENTS (currently not provided with snapshots) details in SAP

SAP ORA_DBA_SEGMENTS table summary

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

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

Details

ORA_DBA_SEGMENTS-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_SEGMENTS-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_SEGMENTS-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_SEGMENTS-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_SEGMENTS-SEGMENT_TYPE table field - Oracle monitoring: Segment type ▼

Description: Oracle monitoring: Segment type
Field Name: SEGMENT_TYPE
Data Element: ORA_SEGMENT_TYPE
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: ORA_SEGMENT_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEGMENT_TYPE

ORA_DBA_SEGMENTS-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_SEGMENTS-HEADER_FILE table field - Oracle monitoring: ID of file containing the segment header ▼

Description: Oracle monitoring: ID of file containing the segment header
Field Name: HEADER_FILE
Data Element: ORA_HEADER_FILE
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 HEADER_FILE

ORA_DBA_SEGMENTS-HEADER_BLOCK table field - Oracle monitoring:ID of block containing the segment header ▼

Description: Oracle monitoring:ID of block containing the segment header
Field Name: HEADER_BLOCK
Data Element: ORA_HEADER_BLOCK
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 HEADER_BLOCK

ORA_DBA_SEGMENTS-BYTES table field - Oracle monitoring: Size of segment (Bytes) ▼

Description: Oracle monitoring: Size of segment (Bytes)
Field Name: BYTES
Data Element: ORA_BYTES_SEG
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_SEGMENTS-BLOCKS table field - Oracle monitoring: Size of segment in Oracle blocks ▼

Description: Oracle monitoring: Size of segment in Oracle blocks
Field Name: BLOCKS
Data Element: ORA_BLOCKS_SEG
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_SEGMENTS-EXTENTS table field - Oracle monitoring: Number of extents allocated to segment ▼

Description: Oracle monitoring: Number of extents allocated to segment
Field Name: EXTENTS
Data Element: ORA_EXTENTS
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 EXTENTS

ORA_DBA_SEGMENTS-INITIAL_EXTENT table field - Oracle monitoring: Size of the initial extent in bytes ▼

Description: Oracle monitoring: Size of the initial extent in bytes
Field Name: INITIAL_EXTENT
Data Element: ORA_INITIAL_EXTENT
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 INITIAL_EXTENT

ORA_DBA_SEGMENTS-NEXT_EXTENT table field - Oracle monitor: Next extent ▼

Description: Oracle monitor: Next extent
Field Name: NEXT_EXTENT
Data Element: ORA_NEXT_EXTENT
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 NEXT_EXTENT

ORA_DBA_SEGMENTS-MIN_EXTENTS table field - Oracle monitor: Minimum extent ▼

Description: Oracle monitor: Minimum extent
Field Name: MIN_EXTENTS
Data Element: ORA_MIN_EXTENTS
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 MIN_EXTENTS

ORA_DBA_SEGMENTS-MAX_EXTENTS table field - Oracle monitor: Maximum extent ▼

Description: Oracle monitor: Maximum extent
Field Name: MAX_EXTENTS
Data Element: ORA_MAX_EXTENTS
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 MAX_EXTENTS

ORA_DBA_SEGMENTS-PCT_INCREASE table field - Oracle monitor. PCT increase ▼

Description: Oracle monitor. PCT increase
Field Name: PCT_INCREASE
Data Element: ORA_PCT_INCREASE
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 PCT_INCREASE

ORA_DBA_SEGMENTS-FREELISTS table field - Oracle monitoring: Number of process freelists allocated ▼

Description: Oracle monitoring: Number of process freelists allocated
Field Name: FREELISTS
Data Element: ORA_FREELISTS
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 FREELISTS

ORA_DBA_SEGMENTS-FREELIST_GROUPS table field - Oracle monitoring: Number of freelist groups allocated ▼

Description: Oracle monitoring: Number of freelist groups allocated
Field Name: FREELIST_GROUPS
Data Element: ORA_FREELIST_GROUPS
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 FREELIST_GROUPS

ORA_DBA_SEGMENTS-RELATIVE_FNO table field - Oracle monitoring: Relative file number of segment header ▼

Description: Oracle monitoring: Relative file number of segment header
Field Name: RELATIVE_FNO
Data Element: ORA_RELATIVE_FNO
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

ORA_DBA_SEGMENTS-BUFFER_POOL table field - Oracle monitoring: The default buffer pool for the object ▼

Description: Oracle monitoring: The default buffer pool for the object
Field Name: BUFFER_POOL
Data Element: ORA_BUFFER_POOL
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_7
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFER_POOL

View list of all SAP tables(S4H/ECC)

Select data from SAP table