SAP ORASAREA_E table - Additional Fields for 'Oracle Cursor Cache Stats' List details in SAP

SAP ORASAREA_E table summary

Object Name: ORASAREA_E
Dictionary Type: Structure
Description: Additional Fields for 'Oracle Cursor Cache Stats' List

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

Details

ORASAREA_E-OPEN_VERSI table field - Number of opened cursor versions ▼

Description: Number of opened cursor versions
Field Name: OPEN_VERSI
Data Element: ORAOPENVER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_VERSI

ORASAREA_E-USERS_OPEN table field - Number of users who have opened cursor version ▼

Description: Number of users who have opened cursor version
Field Name: USERS_OPEN
Data Element: ORAUSROPEN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERS_OPEN

ORASAREA_E-LOADED_VER table field - Loaded cursor versions ▼

Description: Loaded cursor versions
Field Name: LOADED_VER
Data Element: ORALOADVER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADED_VER

ORASAREA_E-SHARABLE_M table field - Total shareable memory ▼

Description: Total shareable memory
Field Name: SHARABLE_M
Data Element: ORASHARMEM
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHARABLE_M

ORASAREA_E-PERSISTENT table field - Total 'persistent memory' ▼

Description: Total 'persistent memory'
Field Name: PERSISTENT
Data Element: ORAPERSMEM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORAMEMORY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSISTENT

ORASAREA_E-RUNTIME_ME table field - Total 'runtime memory' ▼

Description: Total 'runtime memory'
Field Name: RUNTIME_ME
Data Element: ORARUNTMEM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORAMEMORY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNTIME_ME

ORASAREA_E-INVALIDATI table field - Number of 'invalidations' for all versions ▼

Description: Number of 'invalidations' for all versions
Field Name: INVALIDATI
Data Element: ORAINVALID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INVALIDATI

ORASAREA_E-LOADS table field - Number of loads or reloads ▼

Description: Number of loads or reloads
Field Name: LOADS
Data Element: ORALOADS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB5
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADS

ORASAREA_E-PARSE_CALL table field - Sum of all 'parse calls' ▼

Description: Sum of all 'parse calls'
Field Name: PARSE_CALL
Data Element: ORAPARSEC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSE_CALL

ORASAREA_E-MODULE table field - Program Name ▼

Description: Program Name
Field Name: MODULE
Data Element: ORAMODULE
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORACHAR64
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MODULE

ORASAREA_E-DB_USER table field - Column USERNAME in V$SESSION ▼

Description: Column USERNAME in V$SESSION
Field Name: DB_USER
Data Element: ORAUSER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB_USER

ORASAREA_E-FIRST_LOAD table field - Time SQL statement loaded ▼

Description: Time SQL statement loaded
Field Name: FIRST_LOAD
Data Element: ORALOAD_T
Data Type: CHAR
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: ORATIMESTA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRST_LOAD

View list of all SAP tables(S4H/ECC)

Select data from SAP table