SAP ABAP Data Element ST04N_IEFF_INMEM_SORT (In-memory sort ratio)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Data Element	ST04N_IEFF_INMEM_SORT
Short Description	In-memory sort ratio

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	ST04N_DEC_1_4
Data Type	DEC	Counter or amount field with comma and sign
Length	5
Decimal Places	4
Output Length	6
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	In-mem srt
Medium	15	In-memory sort
Long	20	In-memory sort ratio
Heading	14	In-memory sort

Documentation

Definition

The in-memory sort ratio is calculated as quality rate by the formula:
sortsmemory / (sortsmemory + sortsdisk)

This shows the proportion of sorts that are performed in memory. Optimally, in an operational (OLTP) system, most sorts are small and can be performed solely as in-memory sorts.

Non RAC / RAC Detail: Ratio of the current instance.

RAC Total: Average ratio over all instances.

(Data source: gv$sysstat, 'sorts (memory)', 'sorts (disk)')

The appearance of a light (yellow / red) depends on the key figures deviation from value 1 in percent. Limits for the colors can be maintained in customizing table ST04N_LIM.

Use

Dependencies

Example

History

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