SAP ORSQLAREA table - DDIC Structure According to Oracle Table V$SQLAREA details in SAP

SAP ORSQLAREA table summary

Object Name: ORSQLAREA
Dictionary Type: Structure
Description: DDIC Structure According to Oracle Table V$SQLAREA

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

Details

ORSQLAREA-SQL_TEXT table field - Start of SQL statement ▼

Description: Start of SQL statement
Field Name: SQL_TEXT
Data Element: ORASQLTEXT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_TEXT

ORSQLAREA-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

ORSQLAREA-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

ORSQLAREA-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

ORSQLAREA-SORTS table field - Sum of the number of sorts ▼

Description: Sum of the number of sorts
Field Name: SORTS
Data Element: ORASORTS
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 SORTS

ORSQLAREA-VERSION_CO table field - Number of children ▼

Description: Number of children
Field Name: VERSION_CO
Data Element: ORAVERSCOU
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VERSION_CO

ORSQLAREA-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

ORSQLAREA-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

ORSQLAREA-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

ORSQLAREA-EXECUTIONS table field - Total number of executions ▼

Description: Total number of executions
Field Name: EXECUTIONS
Data Element: ORAEXECNUM
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 EXECUTIONS

ORSQLAREA-USERS_EXEC table field - Number of users executing ▼

Description: Number of users executing
Field Name: USERS_EXEC
Data Element: ORAUSREXEC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB7
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERS_EXEC

ORSQLAREA-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

ORSQLAREA-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

ORSQLAREA-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

ORSQLAREA-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

ORSQLAREA-DISK_READS table field - Sum of all 'disk reads' ▼

Description: Sum of all 'disk reads'
Field Name: DISK_READS
Data Element: ORADISKR
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 DISK_READS

ORSQLAREA-BUFFER_GET table field - Total number of 'buffer gets' ▼

Description: Total number of 'buffer gets'
Field Name: BUFFER_GET
Data Element: ORABUFFERG
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 BUFFER_GET

ORSQLAREA-ROWS_PROCE table field - Number of processed rows ▼

Description: Number of processed rows
Field Name: ROWS_PROCE
Data Element: ORAROWPROC
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 ROWS_PROCE

ORSQLAREA-COMMAND_TY table field - Oracle command type definition ▼

Description: Oracle command type definition
Field Name: COMMAND_TY
Data Element: ORACOMTYPE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND_TY

ORSQLAREA-OPTIM_MODE table field - Optimizer mode ▼

Description: Optimizer mode
Field Name: OPTIM_MODE
Data Element: ORAOPTMODE
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORAOPTMODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTIM_MODE

ORSQLAREA-PARSING_US table field - ID of the user who built this child cursor ▼

Description: ID of the user who built this child cursor
Field Name: PARSING_US
Data Element: ORAPARSUSR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSING_US

ORSQLAREA-PARSING_SC table field - Schema ID ▼

Description: Schema ID
Field Name: PARSING_SC
Data Element: ORAPARSSCH
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSING_SC

ORSQLAREA-KEPT_VERSI table field - Indicator for using DBMS_SHARED_POOL ▼

Description: Indicator for using DBMS_SHARED_POOL
Field Name: KEPT_VERSI
Data Element: ORAKEPTVER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEPT_VERSI

ORSQLAREA-ADDRESS table field - Address of statement in the cache ▼

Description: Address of statement in the cache
Field Name: ADDRESS
Data Element: ORAADDRESS
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

ORSQLAREA-HASH_VALUE table field - Hash value of statement ▼

Description: Hash value of statement
Field Name: HASH_VALUE
Data Element: ORAHASHVAL
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: ORAP16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASH_VALUE

ORSQLAREA-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

ORSQLAREA-MODULE_HAS table field - Hash value of module ▼

Description: Hash value of module
Field Name: MODULE_HAS
Data Element: ORAMODULEH
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: ORAP16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MODULE_HAS

ORSQLAREA-ACTION table field - Action name ▼

Description: Action name
Field Name: ACTION
Data Element: ORAACTION
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTION

ORSQLAREA-ACTION_HAS table field - Hash value of action ▼

Description: Hash value of action
Field Name: ACTION_HAS
Data Element: ORAACTIONH
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: ORAP16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTION_HAS

ORSQLAREA-SERIALIZAB table field - Number of producing ORA-8177 ▼

Description: Number of producing ORA-8177
Field Name: SERIALIZAB
Data Element: ORASERIAL
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERIALIZAB

View list of all SAP tables(S4H/ECC)

Select data from SAP table