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

SAP ORASQLAREA table summary

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

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

Details

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ORASQLAREA-CHILD_LATC table field - Child Latch Number ▼

Description: Child Latch Number
Field Name: CHILD_LATC
Data Element: ORACHILDLA
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 CHILD_LATC

ORASQLAREA-CPU_TIME table field - CPU Time in Miroseconds ▼

Description: CPU Time in Miroseconds
Field Name: CPU_TIME
Data Element: ORACPUTIME
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 CPU_TIME

ORASQLAREA-ELAPSED_TI table field - Elapsed Time in Microseconds ▼

Description: Elapsed Time in Microseconds
Field Name: ELAPSED_TI
Data Element: ORAELAPSED
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 ELAPSED_TI

ORASQLAREA-DISKRPER_E table field - Number of 'disk reads' for each execution ▼

Description: Number of 'disk reads' for each execution
Field Name: DISKRPER_E
Data Element: ORADRPERE
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISKRPER_E

ORASQLAREA-BUFFGPER_E table field - Number of 'buffer gets' for each execution ▼

Description: Number of 'buffer gets' for each execution
Field Name: BUFFGPER_E
Data Element: ORABGPERE
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFGPER_E

ORASQLAREA-PARSCPER_E table field - Parse calls per execution ▼

Description: Parse calls per execution
Field Name: PARSCPER_E
Data Element: ORAPCPERE
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSCPER_E

ORASQLAREA-ROWSPPER_E table field - Number of rows processed for each execution ▼

Description: Number of rows processed for each execution
Field Name: ROWSPPER_E
Data Element: ORARPPERE
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWSPPER_E

ORASQLAREA-BUFFGPER_R table field - Number of 'buffer gets' for each row ▼

Description: Number of 'buffer gets' for each row
Field Name: BUFFGPER_R
Data Element: ORABGPERR
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFGPER_R

ORASQLAREA-COLFIELD table field - Field for controlling colors in ABAP List Viewer ▼

Description: Field for controlling colors in ABAP List Viewer
Field Name: COLFIELD
Data Element: ORACOLFIEL
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLFIELD

ORASQLAREA-WAIT_TIME table field - Wait time ▼

Description: Wait time
Field Name: WAIT_TIME
Data Element: ORAWAITTIM
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 WAIT_TIME

ORASQLAREA-CPU_TIME_E table field - CPU Time per Execution ▼

Description: CPU Time per Execution
Field Name: CPU_TIME_E
Data Element: ORACTPERE
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPU_TIME_E

ORASQLAREA-ELAPSEDTIE table field - Elapsed Time per Execution ▼

Description: Elapsed Time per Execution
Field Name: ELAPSEDTIE
Data Element: ORAELAPERE
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELAPSEDTIE

ORASQLAREA-WAITTIME_E table field - Wait Time per Execution ▼

Description: Wait Time per Execution
Field Name: WAITTIME_E
Data Element: ORAWTPERE
Data Type: DEC
length (Dec): 31(1)
Check table:
Conversion Routine:
Domain Name: ORADEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITTIME_E

View list of all SAP tables(S4H/ECC)

Select data from SAP table