SAP ORAV_SQL table - DDIC Structure According to Oracle Table V$SQL details in SAP

SAP ORAV_SQL table summary

Object Name: ORAV_SQL
Dictionary Type: Structure
Description: DDIC Structure According to Oracle Table V$SQL

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

Details

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

ORAV_SQL-SHARABLE_M table field - Shareable memory ▼

Description: Shareable memory
Field Name: SHARABLE_M
Data Element: ORSHARMEM
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 SHARABLE_M

ORAV_SQL-PERSISTENT table field - Persistent memory ▼

Description: Persistent memory
Field Name: PERSISTENT
Data Element: ORPERSMEM
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

ORAV_SQL-RUNTIME_ME table field - Ephemeral frame used ▼

Description: Ephemeral frame used
Field Name: RUNTIME_ME
Data Element: ORRUNTMEM
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

ORAV_SQL-SORTS table field - Number of sorts ▼

Description: Number of sorts
Field Name: SORTS
Data Element: ORSORTS
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 SORTS

ORAV_SQL-LOADED_VER table field - Context heap load flag ▼

Description: Context heap load flag
Field Name: LOADED_VER
Data Element: ORLOADVER
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 LOADED_VER

ORAV_SQL-OPEN_VERSI table field - Flag for child cursors is locked ▼

Description: Flag for child cursors is locked
Field Name: OPEN_VERSI
Data Element: OROPENVER
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 OPEN_VERSI

ORAV_SQL-USERS_OPEN table field - Number of users executing the statement ▼

Description: Number of users executing the statement
Field Name: USERS_OPEN
Data Element: ORUSROPEN
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 USERS_OPEN

ORAV_SQL-EXECUTIONS table field - Number of executions ▼

Description: Number of executions
Field Name: EXECUTIONS
Data Element: OREXECNUM
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

ORAV_SQL-USERS_EXEC table field - Number of users executing ▼

Description: Number of users executing
Field Name: USERS_EXEC
Data Element: ORUSREXEC
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 USERS_EXEC

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

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

ORAV_SQL-INVALIDATI table field - Invalidations for this child cursor ▼

Description: Invalidations for this child cursor
Field Name: INVALIDATI
Data Element: ORINVALID
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 INVALIDATI

ORAV_SQL-PARSE_CALL table field - Parse calls for this child cursor ▼

Description: Parse calls for this child cursor
Field Name: PARSE_CALL
Data Element: ORPARSEC
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 PARSE_CALL

ORAV_SQL-DISK_READS table field - Disk reads for this child cursor ▼

Description: Disk reads for this child cursor
Field Name: DISK_READS
Data Element: ORDISKR
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

ORAV_SQL-BUFFER_GET table field - Buffer gets for this child cursor ▼

Description: Buffer gets for this child cursor
Field Name: BUFFER_GET
Data Element: ORBUFFERG
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

ORAV_SQL-ROWS_PROCE table field - Number of rows parsed ▼

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

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

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

ORAV_SQL-OPTIM_COST table field - Cost of this query ▼

Description: Cost of this query
Field Name: OPTIM_COST
Data Element: ORAOPTCOST
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 OPTIM_COST

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

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

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

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

ORAV_SQL-TYPE_CHK_H table field - Descriptor of type ▼

Description: Descriptor of type
Field Name: TYPE_CHK_H
Data Element: ORATYPECHK
Data Type: RAW
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: ORARAW4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE_CHK_H

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

ORAV_SQL-PLAN_HASH_ table field - Numerical Representation of the SQL Plan ▼

Description: Numerical Representation of the SQL Plan
Field Name: PLAN_HASH_
Data Element: ORAPLANHAS
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 PLAN_HASH_

ORAV_SQL-CHILD_NUMB table field - Number of child cursor ▼

Description: Number of child cursor
Field Name: CHILD_NUMB
Data Element: ORACHILDNU
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_NUMB

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

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

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

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

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

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

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

ORAV_SQL-LAST_LOAD_ table field - Last Load Time ▼

Description: Last Load Time
Field Name: LAST_LOAD_
Data Element: ORALASTLOA
Data Type: CHAR
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: CHAR19
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_LOAD_

View list of all SAP tables(S4H/ECC)

Select data from SAP table