SAP ORAINDANAL table - Detailed Analysis of Oracle Indexes (fr. V.7) details in SAP

SAP ORAINDANAL table summary

Object Name: ORAINDANAL
Dictionary Type: Structure
Description: Detailed Analysis of Oracle Indexes (fr. V.7)

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

Details

ORAINDANAL-A_SIZE table field - Allocated diskspace for an Oracle table ▼

Description: Allocated diskspace for an Oracle table
Field Name: A_SIZE
Data Element: OA_SIZE
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field A_SIZE

ORAINDANAL-A_BLOCKS table field - Allocated blocks for an Oracle table ▼

Description: Allocated blocks for an Oracle table
Field Name: A_BLOCKS
Data Element: OA_BLOCKS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field A_BLOCKS

ORAINDANAL-A_EXTENTS table field - Allocated extents for an Oracle table ▼

Description: Allocated extents for an Oracle table
Field Name: A_EXTENTS
Data Element: OA_EXTENTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field A_EXTENTS

ORAINDANAL-INIT_EXT table field - Size of initial table extent ▼

Description: Size of initial table extent
Field Name: INIT_EXT
Data Element: OINIT_EXT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INIT_EXT

ORAINDANAL-NEXT_EXT table field - Size of next extent ▼

Description: Size of next extent
Field Name: NEXT_EXT
Data Element: ONEXT_EXT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEXT_EXT

ORAINDANAL-MIN_EXTS table field - Oracle storage parameter 'minextents' ▼

Description: Oracle storage parameter 'minextents'
Field Name: MIN_EXTS
Data Element: OMIN_EXTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_EXTS

ORAINDANAL-MAX_EXTS table field - Oracle storage parameter 'maxextents' ▼

Description: Oracle storage parameter 'maxextents'
Field Name: MAX_EXTS
Data Element: OMAX_EXTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_EXTS

ORAINDANAL-PCTINCR table field - Storage parameter 'pctincrease' ▼

Description: Storage parameter 'pctincrease'
Field Name: PCTINCR
Data Element: OPCTINCR
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCTINCR

ORAINDANAL-BLKSIZE table field - Oracle block size ▼

Description: Oracle block size
Field Name: BLKSIZE
Data Element: OBLKSIZE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLKSIZE

ORAINDANAL-PCT_FREE table field - Oracle storage parameter 'PCTFREE' ▼

Description: Oracle storage parameter 'PCTFREE'
Field Name: PCT_FREE
Data Element: OPCT_FREE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_FREE

ORAINDANAL-P_PCT_FREE table field - Recommended value for storage parameter 'PCTFREE' ▼

Description: Recommended value for storage parameter 'PCTFREE'
Field Name: P_PCT_FREE
Data Element: OP_PCT_FRE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P_PCT_FREE

ORAINDANAL-PCT_USED table field - Storage parameter 'PCTUSED' ▼

Description: Storage parameter 'PCTUSED'
Field Name: PCT_USED
Data Element: OPCT_USED
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_USED

ORAINDANAL-P_PCT_USED table field - Recommended value for storage parameter 'PCTUSED' ▼

Description: Recommended value for storage parameter 'PCTUSED'
Field Name: P_PCT_USED
Data Element: OP_PCT_USE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P_PCT_USED

ORAINDANAL-INI_TRANS table field - Number of initial transactions (Oracle storage parameter) ▼

Description: Number of initial transactions (Oracle storage parameter)
Field Name: INI_TRANS
Data Element: OINI_TRANS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INI_TRANS

ORAINDANAL-MAX_TRANS table field - Maximum number of transactions (Oracle storage parameter) ▼

Description: Maximum number of transactions (Oracle storage parameter)
Field Name: MAX_TRANS
Data Element: OMAX_TRANS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_TRANS

ORAINDANAL-HEADER_MIN table field - Block header, minimum size ▼

Description: Block header, minimum size
Field Name: HEADER_MIN
Data Element: OHEADER_MI
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEADER_MIN

ORAINDANAL-HEADER_MAX table field - Block header, maximum size ▼

Description: Block header, maximum size
Field Name: HEADER_MAX
Data Element: OHEADER_MA
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEADER_MAX

ORAINDANAL-DATA_MIN table field - Minimum size of the data area in a block ▼

Description: Minimum size of the data area in a block
Field Name: DATA_MIN
Data Element: ODATA_MIN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_MIN

ORAINDANAL-DATA_MAX table field - Maximum size of the data area in a block ▼

Description: Maximum size of the data area in a block
Field Name: DATA_MAX
Data Element: ODATA_MAX
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_MAX

ORAINDANAL-BLEVEL table field - Depth of the index from its root block to its leaf blocks ▼

Description: Depth of the index from its root block to its leaf blocks
Field Name: BLEVEL
Data Element: OBLEVEL
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLEVEL

ORAINDANAL-LEAF_BLKS table field - Number of leaf blocks in the index ▼

Description: Number of leaf blocks in the index
Field Name: LEAF_BLKS
Data Element: OLEAF_BLKS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAF_BLKS

ORAINDANAL-DIST_KEYS table field - Number of distinct indexed values ▼

Description: Number of distinct indexed values
Field Name: DIST_KEYS
Data Element: ODIST_KEYS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIST_KEYS

ORAINDANAL-L_BLKS_P_K table field - Avg. leaf blks per value of index key ▼

Description: Avg. leaf blks per value of index key
Field Name: L_BLKS_P_K
Data Element: OLBLKS_P_K
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field L_BLKS_P_K

ORAINDANAL-D_BLKS_P_K table field - Avg. data blocks per value of index ▼

Description: Avg. data blocks per value of index
Field Name: D_BLKS_P_K
Data Element: ODBLKS_P_K
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field D_BLKS_P_K

ORAINDANAL-CLU_FACTOR table field - Amount of order of table rows based on index values ▼

Description: Amount of order of table rows based on index values
Field Name: CLU_FACTOR
Data Element: OCLU_FACTO
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLU_FACTOR

View list of all SAP tables(S4H/ECC)

Select data from SAP table